|
|
Posted by Steve on 10/17/06 20:25
"Breklin" <breklin@sbcglobal.net> wrote in message
news:YNaZg.14902$vJ2.2648@newssvr12.news.prodigy.com...
| Steve, If you know so much, why don't just help her?? Jesus. However,
| thank you. You taught me something I can take with me about the
| ID/Auto_increment deal. Much appreciated.
i have to laugh, breklin. i'm not trying to bait you. ;^)
my first post to her was a chunk of template code that will suffice for her
needs nicely if she just changes the appropriate sql statements to match her
table structure. then in came ikciu calling her stupid which got us off in
another tangent.
what did i teach you btw?
| Linda,
|
| Run a select statement using some identifiable value in your form to
| check for duplicates. Perhaps the Name of the item or your product code,
| etc.
exactly...there you go!
| Using that, you can see if any rows were returned. If not, then you can
| proceed with your insert query.
viola!
| See example:
| _______________________________________________________
| $is_error_exists = false;
|
| $product_id = htmlspecialchars($_POST['product_id_field'])
|
| $query = "SELECT product_id, name
| FROM table_name
| WHERE product_id = $product_id";
|
| $result = mysql_query($query);
|
| $numrows = mysql_num_rows($result);
|
| if($numrows == 0)
| // Execute insert query here
| else
| $is_error_exists = true;
|
| if($is_error_exists)
| echo "There is a record for this product already in the database.";
|
| ___________________________________________________________
|
| Now, if Steve has any better ideas to help you instead of nit-picking my
| code in lieu of his preference, please allow him to take it away! ;)
ok...sorry to be so picky. i do have to point out that since product id is
user generated, she does run the risk of overwritting data if she doesn't
check correctly when editing a record. meaning, that the original product id
must not be changed to an already existing product id....hence, an
overwrite. again, the example i gave covers this possiblity as well.
| There are many ways to do things, Linda. Just find your own special way
| and learn to develop it into a clean style along the way.
|
| I personally use MYSQL wrapper classes to execute my queries. They are
| very neat and don't clutter your code. You agree, Stevo?
i agree completely...and don't mean to piss you off either. here's my
wrapper for mysql...it is implemented in a shared interface...but that's a
bit ot for linda, i think (assumes php 5):
<?
class db
{
static private $_instance = null;
static private $_lastStatement = '';
private function __clone(){}
private function __construct(){}
static function connect($server, $user, $password, $catalog = null)
{
try
{
mysql_connect($server, $user, $password);
if (!is_null($catalog)){ mysql_select_db($catalog); }
} catch (exception $ex) {
print "<pre>\r\n" . $ex->getMessage() . "\r\n" .
' in file ' . $ex->getFile() . "\r\n" .
' on line ' . $ex->getLine() . "\r\n" .
'</pre>';
return false;
}
return true;
}
static function getInstance()
{
if (is_null(self::$_instance)){ self::$_instance = new db(); }
return self::$_instance;
}
static function getLastStatement(){ return self::$_lastStatement; }
static function decode($string)
{
$translation = get_html_translation_table(HTML_ENTITIES);
$translation = array_flip($translation);
$string = strtr($string, $translation);
return $string;
}
static function describe($table)
{
$columns = array();
$records = self::execute('DESCRIBE ' . $table);
foreach ($records as $record)
{
foreach ($record as $column => $property)
{
if ($column == 'FIELD'){ continue; }
$columns[$record['FIELD']][$column] = $property;
}
}
return $columns;
}
static function encode($string)
{
$translation = get_html_translation_table(HTML_ENTITIES);
$string = strtr($string, $translation);
return $string;
}
static function execute($sql, $decode = false, $returnNewId = false)
{
self::$_lastStatement = $sql;
$array = array();
$key = 0;
$records = mysql_query($sql);
$fieldCount = @mysql_num_fields($records);
$translation = get_html_translation_table(HTML_ENTITIES);
$translation = array_flip($translation);
while ($row = @mysql_fetch_array($records, MYSQL_NUM))
{
for ($i = 0; $i < $fieldCount; $i++)
{
$value = $row[$i];
if ($decode){ $value = strtr($value, $translation); }
$array[$key][strtoupper(@mysql_field_name($records, $i))] = $value;
}
$key++;
}
if ($returnNewId)
{
$array = array();
$array[0]['ID'] = mysql_insert_id();
}
@mysql_free_result($records);
return $array;
}
static function prepare($string, $encode = false)
{
if ($encode){ $string = self::encode($string); }
$string = stripslashes(str_replace("'", "''", $string));
return $string;
}
}
?>
Navigation:
[Reply to this message]
|