в 10:37, 26 мая 2010

2010-05-26T10:37:34Z

Admin: 1 версия

2010-05-26T07:06:15Z

1 версия

Новая страница

==A function to open a connection to mysql==



<source lang="html4strict">

<?php
function opendatabase ($host,$user,$pass) {
try {
if ($db = mysql_connect ($host,$user,$pass)){
return $db;
} else {
throw new exception ("Sorry, could not connect to mysql.");
}
} catch (exception $e) {
echo $e->getmessage ();
}
}

function closedatabase ($db){
mysql_close ($db);
}

$db = opendatabase ("localhost","root","");

try {
if (!mysql_select_db ("mydatabase",$db)){
throw new exception ("Sorry, database could not be opened.");
}
$myquery = "INSERT INTO mytable (id,title,myvalue) VALUES (0,"Blue",20)";

if (mysql_query ($myquery, $db)){
echo "We were successful.";
} else {
throw new exception (mysql_error());
}
} catch (exception $e) {
echo $e->getmessage();
}

closedatabase ($db);

?>

</source>

==Connecting to a MySQL Database==



<source lang="html4strict">

resource mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] )

<?php
try {
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpass = "";
if ($db = mysql_connect ($mysqlhost,$mysqluser,$mysqlpass)){
echo "Successfully connected to the database.";
mysql_close ($db);

} else {
throw new exception ("Sorry, could not connect to mysql.");
}
} catch (exception $e) {
echo $e->getmessage ();
}
?>

</source>

==Connecting user==



<source lang="html4strict">

<?php
$domain = "localhost";
$user = "userName";
$password = "password";
$conn = mysql_connect( $domain, $user, $password );
if($conn)
{
$msg = "Congratulations $user, You connected to MySQL";
}
?>
<html>
<head>
<title>Connecting user</title>
</head>
<body>
<h3>
<?php echo( $msg ); ?>
</h3>
</body>
</html>

</source>

==Creating databases==



<source lang="html4strict">

<?php
$conn = @mysql_connect( "localhost", "userName", "password" )
or die( "Sorry - could not connect to MySQL" );
$rs1 = @mysql_create_db( $_REQUEST["db"] );
$rs2= @mysql_list_dbs($conn);
$list = "";
for( $row=0; $row < mysql_num_rows( $rs2 ); $row++ )
{
$list .= mysql_tablename( $rs2, $row ) . " | ";
}
?>
<html>
<head>
<title>Creating databases</title>
</head>
<body>
<form action="<?php echo( $_SERVER["PHP_SELF"] ); ?> " method="post">
Current databases: <?php echo( $list ); ?>
<hr>
Name:<input type = "text" name = "db">
<input type = "submit" value = "Create database">
</form>
</body>
</html>

</source>

==When connecting to multiple MySQL servers, a link ID must be generated.==



<source lang="html4strict">

For example:
<?
$link1 = @mysql_connect("www.somehost.ru", "web", "abcde") or die("Could not connect to MySQL server!");
$link2 = @mysql_connect("www.someotherhost.ru", "usr", "secret") or die("Could not connect to MySQL server!");
?>

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/MySQL Database/mysql connect - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия