note 79650 added to ref.mysql
| From: | agosta at osu1 dot php dot net | Date: | Thu, 06 Dec 2007 17:05:09 +0000 |
| Subject: | note 79650 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-132896@lists.php.net to get a copy of this message | ||
<?php
$connect = mysql_connect();
$database["server"] = "sqlserver";
$database["user"] = "sqluser";
$database["password"] = "sqlpass";
$database["db"] = "autok";
//adatbázis létrehozás
if (mysql_create_db($database["db"])){
print("created.");
}
else{
print("failed. " . mysql_error());
}
//kapcsolódás
if (!$connect = \@mysql_connect($database["server"],$database["user"],
\$database["
password"]){
print("MYSQL problem. Connect to ".
\ $database["server"] . " failed");
}
if (!@mysql_select_db($database["db"], $connect)){
print("MYSQL problem. Failed to select " . $database["db"]);
}
//tábla létrehozása
$database["table"] = "autok";
$database["sql"] = "create table " . $database["table"] .
\"(rendszam char(7) not null, " . "tipus varchar not null, "
\. "evjarat int(4) unsigned not null" . "primary key (rendszam));";
if (mysql_query($database["sql"])){
print("<p>Table created.</p>");
}
else{
print("<p>Failed to create table. Error: " . mysql_error() .
"</p>");
}
//adatok feltöltése
$srand((double) microtime() * 1000000);
$rendszam = "aaa-333";
$evjarat = rand(1955,2007);
$tipus = "ford";
$sql = "insert into " . $database["table"] . " set updated=null,
\rendszam='" . $rendszam . "', tipus='" . $tipus . "',
evjarat ='" .
\$evjarat . "';";
if ($result = @mysql_query($sql)){
print("Success!");
}
else{
print("Error: " . mysql_errno() . ", " . mysql_error());
}
//megjelenÃtés
$database["sql"] = "select * from";
if (isset($database["database"]) and strlen($database["database"])){
$database["sql"] .= $database["table"] . ".";
}
$database["sql"] .= $database["table"];
$result = mysql_query($database["sql"];
print("<table border=\"1\">");
while ($row = mysql_fetch_row($result)){
if (!isset($field_array)){
$field_array = mysql result fields($result);
print("<tr>");
while (list($k, $v) = each($field array)){
print("<td><em>" . $v["name"] .
"</em></td>");
}
print("</tr>");
}
$fields = mysql_num_fields($result);
print("<tr>");
for ($i = 0; $i < $fields; $i++){
print("<td>" . $row[$i] . "</td>");
print("</tr>");
}
print("</table>");
?>
----
Server IP: 217.20.138.73
Probable Submitter: 87.97.25.136
----
Manual Page -- http://www.php.net/manual/en/ref.mysql.php
Edit -- https://master.php.net/note/edit/79650
Del: integrated -- https://master.php.net/note/delete/79650/integrated
Del: useless -- https://master.php.net/note/delete/79650/useless
Del: bad code -- https://master.php.net/note/delete/79650/bad+code
Del: spam -- https://master.php.net/note/delete/79650/spam
Del: non-english -- https://master.php.net/note/delete/79650/non-english
Del: in docs -- https://master.php.net/note/delete/79650/in+docs
Del: other reasons-- https://master.php.net/note/delete/79650
Reject -- https://master.php.net/note/reject/79650
Search -- https://master.php.net/manage/user-notes.php