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.

How to Solve an Error Message "Validation of viewstate MAC failed"

Viewed 10130 times since Tue, Apr 2, 2013

Sample Code to Send email using ASP.NET 2

Viewed 10172 times since Tue, May 1, 2012

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

Viewed 11303 times since Mon, Mar 27, 2017

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

Viewed 18179 times since Wed, Feb 17, 2016

What is the connection string for my MySQL database?

Viewed 4651 times since Mon, May 7, 2012

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

Viewed 3573 times since Mon, May 7, 2012

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

Viewed 4234 times since Thu, May 3, 2012

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

Viewed 32751 times since Mon, Apr 1, 2013

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

Viewed 11147 times since Mon, Apr 30, 2012

Can I set up additional logins for my MySQL database?

Viewed 3399 times since Mon, Apr 30, 2012

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