PHP Form Processing


Function value=" . $function1 . "";
echo "

You Submitted:

"; else //add URL { $mainsection="links"; $query1="select * from " . $mainsection . " order by id"; $result = mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1); $i1=1; $i2=0; while($thisrow=mysql_fetch_row($result)) //get one row { if ($i1<$thisrow[$idn]) { if ($i2==0) $i2=$i1; } $i1++; } if ($i2==0) $i2=$i1; //$i2 is now the lowest value for id. $i1=0; // Search for the current url $query2="select * from " . $mainsection . " as t1 where t1.url = \"" . $url . "\""; //Look for the link in the current system -140 $result = mysql_db_query($dbname, $query2) or die("Failed Query of " . $query2); if ($thisrow=mysql_fetch_row($result)) // If already in system { if (($category==$thisrow[$cat1n]) or ($category==$thisrow[$cat2n]) or ($category==$thisrow[$cat3n]) or ($category==$thisrow[$cat4n])) //in requested category { echo "

The URL is already listed in the requested category.
"; echo "URL name: " . $url . "
"; if ($thisrow[$approv]==0) echo "Please be patient, it is not yet approved for main viewing.
"; if ($thisrow[$activen]==0) echo "It is shown as inactive, please send us an e-mail if it is active.
"; echo "Thank you for your interest.

"; } else //not in the requested category //421 { echo "

The URL is already listed in another category.
"; echo "URL name: " . $url . "
"; if ($thisrow[$approv]==0) echo "Please be patient, it is not yet approved for main viewing.
"; if ($thisrow[$activen]==0) echo "It is shown as inactive, please send us an e-mail if it is active.
"; echo "Thank you for your interest.

"; } } else //not in system { $i1=1; $id=$i2; // $query1="insert into " . $mainsection . " (url, sitetitle, description, gifurl, cat1, email, creator, id, entdate, sitetype) values (\"" . $url . "\",\"" . $title . "\",\"" . $description . "\",\"" . $gifurl . "\",\"" . $category . "\",\"" . $email . "\",\"" . $uname . "\"," . $i2 . ", CURDATE())"; //163 $query1="insert into " . $mainsection . " (url, sitetitle, description, gifurl, cat1, email, creator, id, entdate, sitetype) values (\"" . $url . "\",\"" . $title . "\",\"" . $description . "\",\"" . $gifurl . "\",\"" . $category . "\",\"" . $email . "\",\"" . $uname . "\"," . $i2 . ", CURDATE()," . $stype . ")"; //163 mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1); echo "URL: " . $url . "
"; echo "Title: " . $title . "
"; echo "Description: " . $description . "
"; echo "Gif URL: " . $gifurl . "
"; echo "User Name: " . $uname . "
"; echo "E-mail address: " . $email . "


"; echo "The changes will be final when they are approved by our staff.

"; } //389 } //end add URL
PHP Manual Contents Page