In the post, I would like to show you how to create post for wordpress without having to use the wordpress admin console. This will be done by creating the posts into the wordpress MySQL database

In this post, I am going to talk about how to get data from 2 mysql tables instead of 1 table with a sql.

Editor’s note: To create one HTML table is easy, but to create multiple HTML tables, We have to copy and paste the code many times. However we could do the job with a PHP for loop.

In this example, I am going to show you how to use PHP to change a MySQL database’s field size.

Editor’s note: In some cases, when you have forgotten to preset the MySQL database table encoding to UTF8 after the creation of the database but later you need to insert some UTF8 text such as Chinese or other Asian languages, here is how you could do with PHP to change the encoding of the MySQL database table.

Array is a good way to store many elements, in some operations you might like to store all of the array elements into different row of a table in a MySQL database. To store into different row, we can use a for loop to go through each elements and run a query to insert them 1 by 1. This example, I go show you to insert into different fields.