I mentioned before in my previous post Display data from MySQL with PHP which I demonstrated how to display the data of a row within a table, now I want to demonstrate how to display and print out all field names (column names) of a table within a MySQL database. Continue Reading →

Sometimes, you might like to check how many records in the MySQL database matches the query you entered. This case happen often in a login system where you want to check if there is a record matches the user name and the password with what the user typed in, here is an example I have created to show you how to do so. Continue Reading →

In my past post on explaining how to set the default values of the text field. Now to use the same concept, we could get the records from the MySQL database and place it into the text field as default text. Here I have created an example to show you how to do so. Continue Reading →

Sometimes you might like to empty a table in the MySQL database. Instead of deleting every record in the MySQL database, you could run a query “truncate table ‘tablename’” to do the job. involving a HTML form is a good idea for the user. Continue Reading →