Posted by Shek on March 16, 2011 under MySQL | 
In this post, I am going to talk about how to get data from 2 mysql tables instead of 1 table with a sql.
Here are 2 mysql tables (The field types are ignored in this examples): Read more of this article »
Posted by Shek on November 23, 2008 under PHP |
Editor’s note: I mentioned 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 all field names (column names) of a table within a MySQL database.
Posted by Shek on June 30, 2008 under PHP |
Editor’s note: In some cases, you might like to check how many records in the MySQL database which matches the query you entered. Case such as a login system where you want to check if there is a record matches the user name and the password inputted , here is an example
Posted by Shek on May 19, 2008 under PHP |
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. Read more of this article »
Tags: Database, Display, HTML, HTML form, HTML form element, Loop, MySQL, PHP Function, Query, Text-field, While-loop
Posted by Shek on May 18, 2008 under PHP |
Editor’s note: In some cases which the user might need 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.
Tags: Button, Database, Empty, HTML, HTML form, HTML form element, MySQL, PHP Function, Query, Submit-button, Table, Text-field
Posted by Shek on May 16, 2008 under PHP |
Editor’s note: In a login system, there are user names and passwords stored in the MySQL database. The passwords are normally stored as strings inside the database. To have a more security way to store the passwords in the database, it is better to store an encrypted version of the password, therefore only the password creator knows what the password is.
MD5 is the encryption technology I like to use because it is very easy to implement and it encrypts a string into a 32-character strings, for reference what MD5 really is, please check Wikipedia-MD5.
Read more of this article »
Tags: Button, Database, Encryption, HTML, HTML form, HTML form element, Insert, MD5, MySQL, Password, PHP Function, Query, Submit-button, Text-field
