\$dbh = @mysql_connect(\$host, \$username, \$password)
\n";
echo " or die('Keine Verbindung möglich: ' . mysql_error());
\n";
echo "mysql_select_db(\$db);
\n";
echo "// @ unterdrückt Fehlermeldungen
\n
\$query = 'SQL-Befehl';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "...
\n";
echo "...Mach etwas mit den über das Statementhandle zugänglichen Dingen!
\n";
echo "...
\n";
echo "mysql_free_result(\$sth);
\n
\$query = 'show databases';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "while ( \$row = mysql_fetch_array(\$sth,MYSQL_ASSOC) ) {
\n";
echo " foreach (\$row as \$ind) {
\n";
echo " echo '\\\$row hat \\\$ind \$ind ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "// MYSQL_ASSOC: die Elemente des Feldes sind die Spaltennamen
\n";
echo "// MYSQL_NUM: die Elemente des Feldes sind Zahlen von 0 bis n
\n";
echo "
\n
";
$query = "show databases"; // Die Variable $query enthaelt einen SQL-Befehl!
$sth = mysql_query($query); // sth = statement handle
while ( $row = mysql_fetch_array($sth,MYSQL_ASSOC) ) { // Hole Zeile fuer Zeile aus der Tabelle!
foreach ($row as $ind) { // Mach was mit allen Spalten!
echo "\$row hat \$ind $ind \n"; // Oops! Die Zeilen haben nur eine Spalte!
$db = $ind; // Merk dir die letzte Datenbank fuer weitere Verwendung unten!
}
echo "
\n";
}
mysql_free_result($sth);
echo "
\$query = 'show tables FROM \$db';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "while ( \$row = mysql_fetch_array(\$sth,MYSQL_ASSOC) ) {
\n";
echo " foreach (\$row as \$ind) {
\n";
echo " echo '\\\$row hat \\\$ind \$ind ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "// MYSQL_ASSOC und MYSQL_NUM
\n";
echo "
\n
";
$sth = mysql_query("show tables FROM $db"); // Ohne $query fuer den SQL-Befehl
while ( $row = mysql_fetch_array($sth,MYSQL_ASSOC) ) { // Hole Zeile fuer Zeile aus der Tabelle!
foreach ($row as $ind) { // Mach was mit allen Spalten!
echo "\$row hat \$ind $ind "; // Oops! Die Zeilen haben nur eine Spalte!
$table = $ind; // Merk dir die letzte Tabelle fuer weitere Verwendung unten!
}
echo "
\n";
}
mysql_free_result($sth);
echo "
\$query = 'show columns FROM \$table FROM \$db';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "while ( \$row = mysql_fetch_array(\$sth,MYSQL_NUM) ) {
\n";
echo " for (\$i = 0; \$i < count(\$row); \$i++) {
\n";
echo " echo '\\'\$row[\$i]\\', ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "
\n
";
$query = "show columns FROM $table FROM $db";
$sth = mysql_query($query);
while ( $row = mysql_fetch_array($sth,MYSQL_NUM) ) {
for ($i = 0; $i < count($row); $i++) { // Jetzt einmal mit einer for-Loop!
echo "'$row[$i]', ";
}
echo "
\n";
}
mysql_free_result($sth);
echo "
\$query = 'SELECT * FROM \$db.\$table';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "while ( \$row = mysql_fetch_row(\$sth) ) {
\n";
echo " for (\$i = 0; \$i < count(\$row); \$i++) {
\n";
echo " echo '\\'\$row[\$i]\\', ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "
\n
";
$query = "SELECT * FROM $db.$table";
$sth = mysql_query($query);
while ( $row = mysql_fetch_row($sth) ) {
for ($i = 0; $i < count($row); $i++) {
echo htmlentities($row[$i],ENT_QUOTES,'UTF-8').", ";
}
echo "
\n";
}
mysql_free_result($sth);
echo "
\$query = 'SELECT * FROM \$db.\$table LIMIT 2';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "while ( \$row = mysql_fetch_row(\$sth) ) {
\n";
echo " for (\$i = 0; \$i < count(\$row); \$i++) {
\n";
echo " echo '\\'\$row[\$i]\\', ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "
\n
";
$query = "SELECT * FROM $db.$table LIMIT 2";
$sth = mysql_query($query);
while ( $row = mysql_fetch_row($sth) ) {
for ($i = 0; $i < count($row); $i++) {
echo htmlentities($row[$i],ENT_QUOTES,'UTF-8').", ";
}
echo "
\n";
}
mysql_free_result($sth);
echo "
\$query = 'SELECT * FROM \$db.\$table LIMIT 2';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "while ( \$aref = mysql_fetch_assoc(\$sth) ) {
\n";
echo " foreach ( @\$aref as \$ind) {
\n";
echo " echo '\\'\$ind\\', ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "
\n
";
$query = "SELECT * FROM $db.$table LIMIT 2";
$sth = mysql_query($query);
while ( $aref = mysql_fetch_assoc($sth) ) {
foreach ( @$aref as $ind) {
echo htmlentities($ind,ENT_QUOTES,'UTF-8').", ";
}
echo "
\n";
}
mysql_free_result($sth);
echo "
\$query = 'SELECT * FROM \$db.\$table';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "for (\$i = 0; \$i < mysql_num_fields(\$sth); \$i++) {
\n";
echo " \$field_name = mysql_field_name(\$sth,\$i);
\n";
echo " echo '\\'\$field_name\\', ';
\n";
echo "}
\n";
echo "echo '<br>';
\n";
echo "mysql_free_result(\$sth);
\n";
echo "
\n
";
$query = "SELECT * FROM $db.$table";
$sth = mysql_query($query);
for ($i = 0; $i < mysql_num_fields($sth); $i++) {
$field_name = mysql_field_name($sth,$i);
echo "'$field_name', ";
}
echo "
\n";
mysql_free_result($sth);
echo "
\$query = 'SELECT * FROM \$db.\$table LIMIT 2';
\n";
echo "\$sth = mysql_query(\$query);
\n";
echo "for (\$i = 0; \$i < mysql_num_fields(\$sth); \$i++) {
\n";
echo " \$field_name = mysql_field_name(\$sth,\$i);
\n";
echo " echo '\\'\$field_name\\', ';
\n";
echo "}
\n";
echo "echo '<br>';
\n";
echo "
\n";
echo "while ( \$row = mysql_fetch_array(\$sth,MYSQL_NUM) ) {
\n";
echo " for (\$i = 0; \$i < count(\$row); \$i++) {
\n";
echo " echo '\\'\$row[\$i]\\', ';
\n";
echo " }
\n";
echo " echo '<br>';
\n";
echo "}
\n";
echo "mysql_free_result(\$sth);
\n";
echo "
\n
";
$query = "SELECT * FROM $db.$table LIMIT 2";
$sth = mysql_query($query);
for ($i = 0; $i < mysql_num_fields($sth); $i++) {
$field_name = mysql_field_name($sth,$i);
echo "'$field_name', ";
}
echo "
\n";
while ( $row = mysql_fetch_array($sth,MYSQL_NUM) ) {
for ($i = 0; $i < count($row); $i++) {
echo htmlentities($row[$i],ENT_QUOTES,'UTF-8').", ";
}
echo "
\n";
}
mysql_free_result($sth);
echo "
mysql_close(\$dbh);
\n