It's a simple algorythem, use a loop to enter the names from the database
into an array, and compare each to the value in the array. or some hybred
thereof.
<?php
function Compare($UserInput) {
$db=mysql_connect($ServerAddress,$LoginName,$LoginPassword));
mysql_select_db($userDB,$db);
$result = mysql_query('Select * from ' . $TableWithNames, $db);
$rowIndex = ;/*right here enter the column in the row that your user
names are stored in */
while ($row = mysql_fetch_row($result)) {
if ($row[$rowIndex] == $UserInput) {
return true;
}
return false;
}
mysql_close;
}/*This is the end of the function.. next you will have to
rip the user input from the post.. in this example I'll call
it $_POST["Name"] and use the function to return the
value if the function returns true then the name exists in
the database if false then it obviously don't*/
$Name = $_POST["name"];
$bolNames = Compare($Name);
if (bolNames == true) {
echo('The name exists');
}
if (bolNames == false) {
echo('The name don't exist')
}
?>
regardless of what performance freaks say.. this won't make a big dif in
performance unless you are like yahoo with several hundred million names to
compare to.. any intrensic functions basically do this same thing. This
gives you more power though. and if you have a HUGE user base you will
prolly be running mysql on a stand alone machine away from the web server so
that the traffic don't affect db interaction. FYI the syntax may be somewhat
rough, I'm somewhat new to the syntax.. I have been coding software for
quite some time and this works for me. Good luck.
"Dr. Zoidberg" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Manuel Lemos wrote:
> > Hello,
> >
> > On 03/25/2004 10:19 PM, Dr. Zoidberg wrote:
> >
> >> I'm creating registration service with this great form script for
> >> creating forms within Smarty.
> >>
> >> Question is how can I validate 'username' against allready registered
> >> users in MySQL so that someone cannot register him self if there is
> >> another user with that username.
> >
> >
> > You can always use the ValidateServerFunction parameter to specify the
> > name of a callback function that will make a database query to see if
> > ise there any user name with the value passed to that function. If there
> > is a record with that user name return 0 and the class will set the
> > respective input field as invalid.
>
> I'm trying to create that for a few hours. Can you PLS give me an example?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
