Determine the PHP version on your server In this lesson, we are going to learn how to determine the PHP version running on our server using codes. Just follow these simple steps: Open any text editor (notepad, notepad ++, etc.).…
PHP
PHP scripting language. PHP syntax, lessons and sample sourcecode.
PHP Tutorials Compilation
PHP Tutorials Compilation Here are the list of our PHP Lessons and Tutorials Introduction to PHP scripting language PHP Tutorial – Learning the PHP Syntax PHP Tutorial – PHP Basic Data types PHP Variables PHP String Variable PHP if statement…
PHP-MySQL Lesson: DELETE statement
DELETE statement In this lesson we are going to write a PHP script that deletes records in MySQL database using the DELETE statement. We can execute any sql query like insert, update, delete, select etc. using the mysql_query() function. In…
PHP-MySQL Lesson: UPDATE statement
UPDATE statement In this lesson we are going to write a PHP script that updates records in MySQL database using the UPDATE statement. Parameter of UPDATE command: UPDATE – Performs an update MySQL query SET – Updates (assigns new value…
PHP-MySQL Lesson: The ORDER BY Clause
The ORDER BY Clause In this lesson we are going to write PHP scripts that select a records in MySQL and sort it using the ORDER BY clause. Using ORDER BY clause we can sort the data in a recordset…
PHP-MySQL Lesson: The Where Clause
The Where Clause In this lesson we are going to write PHP scripts that select a specific records in MySQL using the WHERE clause Using WHERE clause we can specify a selection criteria to select, update,delete required records from a…
PHP-MySQL Lesson: Select Data in Database and Display the record in HTML table
PHP-MySQL Lesson: Select Data in Database and Display the record in HTML table In this lesson we are going to write PHP scripts that select records in MySQL database and display it in HTML table. The SELECT statement in sql…
PHP-MySQL Lesson: Insert records
Insert records In this lesson we are going to write a PHP script that inserts a new record in our database through HTML forms. The INSERT INTO statement in sql is used to insert a record in the database. In…
PHP-MySQL Lesson: Select Database
Select Database After we have establish the connection in MySQL server, we have to select a database. To do that we are going to use the mysql_select_db() function. Syntax: mysql_select_db(databasename,connection) Parameter: databasename – the database name you want to use.…
PHP-MySQL Lesson – Create Table
Creating a Table In this lesson we are going to write a PHP script that will create a table in our MySQL database. To create a table in MySQL, use the command CREATE TABLE tablename. In PHP,mysql_query() function is used to execute…