Question:
How do you get data from database when you pick up item from database list?
Answer:
Here is a simple method for connecting to your MySql database and outputting some data.
<?php
#Connect to MySQL database
$db=mysql_connect("localhost","YourDatabaseUserName","YourDatabasePassword");
mysql_select_db("YourDatabaseName",$db) or die ("cant change");
#Select data from database table called customers.
$result = mysql_query("select * from customers Order By LastName, FirstName",$db);
while ($row = mysql_fetch_array($result))
{
$FirstName = $row["FirstName"];
$LastName = $row["LastName"];
echo "$LastName, $FirstName"; ?><br><?
}
?>
About the Author
Rich Agnew is an author for The Computer Geek Custom Web Page Design. The Computer Geek is a web design company that prides itself in professional service at a fraction of the cost. The Computer Geek specializes in Custom Web Design, PHP & MySql and Ecommerce.
We engaged The Computer Geeks in mid-2023 as they have a reputation for API integration within the T . . . [MORE].
We all have been VERY pleased with Adrian's vigilance in monitoring the website and his quick and su . . . [MORE].
FIVE STARS + It's true, this is the place to go for your web site needs. In my case, Justin fixed my . . . [MORE].
We reached out to Rich and his team at Computer Geek in July 2021. We were in desperate need of help . . . [MORE].
Just to say thank you for all the hard work. I can't express enough how great it's been to send proj . . . [MORE].
I would certainly like to recommend that anyone pursing maintenance for a website to contact The Com . . . [MORE].
How to Start a Successful
The Future of Blockchain
Tips for Improving Remote