mysql Archive

How to Enable General Log in MariaDB

To enable General Log in MariaDB, you must change the following modification in my.ini. First find the my.ini and add the following code in [mysqld] general_log_file = D:\wamp64\logs\mariadb_general.log general_log = 1 Then Save the my.ini file and restart the mariadb or mysql server To Restart MYSQL or MariaDB Server $ sudo service mysql restart $

How to Enable Error Log in MariaDB

To enable Error Log in MariaDB, you must change the following modification in my.ini. First find the my.ini and add the following code in Then Save the my.ini file and restart the mariadb or mysql server To Restart MYSQL or MariaDB Server

What is MariaDB?

MariaDB is free and open source software under the General Public License version 2, one of the most popular database server in the world. Notable users: Wikipedia, wordpress.com, Google, Red Hat Inc, Tumblr, OLX, DBS Bank, Mozilla and More. MariaDB initially released on January 22, 2009, and written in C, C++, Perl & Bash Language.

How to Search item with two or more words or multiple words in php, MYSQL

Key Topics: How to Search item with two or more words or multiple words in php, search one or more words, search multiple words, php, Like, implode, explode, and, or, search words, search string, search keyword, search term, MYSQL, SQL ——————————————————————————————————– We can use “AND” or “OR” for search one or more words in php.

How to store checkbox values in mysql from php?

How to store checkbox values in mysql from php?   Solution <input type="checkbox" name="preference" value="Tragedic Facts"> <input type="checkbox" name="preference" value="Funny Facts"> <input type="checkbox" name="preference" value="Born Facts"> <input type="checkbox" name="preference" value="Death Facts"> <input type="checkbox" name="preference" value="Wierd Facts"> in php <?php $preference=$_POST[‘preference’]; foreach ($preference as $preferenceasname) { echo “$preferenceasname is checked”; } ?>