mysql insert array problem

Anon

Hi,

I'm inserting an array with strings elements into mysql. For example :

$sql = "INSERT INTO table (field_name)
VALUES ('$array['element']')";

However, this produces a parse error because of the single quotes around the name of the element. I'm not able to escape the quotes and I don't want to use integer elements. I also would rather not concatinate the string, like:

$sql = "INSERT INTO table (field_name) VALUES ('" . $array["element"] . "')";

Is there another way to solve this? I haven't tested the second method yet, so I'm not even sure that would work. Any ideas? Thanks so much.

Anon

$value=$array['element'];
$sql = "INSERT INTO table (field_name)
VALUES ('$value')";

amcgrath

In case you didn't figure it out, Sam, the single quotes were conflicting...

Anon

sorry!
i do not known!
this is test!

Anon

Allen,

Yes thanks, but I did say that in my original post. I'm looking for a simpler, cleaner way of writing the sql than having to assign each element to a variable.

It was a question of efficiency. I have about 20 elements in the array and I feel it would be wasteful to assign those to 20 variables. The solution is I'll just have to go back and change the array into seperate variables. I was just curious if there was a better solution than that, sometimes an array is the best solution to your problem.

-Samantha

amcgrath

OK, I gotcha now: Howzabout something like this:
insert into table
(implode(array_keys(','$array)))
values
(implode(array_values(','$array)))

You'll haveta quote varchars and stuff, but that'll be easy for ya....

Anon

array_keys and array_values, I like that. Thanks, that's just what I meant!

-Samantha

amcgrath

You're welcome (FYI,. it wasn't obvious what you were asking in your first post....)

Anon

hi folks..

every time i recommend the brackets.. the allow to easily mixup strings safely, also no probs with arrays..

sample:
$query = "insert into table (field1, field2) values ('{$arr["field1"]}', {$arr["field2"]});";

and so on..
looks complicated at the first view, but simple enclose all variables with {}, and php looks at it..

greets from switzerland
dn

Anon

Dario,

I tried that with my array, but I keep getting an "invalid query" error when executing the 2nd mysql_query to $newlink. It parses ok. I am transferring a website to a new server using a different script and I'm trying to move my users from the old database to the one:

<?php
$link = mysql_connect("oldserver", "oldname", "oldpass")
or die("Could not connect");
mysql_select_db("olddb", $link)
or die("Could not select database");
$user_res = mysql_query("SELECT DISTINCT
userid, username, useraddress, password FROM oldtable ORDER BY userid, username, useraddress, password")
or die("Invalid query");
while ($row = mysql_fetch_assoc($user_res)) {
$newlink = mysql_connect("newserver", "newid", "newpass")

or die("Could not connect");
mysql_select_db("newdb", $newlink);
$newresult = mysql_query("INSERT INTO newtable (uname, email, pass) VALUES ('{$row["username"]}', '{$row["useraddress"]}', '{$row["userpassword"]}')", $newlink)
or die("Invalid query");

mysql_free_result($user_res);

mysql_close($link);

mysql_close($newlink);

Any help would be greatly appreciated!

Susan