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.

HTTP Error 502.5 - Process Failure error message when publishing an ASP.NET Core Website

Viewed 11371 times since Mon, Mar 27, 2017

Domain Name Server (DNS) Amplification Attack

Viewed 9980 times since Wed, Oct 15, 2014

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

Viewed 13811 times since Sun, Feb 15, 2015

Issue with Storing Session

Viewed 4293 times since Tue, Mar 24, 2015

Sample Code to Send email using ASP.NET 2

Viewed 10227 times since Tue, May 1, 2012

Why do I suddenly receive the error message: "Compiler Error Message: The compiler failed with error code XXXXXXXXX"?

Viewed 18283 times since Wed, Feb 17, 2016

Do you support MySQL WebAdmin Access?

Viewed 3749 times since Tue, May 1, 2012

I cannot see my website. What should I do?

Viewed 4305 times since Thu, May 3, 2012

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

Viewed 6687 times since Mon, Jun 18, 2012

Sample Code to Send email using ASP.NET1.1

Viewed 5934 times since Tue, May 1, 2012

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