goltoof Posted June 27, 2011 Share Posted June 27, 2011 Need to exclude whitespaces from mysql input. When user inserts space accidentally, php needs to eliminate it, whether searching or updating the field. <tr><td>Model# </td><td><input type="text" name="model" size="" /></td></tr> <?php $id = $_POST['']; $model = $_POST['model']; $query= "INSERT INTO product_specs (ID, model) VALUES ('NULL', '".$model."')"; ?> Also need to exclude whitespaces from mysql query. <?php $model=$_GET["model"]; $result = mysql_query("select * from product_specs where model ='$model'"); if ($row = mysql_fetch_object($result)) { echo 'Model# '. $row->model . '<br />'; } ?> I'm familiar with trim(), preg_replace() just unclear how to include in the script. Link to comment https://forums.phpfreaks.com/topic/240558-exclude-whitespace-from-mysql-query/ Share on other sites More sharing options...
WebStyles Posted June 27, 2011 Share Posted June 27, 2011 $model=str_replace(" ","",trim($_GET["model"])); Link to comment https://forums.phpfreaks.com/topic/240558-exclude-whitespace-from-mysql-query/#findComment-1235654 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.