NEED HELP

sols

hi all,

Ihave some problem

i have numbers like this

$row="11,22,33,66,12,45"

How am I able to the preceding division of the sentence?

i wont insert 1 No in the dadabase

$sql="insert into tabelname set No='11'"

$sql="insert into tabelname set No='22'"

$sql="insert into tabelname set No='33'"

$sql="insert into tabelname set No='66'"

like this

how I can doit PLZ????

and thanx

laserlight

It sounds like you want to use [man]explode/man to turn the string into an array, and then iterate over the array and run an insert on each element.

Piranha

Note that you can insert multiple rows in one query using

INSERT INTO table (column1, column2) VALUES (1, 1), (2, 2), (3, 3)

Then you don't need to do one query for each insert.

laserlight

That's new to me. Would it not be the same as wrapping a bunch of insert statements in a transaction? After all, such a multiple insert feature would require building the statement manually, but a single insert statement can be prepared and reused.

sols

laserlight

Piranha

thank you toooooooooo much it's work🙂 🙂 🙂

i used this code

$pizza  = "11,22,33,44";
$pieces = explode(" ", $pizza);
echo $pieces[0]; // piece1
echo $pieces[1]; // piece2

it's printing 1122

so what i do to print all numbers like this

11
22
33
44

thanx again

Piranha

I don't know how the difference in database handling between transactions and inserting multiple rows at once. It is possible that transactions handles all as one database query, and thus it should not be a big difference. I have never used transactions in PHP, so I simply don't know.

But I don't agree that it would be that different to build the statement manually or prepare and reuse a statement. The difference is that you have to build the values first with my way, you build the statement first with your.

$ins = "";
foreach ($array as $value) {
  $ins += "( $value ),";
}
$ins = substr($ins, 0, -1);
$sql = "insert into table (column) values $ins";

laserlight

so what i do to print all numbers like this

Insert a break to the HTML code, e.g., <br />.

But I don't agree that it would be that different to build the statement manually or prepare and reuse a statement. The difference is that you have to build the values first with my way, you build the statement first with your.

It is not a big difference, but it does seem to me that this should be one place where prepared statements would shine more than as a safer escaping feature (which is not all that safe after all for emulated prepared statements, if I remember correctly).

Incidentally, I think you intended to write:

$ins = "";
foreach ($array as $value) {
  $ins .= "( $value ),";
}
$ins = substr($ins, 0, -1);

But it probably is even simpler as:

$ins = '( ' . implode(' ),( ', $array) . ' )';

sols

laserlight thanx

i'll try

Piranha

Ty Lasersight, my syntax is a bit off at the moment since I am currently programming in Java.

You are right, if you use PDO you probably want to use prepared statements instead for security. Or if you need the id of a auto-incremented column you can't insert more than one row per query.

But if you don't use PDO and don't need the id I think it is better to insert in one query. And of course you should add security as well, I just wanted to show the basics (that you know better than I do).