Media13.com is a source of free to republish or reprint articles, writers may submit your articles in our database as long so you agree that your article will be freely republish or reprint by other.

Submit Article

Search our database

Received article from us.

Name

Email Address

Friends

Bollywood News
Link building
Article submission service
Freelance Writers
Laser hair removal

We have been looking for freelance writers. Contact us

MySQL Database Handling in PHP by John L

Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data in order for the customer to perform the check â€“ the customerâ€™s personal login details; and the customerâ€™s purchased items. This data can be stored in two types of storage â€“ flat files or databases.

Flat files are only feasible in very low to low volume websites as flat files have 3 inherent weaknesses:

1.The inability to index the data. This makes it necessary to potentially read ALL the data sequentially. This is a major problem if there are a lot of records in the flat file because the time required to read the flat file is proportionate to the number of records in the flat file.

2.The inability to efficiently control access by users to the data

3.The inefficient storage of the data. In most cases, the data would not be encrypted or compressed as this would exacerbate the problem no. 1 above

The alternative which is, in my opinion, the only feasible method, is to store the data in a database. One of the most prevalent databases in use is MySQL. Data that is stored in a database can easily be indexed, managed and stored efficiently. Besides that, most databases also provide a suite of accompanying utilities that allow the database administrator to maintain the database â€“ for example, backup and restore, etc.

Websites scripted using PHP are very well suited for the MySQL database as PHP has a custom and integrated MySQL module that communicates very efficiently with MySQL. PHP can also communicate with MySQL through the standard ODBC as MySQL is ODBC-compliant, However, this will not be as efficient as using the custom MySQL module for PHP.

The rest of this article is a tutorial on how to use PHP to:

1.Connect to a MySQL database

2.Execute standard SQL statements against the MySQL database

Starting a Session with MySQL

Before the PHP script can communicate with the database to query, insert or update the database, the PHP script will first need to connect to the MySQL server and specify which database in the MySQL server to operate on.

The mysql_connect() and mysql_select_db() functions are provided for this purpose. In order to connect to the MySQL server, the server name/address; a username; and a valid password is required. Once a connection is successful, the database needs to be specified.

The following 2 code excerpts illustrate how to perform the server connection and database selection:

@mysql_connect(`[servername]`, `[username]`, `[password]`) or die(`Cannot connect to DB!`);

@mysql_select_db(`[databasename]`) or die(`Cannot select DB!`);

The @ operator is used to suppress any error messages that mysql_connect() and mysql_select_db() functions may produce if an error occurred. The die() function is used to end the script execution and display a custom error message.

Executing SQL Statements against a MySQL database

Once the connection and database selection is successfully performed, the PHP script can now proceed to operate on the database using standard SQL statements. The mysql_query() function is used for executing standard SQL statements against the database. In the following example, the PHP script queries a table called tbl_login in the previously selected database to determine if a username/password pair provided by the user is valid.

Assumption:

The tbl_login table has 3 columns named login, password, last_logged_in. The last_logged_in column stores the time that the user last logged into the system.

// The $username and $passwd variable should rightly be set by the login form

// through the POST method. For the purpose of this example, weâ€™re manually coding it.

$username = â€śjohnâ€ť;

$passwd = â€śmypasswordâ€ť;

// We generate a SELECT SQL statement for execution.

$sql=`SELECT * FROM tbl_login WHERE login = ``.$username.`` AND password = ``.$passwd.```;

// Execute the SQL statement against the currently selected database.

// The results will be stored in the $r variable.

$r = mysql_query($sql);

// After the mysql_query() command executes, the $r variable is examined to

// determine of the mysql_query() was successfully executed.

if(!$r) {

$err=mysql_error();

print $err;

exit();

}

// If everything went well, check if the query returned a result â€“ i.e. if the username/password

// pair was found in the database. The mysql_affected_rows() function is used for this purpose.

// mysql_affected_rows() will return the number of rows in the database table that was affected

// by the last query

if(mysql_affected_rows()==0){

print `Username/password pair is invalid. Please try again.`;

}

else {

// If successful, read out the last logged in time into a $last variable for display to the user

$row=mysql_fetch_array($r);

$last=$row[`last_logged_in`];

print â€śLogin successful. You last logged in at â€ť.$last.â€ť.â€ť;

}

The above example demonstrated how a SELECT SQL statement is executed against the selected database. The same method is used to execute other SQL statements (e.g. UPDATE, INSERT, DELETE, etc.) against the database using the mysql_query() and mysql_affected_rows() functions.

Author Info:

