All pastes #752682 Raw Edit

Something

public text v1 · immutable
#752682 ·published 2007-10-28 17:10 UTC
rendered paste body
case 'editprod2' :
			//validate
			if (!isset($_GET['id']) || !is_numeric($_GET

['id'])) //added !isset and used !is_numeric
			{
			  	echo "<h1>Invalid product selected!

</h1>";
			  	break;
			}
			$_GET['id'] = (int)$_GET['id']; 
			$str = "SELECT * FROM products WHERE 

`prod_id`= ".($_GET['id'])." LIMIT 1"; 
			$qry = mysql_query($str) or die("Invalid 

prod_id used! [mysql error: ".mysql_error()."]");
			if ($row = mysql_fetch_assoc($qry)){		

	
			$string = "SELECT * FROM `categories` ORDER 

BY `cat_id` = ".$_GET['id']."";
			$query = mysql_query($string) or die("Invalid 

prod_id used! [mysql error: ".mysql_error()."]");
			echo "<b>Edit Product:</b><hr>";
			?>
            <form action="?do=submitprod" method="POST" 

enctype="multipart/form-data"/>
			<table>
  			<tr>
    		<td align="left" valign="middle">Product Name</td>
    		<td align="left" valign="middle">
      		<input type="text" name="name" size="40" value="<?php 

echo $row['prod_name']; ?>" />
      		</td>
            </tr>
            <tr>
            <td align="left" valign="middle">Category</td>
            <td align="left" valign="middle">
            <select name="category" value="<?php echo $row

['prod_cat_id']; ?>">
			<?php 
			while ($myrow = mysql_fetch_assoc($query)){
			echo '<option value="'.$myrow

['cat_id'].'">'.$myrow['cat_name'].'</option>';
			}
			?>
            </select>
  			</tr>
            <tr>
            <td align="left" valign="top">Description</td>
            <td align="left" valign="middle"><textarea name="desc" 

cols="34" rows="8"><?php echo $row['prod_desc'] ?></textarea>
            </td>
            </tr><tr>
            <td colspan="2" align ="left">
            Image Upload:
			Select a file to upload: <br />
			<input type="file" name="file" size="50" />
			<br />
            </td>
            </tr>
  			<tr>
    		<td colspan="2" align="center"><input type="submit" 

name="submit" value="Add Product" /></td>
 			</tr>
			</table>
			</form>
        	<?php           
			}
			break;