Blattspinat
Erfahrenes Mitglied
ja ehm ... so weit bin ich nun in MySQL auch nicht ... ich frag einfach mal ... Bidde was???
Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
?? ich brauch die durchnumerierung ... weil das spätere script die IDs fortlaufend braucht...
$db = mysql_connect ($sqlhost,$username,$passwort);
mysql_select_db ($database);
$sql = "SELECT * FROM $table ";
$result = mysql_query($sql,$db);
$number = mysql_num_rows($result);
$sql="SELECT * FROM $table Order by id desc";
$result = mysql_query($sql,$db);
$Array[id] = $number +1;
$dbanfrage = "INSERT into $tabelle values ('$Array[id]', '$Array[url]')";
if (mysql_db_query ($dbname, $dbanfrage, $dbverbindung)) {
print ("
<center>
<table border=0 cellspacing=1 cellpadding=4 bgcolor=82A9D2>
<tr>
<td width=600 bgcolor=FFFFFF align=center>
<font size=2 face=Verdana>
Bild erfolgreich hinzugefügt!<br><br>
<a href=index.php?$session_name()=$session_id()?>[ Index ]</a>
</font>
</td>
</tr>
</table>
</center>
");
} else {
print ("Es traten Probleme auf.");
}
mysql_close ($dbverbindung);
}
else
{
echo "Fehler beim Zugriff auf die Datenbank";
}
?>
<html>
<head>
<title>Bild posten: Eintrag verarbeiten</title>
</head>
<body>
<center>
<link href="page.css" rel="stylesheet" media="screen">
<script language=Javascript src=script.js></script>
<script language=Javascript src=fade.js></script>
<script language=Javascript src=fade2.js></script>
<?php
session_start (); // Session starten.
if ((session_is_registered ("user_eingeloggt")) AND ($user_eingeloggt)) {
$sqlhost= 'localhost';
$username= 'XXXXX';
$passwort= '';
$database= 'XXXXX';
$table= 'pp_bildurls';
$db = mysql_connect ($sqlhost,$username,$passwort);
mysql_select_db ($database);
$sql = "SELECT * FROM $table Order by id desc";
$result = mysql_query($sql,$db);
$number = mysql_num_rows($result);
$result = mysql_query($sql,$db);
$Variable = $number +1;
$dbanfrage = "INSERT into $tabelle values ($Variable, '$Array[url])";
mysql_db_query ($dbname, $dbanfrage, $dbverbindung) or die (mysql_error());
}
else
{
echo "Nicht eingeloggt!";
}
?>
</body>
</html>
<?php
$sqlhost='localhost';
$username='xxxx';
$passwort='';
$database='xxxx';
$table='pp_bildurls';
$dbverbindung = mysql_connect ($sqlhost,$username,$passwort);
mysql_select_db ($database);
$sql="SELECT * FROM $table Order by id desc";
$result = mysql_query($sql,$dbverbindung);
$number = mysql_num_rows($result);
$Variable = $number +1;
$dbanfrage = "INSERT into $table values ('$Variable', '$Array[url]')";
mysql_db_query ($dbanfrage, $dbverbindung) or die (mysql_error());
?>