trying to make php to upload data from form

Beginners - Learning PHP
#1

So I’m trying to make an insert.php to upload data to my database, but get this error when I click submit on my webform:
Parse error: syntax error, unexpected ‘=’ in /hermes/bosweb/web158/b1582/ipg.sweatmansccom/TMS/insert.php on line 6

my database name is “tms” and the table name is “tbl_Entry”. I think I may have my $database set wrong?

newrecord.html:

[php]

ID:
serial_number:
desc:
dmg:
dmg_desc:
pic_link:
creation_date:
last_update_date:
last_update_by:
[/php]

insert.php
[php]<?php
$username="---------";
$password="--------";
$database=“sweatmansccom.ipagemysql.com.tms”;

$field1-name=$_POST[‘ID’];
$field2-name=$_POST[‘serial_number’];
$field3-name=$_POST[‘desc’];
$field4-name=$_POST[‘dmg’];
$field5-name=$_POST[‘dmg_desc’];
$field6-name=$_POST[‘pic_link’];
$field7-name=$_POST[‘creation_date’];
$field8-name=$_POST[‘created_by’];
$field9-name=$_POST[‘last_update_date’];
$field10-name=$_POST[‘last_update_by’];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( “Unable to select database”);

$query = "INSERT INTO ‘tbl_Entry’ VALUES
(’$field1-name’,’$field2-name’,’$field3-name’,’$field4-name’,’$field5

-name’,’$field6-name’,’$field7-name’,’$field8-name’,’$field9-

name’,’$field10-name’)";

mysql_query($query);

mysql_close();
?>[/php]

#2

You can’t use dashes in variables. You can use underscores.

[php]
$field1-name // invalid
$field1_name // valid
[/php]

#3

Perfect! get a new error… I must have something wrong with my insert.php file still?

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /hermes/bosweb/web158/b1582/ipg.sweatmansccom/TMS/insert.php on line 17
Unable to select database

[php]<?php
$username=“Removed”;
$password=“Removed”;
$database=“sweatmansccom.ipagemysql.com.tms”;

$field1_name=$_POST[‘ID’];
$field2_name=$_POST[‘serial_number’];
$field3_name=$_POST[‘desc’];
$field4_name=$_POST[‘dmg’];
$field5_name=$_POST[‘dmg_desc’];
$field6_name=$_POST[‘pic_link’];
$field7_name=$_POST[‘creation_date’];
$field8_name=$_POST[‘created_by’];
$field9_name=$_POST[‘last_update_date’];
$field10_name=$_POST[‘last_update_by’];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( “Unable to select database”);

$query = "INSERT INTO ‘tbl_Entry’ VALUES
(’$field1_name’,’$field2_name’,’$field3_name’,’$field4_name’,’$field5_

name’,’$field6_name’,’$field7_name’,’$field8_name’,’$field9_name’,’$fi

eld10_name’)";

mysql_query($query);

mysql_close();
?>[/php]

#4

[php]mysql_connect(localhost,$username,$password);[/php]

localhost would be seen as an undefined constant instead of a string. It should be quoted

[php]mysql_connect(‘localhost’,$username,$password);[/php]

#5

Thank you for the help so far. Now it doesn’t give me an error, it just says 0 on the screen. when I check the database it appears nothing is loaded.

I think the error is in the line: "INSERT INTO ‘tbl_Entry’ VALUES (’$field1 because in the code it doesn’t show it all red like it is a string.

[php]<?php
$username=“77777”;
$password=“7777777”;
$database=“tms”;

$field1_name=$_POST[‘ID’];
$field2_name=$_POST[‘serial_number’];
$field3_name=$_POST[‘desc’];
$field4_name=$_POST[‘dmg’];
$field5_name=$_POST[‘dmg_desc’];
$field6_name=$_POST[‘pic_link’];
$field7_name=$_POST[‘creation_date’];
$field8_name=$_POST[‘created_by’];
$field9_name=$_POST[‘last_update_date’];
$field10_name=$_POST[‘last_update_by’];

mysql_connect(‘sweatmansccom.ipagemysql.com’,$username,$password);
@mysql_select_db($database) or die( “Unable to select database”);

$query = “INSERT INTO ‘tbl_Entry’ VALUES (’$field1_name’,’$field2_name’,’$field3_name’,’$field4_name’,’$field5_name’,’$field6_name’,’$field7_name’,’$field8_name’,’$field9_name’,’$field10_name’)”;

mysql_query($query);

mysql_close();
?>[/php]

[php]

ID:
serial_number:
desc:
dmg:
dmg_desc:
pic_link:
creation_date:
created_by:
last_update_date:
last_update_by:
[/php]
#6

This is a syntax error:

[php]$query = "INSERT INTO ‘tbl_Entry’[/php]

Table and column names cannot be quoted, instead you use backticks

[php]$query = "INSERT INTO tbl_Entry[/php]

#7

m@tt you are the man! Thank you so much for the help!

Sponsor our Newsletter | Privacy Policy | Terms of Service