Strip Slashes Help

Posted on 16th Feb 2014 07:03 pm by admin

I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and works fine EXCEPT I want to add the strip slashes bit to it so it will save what I type in. However, I tried, and totally cleared 2 fields for all records on my db, so not happy. So here is the script, can anyone help me put the stripslashes bit where it should be please...

The stripslashes are important for 'item' and 'description' fields.

Code: <?php
"db connection area"
$sql="SELECT * FROM $tbl_name ORDER BY category ASC";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<!--
<FORM method="post" action="<?php echo $PHP_SELF?>">
-->

<p>
<table border='1' cellspacing='0' width='100%' style='border-collapse: collapse' bordercolor='#000000'>
<form name="form1" method="post" action="">

<tr>
<th>Category/Subcategory</th>
<th>Product/Code</th>
<th>Description</th>
<th>Qty/Price 1</th>
<th>Qty/Price 2 </th>
<th>Qty/Price 3 </th>
<th>Qty/Price 4 </th>
<th>Qty/Price 5 </th>
<th>Weight/Status</th>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<? $id[]=$rows['id']; ?>
<td><input name="category[]" type="text" id="category" value="<? echo $rows['category']; ?>" size="30"><br />
<input name="subcategory[]" type="text" id="subcategory" value="<? echo $rows['subcategory']; ?>" size="30" /></td>
<td><input name="item[]" type="text" id="item" value="<? echo $rows['item']; ?>" size="30"><br />
<input name="code[]" type="text" id="code" value="<? echo $rows['code']; ?>" size="30" /></td>
<td><textarea name="description[]" cols="40" rows="3" id="description" type="text"><? echo $rows['description']; ?></textarea></td>
<td><input name="qty1[]" type="text" id="qty1" value="<? echo $rows['qty1']; ?>" size="5"><br />
<input name="price1[]" type="text" id="price1" value="<? echo $rows['price1']; ?>" size="5" /></td>
<td><input name="qty2[]" type="text" id="qty2" value="<? echo $rows['qty2']; ?>" size="5"><br />
<input name="price2[]" type="text" id="price2" value="<? echo $rows['price2']; ?>" size="5" /></td>
<td><input name="qty3[]" type="text" id="qty3" value="<? echo $rows['qty3']; ?>" size="5"><br />
<input name="price3[]" type="text" id="price3" value="<? echo $rows['price3']; ?>" size="5" /></td>
<td><input name="qty4[]" type="text" id="qty4" value="<? echo $rows['qty4']; ?>" size="5"><br />
<input name="price4[]" type="text" id="price4" value="<? echo $rows['price4']; ?>" size="5" /></td>
<td><input name="qty5[]" type="text" id="qty5" value="<? echo $rows['qty5']; ?>" size="5"><br />
<input name="price5[]" type="text" id="price5" value="<? echo $rows['price5']; ?>" size="5" /></td>
<td><input name="weight[]" type="text" id="weight" value="<? echo $rows['weight']; ?>" size="5"><br />
<input name="status[]" type="text" id="status" value="<? echo $rows['status']; ?>" size="5" /></td>
</tr>
<?php
}
?>
</table>
<input type="submit" name="Submit" value="Submit" class="button1">
</form>
<?php
// Check if button name "Submit" is status, do this

if($Submit){

for($i=0;$i<$count;$i++){

$sql1="UPDATE $tbl_name SET status='$status[$i]', category='$category[$i]', subcategory='$subcategory[$i]', item='$item[$i]', description='$description[$i]', code='$code[$i]', qty1='$qty1[$i]', price1='$price1[$i]', qty2='$qty2[$i]', price2='$price2[$i]', qty3='$qty3[$i]', price3='$price3[$i]', qty4='$qty4[$i]', price4='$price4[$i]', qty5='$qty5[$i]', price5='$price5[$i]', weight='$weight[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
echo "<p>Records Updated</p>";
echo('<meta http-equiv="refresh" content="0">');
}
mysql_close();
?>

Thankyou in advance

Your Answer:

Login to answer

Other forums

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_

PHP error (line 38) my website
Hello everyone, I'm new on this
and I got a web site thats got a error not showing the photos on<

Displaying a clickable playername
I am going wrong somewhere with the mysql_query, can someone please put me straight?

$playern

how to use two buttons with php
hi i have one form. there are three fields which are to be filled by the user. and then there are tw

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

phph within href not showing php if change ? to &
Code: [Select]<a href="<?php echo $puser; ?>?m=<?php=(($m-1)&l

Error in Configure System Landscape Directory phase
Hi

We are getting the error in Configure SLD phase ( 41 of 44 phase).

Please f

PHP - MySQL Fail
My PHP code will only execute the first part of my code...

Code: <?php

sessio

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to