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.

I receive this error message: "Directory Listing Denied. This Virtual Directory does not allow contents to be listed."

Viewed 11321 times since Mon, Apr 30, 2012

How To Solve Problem with Connection String on EF (Entity Framework) 4 or above

Viewed 33086 times since Mon, Apr 1, 2013

Sample Code to Send email using ASP.NET1.1

Viewed 5999 times since Tue, May 1, 2012

How do I query MySQL database in ASP.NET?

Viewed 13221 times since Tue, May 1, 2012

Sample Code to Send email using ASP.NET 2

Viewed 10296 times since Tue, May 1, 2012

Domain Name Server (DNS) Amplification Attack

Viewed 10077 times since Wed, Oct 15, 2014

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

Viewed 6755 times since Mon, Jun 18, 2012

About Azure Key Vault

Viewed 2510 times since Mon, Nov 2, 2020

How to Deploy and host .Net Core 2 and Angular 6 app

Viewed 14136 times since Tue, Oct 23, 2018

Do you support ASP.NET MVC 6?

Viewed 5517 times since Wed, Feb 17, 2016

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