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.
|
How to solve ReportViewer error message: "An error has occurred during report processing. Input string was not in a correct format"
Viewed 7934 times since Tue, Jun 18, 2013
I cannot find a way to enable ASP.NET 4.5 on my Control Panel
Viewed 10802 times since Tue, Sep 11, 2012
My site is showing 500 Internal Server error message. What is wrong here?
Viewed 3385 times since Thu, May 3, 2012
Why do I suddenly receive the error message: "Compiler Error Message: The compiler failed with error code XXXXXXXXX"?
Viewed 16474 times since Wed, Feb 17, 2016
What is the connection string for my mariaDB database?
Viewed 1444 times since Fri, Jun 26, 2020
Do you support MySQL WebAdmin Access?
Viewed 3037 times since Tue, May 1, 2012
Sample Code to Send email using ASP.NET 2
Viewed 9309 times since Tue, May 1, 2012
HTTP Error 502.5 - Process Failure error message when publishing an ASP.NET Core Website
Viewed 10416 times since Mon, Mar 27, 2017
What is the connection string for my MySQL database?
Viewed 3859 times since Mon, May 7, 2012
How to solve the Let’s Encrypt SSL on ASP.NET Core
Viewed 9226 times since Mon, Jul 17, 2017
|