mySQL database server

[Anon]

hallo,

I have opened an acount on freedom2surf. I have also requested a database.
I am running a flash movie which gets variables from a database via the following PHP script:

<?PHP
if ($command=="view"){
$info=file("grafices.db");
$max=sizeof($info);
for ($i=0;$i<$max;++$i){
$temp=explode("||",$info[$i]);
echo("&name".($i+1)."=".$temp[0].
"&email".($i+1)."=".$temp[1].
"&date".($i+1)."=".$temp[2].
"&year".($i+1)."=".$temp[3].
"&time".($i+1)."=".$temp[4].
"&message".($i+1)."=".$temp[5]);
}
echo("&max=".$max);
}
if ($command=="sign"){
if ($name!="" && $message!=""){
$fp=fopen("grafices.db","a");
fputs($fp, rawurlencode(StripSlashes($name))."||".
rawurlencode(StripSlashes($email))."||".
rawurlencode(date("M d"))."||".
rawurlencode(date("Y"))."||".
rawurlencode(date("H:i"))."||".
rawurlencode(StripSlashes($message))."\n");
fclose($fp);
}
echo("done=1");
}
?>

It is aguestbook made in Flash. When somebody fills in the guestbook, the data should be stored in the database, but this wont work. can somebody help me,

thanx,

tom

[edwardsbc]

So exactly how does this relate to mySQL? You haven't used a single PHP command related to mySQL in the shown script. This is not the way to append to mySQL databases!

[Anon]

hallo,

OFF course, you see I\'m very new to php and MYSQL. So I should add something like this to my code:

$db = mysql_connect(db.grafices.f2s.com\",\"grafices\",\"grafices\")
or die (\"couldn\'t connect.\");
mysql_select_db(\"grafices\",$db) or die (\"couldn\'t select database.\");

and after this the rest of the code??

thanx,

tom

[edwardsbc]

Well, that's a start. First, be careful with the backslashes, you only need them in very specific instances. Here is a generic mySQL read. The important part is that you communicate with the MySQL database with SQL statements.

$handle=mysql_connect($dbname,$dbuser,$dbpwd);

if (!$handle) {die('Failed to connect to db.');}

$sql="SELECT * FROM $tblname WHERE $fieldname='$somevar'";

$result=mysql_query($sql,$handle);

if (!result) {die('Query Failed.');}

while ($rowarray=mysql_fetch_array($result)) {
#process result row from elements now in array
echo $rowarray[$fieldname];
echo $rowarray[$otherfieldname];
echo $rowarray[customernumber];
echo $rowarray['phonenumber'];
#etc...
}

[Anon]

thanx,

I'll test that script