note 26568 deleted from function.mysql-field-len by didou

Note Submitter: jowatkinsuk@yahoo.co.uk A little function that uses mysql_field_len() to dynamically check that submitted forms do not exceed allowed legth in the db. function check_field_length($table) { $fields = mysql_list_fields("PDS", $table); //count how many fields in form posted and delete 2 for buttons $numposts = count($_POST); $actualposts = $numposts-2; static $i=1; foreach ($_POST as $key => $value) { if ($i <= $actualposts) { $type = mysql_field_type($fields, $i); if ($type == "string") { $max = mysql_field_len($fields, $i); $length = strlen($value); //echo "$key, max = $max, length=$length<br/>"; if ($length > $max) { echo "<p><font color=\"#ff0000\">PROBLEM</font> $key must be no greater than $max characters."; echo "<br/>Please go back and correct.</p>"; exit; } } } $i++; } }