Skriv til mysql

Eksempel:

<?PHP
# Opret forbindelse til database serveren
mysql_connect("localhost", $sql_user, $sql_password);

# Opret forbindelse til databasen
mysql_select_db("php00004");


# HVIS DER SKAL OPRETTES I DATABASEN
# ----------------------------------------------
if ($Type == "Opret")
mysql_query("INSERT INTO TestTable (DatoTid, Tekst) VALUES (NOW(), '$IndsaetTekst')");


# HVIS DER SKAL SLETTES FRA DATABASEN
# ----------------------------------------------
if ($Type == "Slet")
mysql_query("DELETE FROM TestTable WHERE ID != ''");


# UDSKRIV INDTASTNINGS FELTER
# ----------------------------------------------
echo "<table width=100%>";
echo "<form action='dbtest.php4' medthod=POST>";
echo "<input type=hidden name=Type value=Opret>";
echo "<tr><td width=20%>Skriv en kommentar:</td><td><input type=text size=20 maxlength=20 name=IndsaetTekst></td></tr>";
echo "<tr><td> </td><td><input type=submit value='Indsæt i databasen'></td></tr>";
echo "</form>";
echo "</table>";
echo "<br><br>";


# UDSKRIV FELT TIL SLETNING AF HELE DATABASEN
# ----------------------------------------------
echo "<form action='dbtest.php4'>";
echo "<input type=submit value='Slet hele databasen'>";
echo "<input type=hidden name=Type value=Slet>";
echo "</form>";


# UDSKRIV POSTERINGER FRA DATABASEN
# ----------------------------------------------
echo "<u><b>Følgende nedenstående linier er hentet direkte fra databasen:</b></u><br><br>";

# Indlaes alle posteringer i et array
$result = mysql_query("SELECT * FROM TestTable WHERE Tekst != '' ORDER BY ID DESC");

# Udskriv alle fundne posteringer
while ($row = mysql_fetch_array($result))
{
$ID = $row[ID];
$DatoTid = $row[DatoTid];
$Tekst = $row[Tekst];

echo "ID: $ID, $DatoTid: $Tekst<br>";
}

echo "<br>";

?>

<?
if($_POST[send]){
mysql_query("INSERT INTO tabel (ejendomstype, anvendelse) VALUES ('$_POST[ejendomstype]', '$anvendelse')");
}else{
?>
<form method="post" action="<? echo $_SERVER[PHP_SELF]; ?>">
<input type="hidden" name="ejedomstype" value="<? echo $ejendomstype; ?>">
<input type="hidden" name="anvendelse" value="<? echo $anvendelse; ?>">
<input type="submit" name="send" value="Send">
</form>
<?
}

?>

får følgende fejl:

Warning: mysql_connect(): Access denied for user: 'danestate.dk@localhost' (Using password: NO) in /customers/danestate.dk/danestate.dk/httpd.www/tjek.php on line 248

Warning: mysql_select_db(): Access denied for user: 'danestate.dk@localhost' (Using password: NO) in /customers/danestate.dk/danestate.dk/httpd.www/tjek.php on line 251

Warning: mysql_select_db(): A link to the server could not be established in /customers/danestate.dk/danestate.dk/httpd.www/tjek.php on line 251

prøv: mysql_connect("localhost", "root", "");

lukket