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.

My website session times out earlier than expected. Why?

Viewed 5510 times since Tue, May 1, 2012

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

Viewed 33042 times since Mon, Apr 1, 2013

How do I query MySQL database in ASP.NET?

Viewed 13199 times since Tue, May 1, 2012

What is the connection string for my mariaDB database?

Viewed 2484 times since Fri, Jun 26, 2020

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

Viewed 18373 times since Wed, Feb 17, 2016

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

Viewed 3705 times since Mon, May 7, 2012

What is the connection string for my MySQL database?

Viewed 4775 times since Mon, May 7, 2012

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

Viewed 4362 times since Thu, May 3, 2012

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

Viewed 11286 times since Mon, Apr 30, 2012

How to solve the Let’s Encrypt SSL on ASP.NET Core

Viewed 10358 times since Mon, Jul 17, 2017

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