How to select multiple css classes in PHP XPATH: To parse the marked line at the image you want to filter for „col-xs-5 col-sm3“. Attention: They have to stay together! With this method you can’t parse for a css hierarchy! …
Es besteht eine Datenbank mit verschiedenen User Agents. Wie kann man sich diese nun anschaulich darstellen lassen? Folgender Befehl Ausgabe Nun bekommt man schön übersichtlich die verschiedenen User Agents absteigend nach der Anzahl der Aufrufe angezeigt.
How to use WP Toolset Custom Fields and Taxonomy Variables in Yoast SEO. Its very easy: For Custom Fields you use the field slug combined to that string: %%cf_wpcf-modell%% In my case modell is the custom field slug. For Taxonomy …
I had a look into the syslog file of my debian server and found out that there are innodb errors spamming the logfile. Error message mysqld[62708]: 2018-11-10 14:06:49 7fe0b5287b00 InnoDB: Error: Column last_update in table „mysql“.“innodb_table_stats“ is INT UNSIGNED NOT …
mysql prepared statements update php: You should use mysql prepared statements to prevent sql injections. $mysqli = new mysqli($servername, $username, $password, $username); Without prepared statement $sql = „UPDATE userlimits SET name = ‚$name‘, comment = ‚$comment‘, symbol = ‚$symbol‘, stocklimit …
When the following error appears at the zoneminder surveillance system: SQL-ERR ‚SQLSTATE[HY000]: General error: 1366 Incorrect integer value: “ for column ‚ServerId‘ at row 1 Zoneminder Error Solution nano /etc/mysql/mysql.conf.d/mysqld.cnf #insert at the end of the file sql_mode = NO_ENGINE_SUBSTITUTION service …
Das ist schon ein Prachtexemplar / maximale differenz berechnen $querymax = „SELECT s.value, s.symbol, u.stocklimit, u.name FROM stocks s INNER JOIN userlimits u ON (u.symbol = s.symbol AND u.userid = $userid) ORDER BY u.name ASC“; $resultmax = $mysqli->query($querymax); $maximum = …
How to select a single row/value with wpdb in WordPress: $check = $wpdb->get_row( $wpdb->prepare( „SELECT * FROM wp_posts WHERE id = ‚$postid‘ AND foobar = ‚1‘ ORDER BY ID DESC LIMIT 1“ ), ARRAY_A ); //print_r ($check); $time = $check[„timestamp“];
Wenn die Umlaute nicht richtig dargestellt werden bei einem selbstprogrammierten PHP / SQL Code: Solution: $mysqli->set_charset(„utf8“);
How to update the zoneminder database manually: After a new zoneminder update my webserver was ready. I host the database server on another virtual machine so i had to update the server manually. First i wanted to copy the zmupdate …