Simple tutorial!
Prerequisite Knowledge: Basic PHP, and MySQL
Prerequisite Stuff: A server that can run both PHP and MySQL(here is a simple way to set up the same on your system)
Prerequisite Knowledge: Basic PHP, and MySQL
Prerequisite Stuff: A server that can run both PHP and MySQL(here is a simple way to set up the same on your system)
Step 1: Create a MySQL conenction!
- Define 3 string variables to define, the database host name, username and password
- $dbhost = 'localhost'; //enter your hostname under quotes;
- $dbuser='myuser'; //enter your database user name in the quotes;
- $dbpass='mypassword; //enter your database user password;
- Create a MySQL connection using mysql_connect() function
- $connection = mysqli_connect($dbhost,$dbuser,$dbpass);
- if(!$connection) echo 'cannot connect to database'; //Checks whether connection is made
Step 2: Select the required database
- Define a string variable with database name:
- $dbname='mydatabse' // Enter your name of database under quotes
- Select the databse using mysql_select_db() function
- $select = mysqli_select_db($connection,$dbname) or die('cannot select database');
- The die function checks whether the database could be selected or not
Step 3: Lets run the query
- Define a string variable for query.
- $query = 'SELECT * FROM table'; //put your MySQL query in quotes
- Run the query using mysql_query() function.
- $query = mysql_query($query)
- We define the variable to get the result from MySQL.
Enjoy! Happy coding. Practice the code by understanding it. Yup, I did not include a sum up, understand and code it yourself! You can do it, trust me!
More coding at Let's Code!
Edit: Modified with mysqli extension.
