WampServer
Apache, PHP, MySQL
on Windows
Aller à : Liste des Forums•Liste des messages•Nouvelle discussion•Recherche•Connexion•Imprimer la vue
Sytaxe de connection php/MySQL
Envoyé par:
universalbitmapper
(---.net81-67-153.noos.fr)
Date: 03 October 2005 à 15:44
Bonjour,
J'ai un exemple de connection PHP/MySQL qui date de 2003:
<body style = "font-family: arial, sans-serif"
style = "background-color: #F0E68C">
<?php
extract( $_POST );
// build SELECT query
$query = "SELECT " . $select . " FROM Books";
// Connect to MySQL
if ( !( $database = mysql_connect( "localhost",
"httpd", "" ) ) )
die( "Could not connect to database" );
// open Products database
if ( !mysql_select_db( "Products", $database ) )
die( "Could not open Products database" );
// query Products database
if ( !( $result = mysql_query( $query, $database ) ) ) {
print( "Could not execute query! <br />" );
die( mysql_error() );
}
?>
<h3 style = "color: blue">
Search Results</h3>
<table border = "1" cellpadding = "3" cellspacing = "2"
style = "background-color: #ADD8E6">
<?php
// fetch each record in result set
for ( $counter = 0;
$row = mysql_fetch_row( $result );
$counter++ ){
// build table to display results
print( "<tr>" );
foreach ( $row as $key => $value )
print( "<td>$value</td>" );
print( "</tr>" );
}
mysql_close( $database );
?>
</table>
<br />Your search yielded <strong>
<?php print( "$counter" ) ?> results.<br /><br /></strong>
****************************************************************************
Est-il toujours valable avec Wamp sur XP Pro?
Merci d'avance
J'ai un exemple de connection PHP/MySQL qui date de 2003:
<body style = "font-family: arial, sans-serif"
style = "background-color: #F0E68C">
<?php
extract( $_POST );
// build SELECT query
$query = "SELECT " . $select . " FROM Books";
// Connect to MySQL
if ( !( $database = mysql_connect( "localhost",
"httpd", "" ) ) )
die( "Could not connect to database" );
// open Products database
if ( !mysql_select_db( "Products", $database ) )
die( "Could not open Products database" );
// query Products database
if ( !( $result = mysql_query( $query, $database ) ) ) {
print( "Could not execute query! <br />" );
die( mysql_error() );
}
?>
<h3 style = "color: blue">
Search Results</h3>
<table border = "1" cellpadding = "3" cellspacing = "2"
style = "background-color: #ADD8E6">
<?php
// fetch each record in result set
for ( $counter = 0;
$row = mysql_fetch_row( $result );
$counter++ ){
// build table to display results
print( "<tr>" );
foreach ( $row as $key => $value )
print( "<td>$value</td>" );
print( "</tr>" );
}
mysql_close( $database );
?>
</table>
<br />Your search yielded <strong>
<?php print( "$counter" ) ?> results.<br /><br /></strong>
****************************************************************************
Est-il toujours valable avec Wamp sur XP Pro?
Merci d'avance
Désolé, seuls les utilisateurs connectés peuvent envoyer des messages dans ce forum.
