Re: multiple choice dropdown box puzzle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
here.
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.
<html>
    <head>
    <title>test form</title>
    </head>
<body>
</body>

<?
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>
</select>

<input type="submit" name="submit" value="submit">
</form>
<?
$sql4 = "INSERT INTO test
            (example) VALUES (' . implode('),(',
$_POST["$categoriesIN"]) . ')";
$result4 = mysql_query($sql4, $db);
?>
<table align="center" border="0" cellpadding="3" width="90%">
    <tr>
        <td align="center"><b>
        <input class=textbox type="submit" name="AddNewBooksRequest"
value="Insert New Books">
        </b>
        </td>
       
    </tr>
</table>
</html>
==========
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.
TIA



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux