2009/8/10 Richard Quadling <rquadling@xxxxxxxxxxxxxx>:
> 2009/8/10 Jacob Kruger <jacobk@xxxxxxxxxxxxxx>:
>> Ok.
>>
>> Now got it working with the following two bits of script:
>> if ($_POST['btnDel'] == "Multiple deletion")
>> {
>> // perform multiple delete first
>> foreach ($_POST as $formField)
>> checkField($formField);
>>
>> } // end of delete button pressed
>>
>> and above that (seems to only see function if located above the call to it):
>> function checkField($field)
>> {
>> $start = substr($field, 0, 5);
>> if ($start == "doDel")
>> {
>> $id = substr($field,5,strLen($field) - 5);
>> $sql = "delete from article where ID = " . $id . ";";
>> $result = mysql_query($sql);
>> } // end of if doDel in string
>> } // end of function
>>
>> The checkboxes are generated with the following line of script/code:
>> echo "<input type='checkbox' name='doDel" . $row['id'] . "' value='doDel" .
>> $row['id'] . "' />";
>>
>> I initially tried just using either strpos() or stripos() functions to check
>> if the substring doDel was there, but for some reason it never returned a
>> result of false no matter what was in the form field's value, so switched
>> over to the instance of substr() as above.
>>
>> Will also just now add on some javascript to make the user confirm that they
>> do in fact want to delete selected records, but anyway...
>>
>> Thanks for giving me the right ideas with regard to what route to follow,
>> and I'll just also say that obviously I need to carry on with this stuff a
>> bit since your examples mostly seemed a bit strange to me with regard to
>> just including variables etc. inside the string values to be used, which is
>> why I instead just used what I reckon is a simpler syntax as such.
>>
>> Stay well
>>
>> Jacob Kruger
>> Blind Biker
>> Skype: BlindZA
>> '...fate had broken his body, but not his spirit...'
>>
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus signature
>> database 4321 (20090810) __________
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>>
>>
>>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
> Eek!
>
> echo "<input type='checkbox' name='doDel" . $row['id'] . "'
> value='doDel" . $row['id'] . "' />";
>
> really would be a lot easier on you if use ...
>
> echo "<input type='checkbox' name='doDel[" . $row['id'] . "]'
> value='doDel" . $row['id'] . "' />";
>
> Now, $_POST['doDel'] is an array you can foreach() on without any need
> to decode ...
>
> foreach($_POST['doDel'] as $ID_to_delete => $value_associated_with_input) {
> if (intval($ID_to_delete) > 0) {
> // Now you can delete based upon the id held in $ID_to_delete.
> }
> }
>
>
> --
> -----
> Richard Quadling
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> "Standing on the shoulders of some very clever giants!"
> ZOPA : http://uk.zopa.com/member/RQuadling
>
If you want to take a look at the heredoc [1] and nowdoc [2]
documentation, you may find that these are a LOT easier to work with
than trying to quote ' and " appropriately.
e.g.
echo <<< END_INPUT
<input type="checkbox" name="doDel[{$row['id']}]' value="doDel{$row['id']}" />
END_INPUT;
for example.
Regards,
Richard Quadling.
[1] http://docs.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc
[2] http://docs.php.net/manual/en/language.types.string.php#language.types.string.syntax.nowdoc
--
-----
Richard Quadling
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
"Standing on the shoulders of some very clever giants!"
ZOPA : http://uk.zopa.com/member/RQuadling
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
