Category: Accessing MySQL Using PHP

Display last N number of records form MySql Database by selecting results in descending order using ID. Example

Whenever we have multiple form fields to search in database by using AND operator for the fields only for which form fields are filled. Here is the quick fix. Example

Step 1 : A HTML Page to Display a form (we are doing everything in this Page, so the code to retrieve the image + form data and to image upload all as :...

Many often there are problems where we have to repeat our MySql query to number of times. For this either we have to re execute our query again or set some method that query...

Step 1: Make a form page say index.php Step 2: Make a php page on which for data is submitting say abc.php Step 3: make a thank you page say newfile1.php

mysql result with row 0 is used to retrieve single result. Example :

Returns the string that results from concatenating the arguments. May have one or more arguments. See the following example : Basic table structure : Appending arguments at start of string : Appending arguments at...

Next, the code returns to the familiar territory of previous example where, in the following four lines of code, a query is sent to MySQL asking to see all the records in the classics...

Having loaded up the various possible variables that could have been posted with any values that were passed, the program then checks whether the variable $_POST[‘delete’] has a value. If so, the user has...

We mentioned in an earlier topics that a browser sends user input through either a GET request or a POST request. The POST request is usually preferred, and we use it here. The web...

MySql Table Structure (newrecords) Column Type Null Default Comments ID int(11) No      Name varchar(20) No      Class varchar(20) No      Complete Example

When you have finished using a database, you should close the connection. This is done by issuing the command : All database connections are automatically closed when PHP exits, so it doesn’t matter that...

It was important to show how you can fetch a single cell of data from MySQL, but now let’s look at a much more efficient method. So, replace the for loop of query.php with...

Once you have a resource returned from a mysql_query function, you can use it to retrieve the data you want. The simplest way to do this is to fetch the cells you want, one...

Step 1 : Make a form say xyz.html Step 2 : abc.php (to which form data is being received)

Sending a query to MySQL from PHP is as simple as issuing it using the mysql_query function. Consider the following Examples : First, the variable $query is set to the query to be made....