note 79650 deleted from ref.mysql by nlopess
| From: | nlopess@php.net | Date: | Thu, 06 Dec 2007 22:21:01 +0000 |
| Subject: | note 79650 deleted from ref.mysql by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-132903@lists.php.net to get a copy of this message | ||
Note Submitter: agosta
----
<?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>");
?>