Brent Baisley wrote:
> It's actually a very simple solution, and you should do it all in a
> single INSERT. Putting INSERTs in a loop will kill your performance
> when you try to scale.
> $sql4 = 'INSERT INTO test (example) VALUES (' . implode('),(',
> $_POST["categoriesIN"]) . ')';
> $result4 = mysql_query($sql4, $db);
Please explain this... I do not understand how the implode is being used
As I understand it, the above code would aoutput or rather INSERT all
the choicees into one field as choice numbers separated by a , (like 1,
3, 4) or what?  I suppose I could use that but I'm not sure if this is
the way to  go. I understand the performance problem and would like to
keep it simple.
> That example does not sanitize the data before inserting.
I know, but I am just testing locally for now. Will sanitize later.
> Brent
Here is my test page: Questions below that.
    <title>test form</title>

session_start();        // Include sessions_start() in everything
include ("db1.php");
$thisInterface = "addNewBooks";
if (!isset($_SESSION["addNewBooks"])) {

    $categoriesIN    = "";
    // Save the input variables in session variables

    $_SESSION["categoriesIN"]    = $categoriesIN;
    // Remember that addNewBooks.php has been entered once
    $_SESSION["addNewBooks"] = 1;
else {$categoriesIN    = $_SESSION["categoriesIN"];
if (isset($_REQUEST["AddNewBooksRequest"]))    
    $categoriesIN        = $_POST["categoriesIN"];

<form method="post" action="multiple_category_insert.php">
<select name="$categoriesIN[]" multiple size="5">
    <option > Choose categories... </option>
        <option value="1">History</option>
        <option value="2">Temples</option>
        <option value="3"> Cleopatra</option>
        <option value="4"> Mummies</option>

<input type="submit" name="submit" value="submit">
$sql4 = "INSERT INTO test
            (example) VALUES (' . implode('),(',
$_POST["$categoriesIN"]) . ')";
$result4 = mysql_query($sql4, $db);
<table align="center" border="0" cellpadding="3" width="90%">
        <td align="center"><b>
        <input class=textbox type="submit" name="AddNewBooksRequest"
value="Insert New Books">
Question 1.
What should be entered into the name=" something " to make it work?

Question 2.
How should the $sql4 = "INSERT...... be completed?

I know the code above is not working but I can't figure out what's wrong.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to