This PHP scripting article is written by John L. John L is the Webmaster of The Ultimate BMW Blog! (http://www.bimmercenter.com).

The Ultimate BMW Blog!

Latest 20 articles

Why Should I Hire a Seattle Real Estate Attorney? In every real estate transaction there are a wide variety of legal issues that must be taken care of. Contracts should always be reviewed by an attorney who understands the nuances of real estate law. But there are also state specific State laws to contend with. A Seattle real estate lawyer deals with a large number of State legal issues related to acquiring, financing, developing, managing, co

California IT Professionals – In Need of California Class Action Attorneys! It is hard to miss the wave of California wage and hour litigation related to California IT professionals and Computer employee overtime that has been sweeping California recently. Even the largest software and computer companies have paid out millions of dollars to employees wrongfully classified as “exempt”, or in other words, not entitled to overtime. A layperson would believe that with pr

Protect Your Mental Health With A Payday Loan Just when you thought that things couldn’t get any worse, more banks went under. More countries are declaring economic crisis. It seems that the world’s financial problems are bound to get worse. Even if you do not have considerable investments in various banks, I am sure that you are feeling the stress that results from these economic upheavals. I sure am. I am just an average person, with a

Free Bulk SMS services People are getting very busy these days without having enough time to talk unless it is very important. Mobile SMS have supported this need to contemporary times as now people do not want to call and enter in the unproductive conversation before coming up to the actual issue. SMS provides you the benefit to come straight to the point and also saves money. What if you get this totally free?

HELP – I Have IRS Levy Problems! If IRS collection notices are ignored, the IRS is forced to collect from taxpayers by force. They do this with their dreaded IRS levy. By law, the IRS has the right to levy bank accounts (IRS bank levy), garnish your paychecks (IRS wage levy), or even seize your assets. But you do not have to let the IRS bully you or your family. There are ways to stop an IRS levy. The first step is to know the

Why Use Professional Tax Debt Help? Good IRS tax relief is hard to find and for people with complicated tax issues, it is an absolute necessity. But how do you know which tax reduction firm is the best one to try? How can you be sure you're going to get the tax debt help that you need? And why is it so vital to receive help from professionals? Settling Your IRS Tax Debt For Less When your IRS tax debt is spiraling out

IRS Settlement – Can You Really Settle Your IRS Tax Debt for Less? It's possible to settle your IRS tax debt, but it presents a challenge. Proving you can settle your tax debt for less is a daunting experience. You have to contend with pages of IRS paperwork rife with technical terms. Settling tax debt is indeed a reality and it can be done. However, there's a lot you need to know before you attempt to settle your IRS tax debt. Rebuking the Lies - The

IRS Tax Relief – The Most Popular IRS Tax Relief Solutions Tax law provides many solutions for resolving tax debt. But if you were to contact the IRS directly, they would only alert you to one solution, and that's paying the tax debt in full. Here are five popular IRS tax relief solutions you should know about to be more informed. IRS Tax Settlement It is possible to settle your IRS tax debt. But there are some pitfalls you need to know. Fi

Hire the California Labor Board or California Labor Law Attorneys - You Decide With a downturn in the economy, many employers are cutting back on payroll. Unfortunately, some employers are reducing payroll costs by violating the California overtime laws. When this occurs, employees have essentially two options to recover their California overtime pay: the California labor board, or hiring California labor law attorneys. Although the California Labor Board is a commonly

Hiring a Car At Bangalore - Is More of Necessity Than A Luxury Your sedan is probably the best materialistic thing that you own and while going to a new place, that is what you ought to miss the most but if you are going to Bangalore then you probably have a option of getting a replacement so that you don’t miss it all that most because it will be as comfortable and as obedient as your own car and the Bangalor

How to Choose a Car Rental Company in Bangalore Bangalore is a place that lists one of the best as far as infrastructure is considered in India as it is the IT hub of India and thus the roads to drive is atmost pleasure and thus if Bangalore is the destination that you are planning for next then the best way to move around is by hiring a car. To hire is car is very simple if it is in Bangalore because there are some very good car rental compani

Car Rental Companies in Bangalore If you are travelling to Bangalore and hiring a car is what worrying you then you can be relaxed because this is one service that you will easily get in Bangalore and that too at very affordable and economic prices. Basically there are really good car rental companies in Bangalore available for renting the cars and you can either book in advance or go there and hire a car for yourself. Also, you h

Tips to Hire a Car in Bangalore One thing that most of us agree is that the fact that the most comfortable way to move around at any place is by your own vehicle but what if you are going to a new place, it is not possible to carry your vehicle along with you and you actually cannot trust too much on the public transportation system and at such situation the best possible option is to hire a car for yourself, at some places it c

Hire a Car: Comfortable Way to explore Bangalore If you are out to a new place than the first thing that comes into your mind is a comfortable accommodation and then the second one on the priority list is a comfortable way to move around in the city and if Bangalore is your preferred location, than you’ll be having options for both of the facilities, but if we specifically speak about the second one that is moving comfortably than the best opti

Car Rental – A convenient mode of transport in Bangalore Bangalore, a place which probably is considered one of the best places in India as far as infrastructure is considered and reasons are many for that, one is because of the IT hub that it is and also because it is one of very good places if you are considering holidays and because of this very good facility provided for the people visiting Bangalore is that you have many options in case if you are

Rent a Car in Bangalore: Take the Right Decision In today’s world, time is money; the more you save it better it is for you. And in that case if you are going to another place where you are not too familiar with the surroundings, then instead of wasting time on travelling by locating and travelling by public transport is to hire a vehicle for yourself. This helps in many ways, one it saves on time and also it moves at your pace so you don’t have

Bangalore Car Rental: Save Your Time When you are at an unknown place or for that matter known place and time is your major factor of concern then, the best way to save on time is by having your own vehicle for conveyance. This gives you freedom to move at your own pace and wish. And for that matter if you are at a place like Bangalore where the roads are so beautiful that it is a sheer pleasure to travel through your own rented vehi

Best Package Tours to Kerala Kerala – God’s own country which means heaven for those who appreciate the real untouched, naďve beauty of nature and if you are one of those than consider Kerala as the option for you next holiday. Kerala gives an option to explore the nature to the fullest because it has all the places where you can explore the nature be it scenic beaches or the hill stations or the ethnic culture, just everythi

Kerala Tour: A Getaway from Regular Stress If you are tired of daily stress and meetings and looking for a getaway so that you snatch some time for yourself with your loved one’s than Kerala holidays is the perfect is the perfect thing for you. Its calmness and closeness to nature would give you that much needed peace of mind that you always wanted. Also along with enjoying the beauty of this scenic place on your holidays to Kerala you can

Kerala Tour Packages: Have A Look If holidays are on your mind, then Kerala is one option that you cannot choose to neglect. Because Kerala is one place that offers you all from calm and serene natural places to exciting sports to exotic beaches and also beautiful hill stations, everything provided at one place which is also known as god’s own country. And obviously such wide range of activities would make it a tough job to cover