Creating a Login File
Most websites developed with PHP contain multiple program files that will require access to MySQL […]
Accessing MySQL Using PHP
Connecting to MySQL
Now that you have the login.php file saved, you can include it in any PHP […]
Selecting a database
Having successfully connected to MySQL, you are now ready to select the database that you […]
Building and executing a query
Sending a query to MySQL from PHP is as simple as issuing it using the […]
php form insert data into mysql database
Step 1 : Make a form say xyz.html Step 2 : abc.php (to which form […]
Fetching results from database
Once you have a resource returned from a mysql_query function, you can use it to […]
Fetching a row
It was important to show how you can fetch a single cell of data from […]
Closing database connection
When you have finished using a database, you should close the connection. This is done […]
Fetching from database (a complete example)
MySql Table Structure (newrecords) Column Type Null Default Comments ID int(11) No Name […]
The $_POST Array
We mentioned in an earlier topics that a browser sends user input through either a […]
Deleting a Record
Having loaded up the various possible variables that could have been posted with any values […]
Querying the Database
Next, the code returns to the familiar territory of previous example where, in the following […]
concat function mysql
Returns the string that results from concatenating the arguments. May have one or more arguments. […]
getting single result from mysql in php
mysql result with row 0 is used to retrieve single result. Example :
avoid form submisison again in php,mysql
Step 1: Make a form page say index.php Step 2: Make a php page on […]
Use mysql query twice (seeking resultset to beginning of records)
Many often there are problems where we have to repeat our MySql query to number […]
- 1
- 2