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.

Do you support ASP.NET MVC 6?

Viewed 4974 times since Wed, Feb 17, 2016

How do I redirect a subdomain to a subdirectory?

Viewed 4257 times since Tue, May 1, 2012

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

Viewed 6742 times since Tue, May 1, 2012

How to solve ReportViewer error message: "An error has occurred during report processing. Input string was not in a correct format"

Viewed 8452 times since Tue, Jun 18, 2013

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

Viewed 10859 times since Mon, Apr 30, 2012

I cannot see my website. What should I do?

Viewed 4004 times since Thu, May 3, 2012

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

Viewed 3811 times since Thu, May 3, 2012

Issue with Storing Session

Viewed 3975 times since Tue, Mar 24, 2015

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

Viewed 11044 times since Mon, Mar 27, 2017

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

Viewed 9818 times since Mon, Jul 17, 2017

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