Need Help, Database problems, Urgent for school!

Projects Programming
17

cAriek:

<?php

$base = mysql_connect('localhost', '1317483', 'password') or die("unable to connect to db"); ;
mysql_select_db('1317483',$base);

$a=$_GET['ID'];
$b=$_GET['Temp'];
$c=$_GET['Hum'];

//$sql = "SELECT * FROM info WHERE id='$a'";
//$res=mysql_query($sql) or die('Error selection'.mysql_error());

$sql = "INSERT INTO Essai VALUES('$a','$b','$c')";
      mysql_query($sql) or die('Error selection'.mysql_error());

	$insertGOTO="index.html";
	header(sprintf("Location:%s",$insertGOTO));

?>



* that's the ajout.php code, with that i add values to my database.
* Phpmyadmin is where i created this db.
* SQL is the type of db.
* projetec.orgfree.com is the website i created where i can find my ftp and things like that, created it from 'freewebhostingarea.com'

Well.. I guess I cant comment about the hosting/domain stuff.. (maybe it works without issue?)
That being said.. WOWZERS MAN!.. I wouldnt use that script if I were you!.
I would switch to PDO and prepared statements..etc..
At the very least sanitize your data!.. That script is totally open to injection attacks!! :slight_smile:
Does the script work 'as-is'? Can you load that up in your browser and get it to insert data?
If not.. then you know the problem isnt on the Arduino side of things.. (or at least not yet) :slight_smile:

Also says your script can not be found.. so the path is not correct.

if this is it: Error (nor does that url look even remotely compliant/legit)