Syntax of inserting array elements to database with PHP

Question

This isn't anything overly complicated (I assume), I'm just not sure of the syntax for doing what I want. I'm trying to insert a value from an array into the database. Below achieves what I want to do, however I was wondering if it could be reformatted to the code below that.

Current code which does what I want:

$name = explode(" ",$fullName);
$firstName = $name[0];  
$lastName = $name[count($name) - 1];
mysql_query("INSERT INTO `person` VALUES(NULL, '$firstName', '$lastName',0)"));

What I want to know is if it can be formatted like this:

$name = explode(" ",$fullName);
mysql_query("INSERT INTO `person` VALUES(NULL, '$name[0]', '$name[count($name) - 1]',0)"));

I tried this earlier a few different ways and got an error, is it just an issue with syntax or is it something a bit deeper?

Oh, and I should add that the only time I actually got the insert to run fully, I ended up with Array[0] and Array[2] - 1 in the first_name and last_name columns respectively.

Thanks all, hopefully I've been clear enough. Need any more info, let me know.

$name = explode(" ",$fullName); mysql_query("INSERT INTO 'person' VALUES(NULL, '$name[0]', '$name[count($name) - 1]'); This code fetched an error?? What was the error? Formatting looks fine. — Arup Rakshit
– Arup Rakshit, Commented Apr 21, 2013 at 14:14
@RubyLovely Am I being stupid or is that not what I already did? — whitfin
– whitfin, Commented Apr 21, 2013 at 14:16
mysql_query("INSERT INTO person VALUES(NULL, '$name[0]', '".($name[count($name) - 1])."')"); more like this .. — dbf
– dbf, Commented Apr 21, 2013 at 14:16
@dbf Yeah just noticed that, must've typoed. Corrected it (I hadn't typoed in my actual PHP). — whitfin
– whitfin, Commented Apr 21, 2013 at 14:17
@Zackehh9lives hmm, didn't correct any typo, look at the difference again ;) — dbf
– dbf, Commented Apr 21, 2013 at 14:19

user229044 · Accepted Answer · 2013-04-22 19:11:02Z

1

You may try this:

mysql_query("INSERT INTO `person` VALUES(NULL, '$name[0]', '".$name[count($name) - 1]."' ");

edited Apr 22, 2013 at 19:11

user229044♦

241k41 gold badges346 silver badges350 bronze badges

answered Apr 21, 2013 at 14:20

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user229044 Over a year ago

Please don't use chat speak on Stack Overflow. Take the time to write "you" instead of "u".

Arup Rakshit · Accepted Answer · 2013-04-21 14:21:15Z

1

Try this:

$name = explode(" ",$fullName); 
$query="INSERT INTO person VALUES(NULL,'". $name[0]."','".$name[count($name) - 1]."'";
mysql_query($query);

answered Apr 21, 2013 at 14:21

Arup Rakshit

119k30 gold badges270 silver badges328 bronze badges

Comments

didierc · Accepted Answer · 2013-04-21 14:28:19Z

0

Try this:

mysql_query("INSERT INTO `person` VALUES(NULL, '{$name[0]}', '{$name[count($name) - 1]}',0)");

edited Apr 21, 2013 at 14:28

answered Apr 21, 2013 at 14:22

didierc

14.7k3 gold badges35 silver badges52 bronze badges

Collectives™ on Stack Overflow

Syntax of inserting array elements to database with PHP

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related