[RESOLVED] inserting data into database

[johnm1958]

Hi
I have a php file but can't get data into it, although I can get data out. I am putting the following into my browser.

http://localhost/scoreTEST2.php?action=INSERT&pname=Joe&score=11&viewtype=FLASH

<?php
$keeptime=(7*24*60*60);
$database="x4tables";
$user="root";
$conn=mysql_connect("localhost","root","")or die("err:conn");

$self=$_SERVER['PHP_SELF'];
$pname=$_POST['pname'];
$score=$_POST['score'];

$rs=mysql_select_db("scores",$conn)or die("err:db");
$rs=mysql_query($sql,$conn);
$sql="insert into x4tables (pname,score)values(\"$pname\",$score)";

$rs=mysql_query($sql,$conn);

$sql="select pname,score from x4tables order by score limit 10";
$rs= mysql_query($sql,$conn);

$num= mysql_num_rows($rs);

// FLASH DATA CREATED HERE
for($i=0;$i<10;$i++)

		{echo ("pname" . $i . "=");
		echo (mysql_result ($rs,$i,"pname"));
		$mins=0;
		$secs=mysql_result($rs,$i,"score");
		$mins=floor($secs/60);$secs=$secs%60;
		echo("&mins".$i."=");
		echo($mins);
		echo ("&secs" . $i . "=");
		echo($secs);
		echo ("&");
}

?>

Am I putting the wrong instruction into my browser please?

I should perhaps say that my real aim is to get scores from a flash game into the database. I have tried using the code
scoretable.loadVariables("http://localhost/scoreTEST2.php", "GET"); to post the variables 'pname' and 'score' from my game into my database but it does not work

[johnm1958]

Hi

I have resolved the problem by changing

$pname=$POST['pname'];
$score=$POST['score'];

to

$pname=$REQUEST['pname'];
$score=$REQUEST['score'];

thanks

[bogu]

I changed your code a little:

/* .... */
$sql = "INSERT INTO x4tables SET ";
$sql.= "pname = '{$pname}', ";
$sql.= "score = '{$score}'"; 
mysql_query($sql,$conn) or die(mysql_error()); 

$sql="SELECT pname,score FROM x4tables ORDER BY score LIMIT 10"; 
$rs= mysql_query($sql,$conn) or die(mysql_error()); 
if (mysql_num_rows($rs)) {
	$i = 0;
	while ($rez = mysql_fetch_assoc($rs)) {
		$mins = 0;
		$secs = $rez['score'];
		if (!empty($secs)) {
			$mins = floor ($secs/60);
			$secs = ($secs % 60);
		}
		echo "pname{$i}={$rez['pname']}&mins{$i}={$mins}&secs{$i}={$secs}&";
		$i++;
	}
}

if this is not working try to view this php script to see if the output for your flash is OK and no error occurs (mysql errors, output errors, ..., etc.)...

<!-- Ex. -->
<form method="POST" action="your_script.php">
    <input type="hidden" name="pname" value="John" />
    <input type="hidden" name="score" value="542" />
    <input type="submit" name="submit" value="Submit" />
</form>