| Home » Categories » Multiple Categories |
How do I query MySQL Database in PHP ? |
|
Article Number: 86 | Rating: Unrated | Last Updated: Tue, May 1, 2012 at 11:21 PM
|
| Please follow the following guidelines: <html>
<head>
<title>MySQL Test Code</title>
</head>
<body>
<h1>MySQL Test Code Results</h1>
<p>
<table border="1">
<tr>
<td>pkID</td>
<td>username</td>
<td>password</td>
</tr>
<?php
/*
* Configuration Information and Definitions
*/
$mysql_host = mysql01.discountasp.net;
$mysql_user = username;
$mysql_pass = password;
$mysql_db = database;
$query = SELECT * from table1;
mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Connection to MySQL-server failed!");
mysql_select_db($mysql_db) or die("Selection of database $mysql_db failed!");
$result = mysql_query($query) or die("Invalid Query, " . mysql_error());
while( list( $pkid, $user, $pass ) = mysql_fetch_row($result) )
{
printf("<tr><td>%d</td><td>%s</td><td>%s</td></tr>", $pkid, $user, $pass);
}
?>
</table>
</p>
<h1>End MySQL Test Code Results</h1> |
Attachments
There are no attachments for this article.
|
Related Articles 
I get an error Server.CreateObject Failed when I try to use CDONTs. What can I do?
Viewed 3266 times since Tue, May 1, 2012
My site is showing 500 Internal Server error message. What is wrong here?
Viewed 3945 times since Thu, May 3, 2012
Do you support ASP.NET MVC 6?
Viewed 5155 times since Wed, Feb 17, 2016
What is the connection string for my MySQL database?
Viewed 4567 times since Mon, May 7, 2012
How to solve the Let’s Encrypt SSL on ASP.NET Core
Viewed 10045 times since Mon, Jul 17, 2017
Can I set up additional logins for my MySQL database?
Viewed 3289 times since Mon, Apr 30, 2012
My website session times out earlier than expected. Why?
Viewed 5322 times since Tue, May 1, 2012
How to Solve the error: "405 - HTTP verb used to access this page is not allowed"?
Viewed 5782 times since Wed, Oct 24, 2018
About Azure Key Vault
Viewed 2163 times since Mon, Nov 2, 2020
Do you support MySQL WebAdmin Access?
Viewed 3593 times since Tue, May 1, 2012
|
Subscribe to Article
Print Article-
Email Article to Friend
Export to PDF
Export to MS Word
Tweet This Article
Digg It
Stumble Upon
Del.icio.us