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>

<tr>

<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.

Issue with Storing Session

Viewed 4448 times since Tue, Mar 24, 2015

My application pool stops working. What is wrong with my site?

Viewed 14015 times since Sun, Feb 15, 2015

My site is showing 500 Internal Server error message. What is wrong here?

Viewed 4456 times since Thu, May 3, 2012

Do you allow custom COM components?

Viewed 3541 times since Tue, May 1, 2012

Can you grant SELECT PRIVILEGE to the system table mysql.proc

Viewed 6833 times since Mon, Jun 18, 2012

Sample Code to Send email using ASP.NET 2

Viewed 10362 times since Tue, May 1, 2012

My website session times out earlier than expected. Why?

Viewed 5621 times since Tue, May 1, 2012

Can i login to my MySQL database via my own mySQL tool?

Viewed 3853 times since Mon, May 7, 2012

How do I send an email from my ASP.NET website by using SMTP Authentication?

Viewed 7258 times since Tue, May 1, 2012

I cannot find a way to enable ASP.NET 4.5 on my Control Panel

Viewed 11669 times since Tue, Sep 11, 2012

KB Home \| Advanced Search \| News \| Glossary \| Login
ASP.NET Hosting Knowledge Base