vinson89

How to defined it?

I got my search page error and the server pop up below message: Notice: Undefined variable: query in /home/tz005/public_html/COMP1687/search.php on line 64 Minimum length is 3 Where should I make a correction in the script? Here is my php script: <?php $min_length = 3; //min length of the search if(strlen($query) >= $min_length){ $query = htmlspecialchars($query); $raw_results = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM item_information WHERE (`itemtitle` LIKE '%".$query."%')") or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false))); if(mysqli_num_rows($raw_results) > 0){ // If it find's more than 0 results... while($results = mysqli_fetch_array($raw_results)){ echo "<p>".$results['itemtitle']."</p>"; // show's the results.. } } else{ // If found nothing.. echo "No results"; } } else{ // if length of the search is less than defined on variable... echo "Minimum length is ".$min_length; } ?>

thanks, i would like to try it.

Here is the php code: <?php //include database connection include 'dbconnect.php'; // if the form was submitted/posted, update the item if($_POST){ //write query $sql = "UPDATE item_information SET itemtitle = ?, itemdescription = ?, date = ?, WHERE itemid= ?"; $stmt = $mysqli->prepare($sql); // you can bind params this way, // if you want to see the other way, see our add.php $stmt->bind_param( 'sssi', $_POST['itemtitle'], $_POST['itemdescription'], $_POST['date'], $_POST['itemid'] ); // execute the update statement if($stmt->execute()){ echo "Item was updated."; // close the prepared statement $stmt->close(); }else{ die("Unable to update."); } } $sql = "SELECT itemid, itemtitle, itemdescription, date FROM item_information WHERE id = \"" . $mysqli->real_escape_string($_GET['itemid']) . "\" LIMIT 0,1"; // execute the sql query $result = $mysqli->query( $sql ); //get the result $row = $result->fetch_assoc(); extract($row); //disconnect from database $result->free(); $mysqli->close(); ?>

Hi, I got 1 warning form the server, It said: Warning: extract() expects parameter 1 to be array, null given in /home/tz005/public_html/COMP1687/edit.php on line 113 extract($row); how to fix the warning,should I replace it with extract($array);?

please check through this url: http://stuweb.cms.gre.ac.uk/~tz005/test2/activation-form.php and use the following information to try: username:tz005 activation code: 87839

I cannot redirect to other page even I enter correct information and recaptcha in activation form. Anyone who can check what going wrong in my activation script? Here is my php activation check script: <?php require_once('recaptchalib.php'); $privatekey = "6LfTwvMSAAAAABt03yGb0_12rgLNrCDuoibU4gbh"; $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { // What happens when the CAPTCHA was entered incorrectly die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." . "(reCAPTCHA said: " . $resp->error . ")"); } else { $username = $_POST['username']; $activation_code = $_POST['activation_code']; $db_host = "server"; $db_name = "table"; $db_use = "use"; $db_pass = "pass"; $link = mysqli_connect($db_host, $db_use, $db_pass); mysqli_select_db($link, $db_name); $command = "UPDATE email_activation SET check_activation='$activation_code' WHERE username='$username' and activation='$activation_code'"; $result = mysqli_query($command); if ($result) { $query = "SELECT * FROM email_activation where username LIKE '%$username%' LIMIT 0 , 1 "; $result = mysqli_query($query) OR die(mysqli_error()); while($row = mysqli_fetch_array($result)) { $username = $row['username']; $password = $row['password']; $email = $row['email']; $postcode = $row['postcode']; $query = "INSERT INTO member (username, password, email, postcode) VALUES ('$username','$password','$email','$postcode')"; $result = mysqli_query($link, $query) OR die(mysqli_error()); if ($result) { $_SESSION['user_logged'] = '1'; header("location:index.html"); echo "Congratulations. Your membership has been activated redirecting..."; }else{ header("location:index.html"); echo ("Congratulations. Your membership has been activated but it's can't saved in database."); } } }else{ header("location:activation-form.php"); echo ("You've entered an invalid username / activation code – please retry"); } } ?>

I have a sign up form to send the activation code to the new user via email.My question is how to restrict the user who is not a member using activation form page in PHP unless their use a sign up form first? here is my sign up form and activation form: sign up form <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12; } .style5 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16px; font-weight: bold; } .style7 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } --> </style> <form name="form1" method="post" action="email-activation-script.php"> <div align="center"> <p class="style5"> Form Registration </p> <table width="35%" border="0"> <tr> <td class="style7">Username</td> <td class="style7">:</td> <td class="style1"><span class="style7"> <label> <input name="username" type="text" id="username"> </label> </span></td> </tr> <tr> <td class="style7"> Email </td> <td class="style7">:</td> <td class="style1"><span class="style7"> <label> <input name="email" type="text" id="email"> </label> </span></td> </tr> <tr> <td class="style7">Password</td> <td class="style7">:</td> <td class="style1"><span class="style7"> <label> <input name="password" type="password" id="password"> </label> </span></td> </tr> <tr> <td class="style7"> </td> <td class="style7"> </td> <td class="style1"><span class="style7"> <label> <input type="submit" name="Submit" value="Register"> <input type="reset" name="Submit2" value="Cancel"> </label> </span></td> </tr> </table> </div> </form> activation form: <form name="form1" method="post" action="check-activation-script.php"> <div align="center"> <table width="35%" border="0"> <tr> <td>Username</td> <td>:</td> <td><label> <input name="username" type="text" id="username"> </label></td> </tr> <tr> <td>Activation Code </td> <td><label>:</label></td> <td><input name="activation_code" type="text" id="activation_code"></td> </tr> <tr> <td> </td> <td> </td> <td><label> <input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Cancel"> </label></td> </tr> </table> </div> </form>

Hi, I'm quite new to PHP and I have some problem in my php script.How do we allow the user immediately logged into the system after they enter the correct activation code? Here is my script: <?php $username = $_POST['username']; $activation_code = $_POST['activation_code']; $db_host = "localhost"; $db_name = "databasename"; $db_use = "root"; $db_pass = "password"; $link = mysql_connect($db_host, $db_use, $db_pass); mysql_select_db($db_name, $link); $command = "UPDATE email_activation SET check_activation='$activation_code' WHERE username='$username' and activation='$activation_code'"; $result = mysql_query($command); if ($result) { $query = "SELECT * FROM email_activation where username LIKE '%$username%' LIMIT 0 , 1 "; $result = mysql_query($query) OR die(mysql_error()); while($row = mysql_fetch_array($result)) { $name = $row['username']; $email = $row['email']; $password = $row['password]; $activation = $row['activation']; $query = "INSERT INTO member (username, email, password, activation) VALUES ('$username','$email','$password','$activation')"; $result = mysql_query($query) OR die(mysql_error()); if ($result) { echo "Congratulations. Your membership has been activated and saved in member table …"; }else{ echo ("Congratulations. Your membership has been activated but it's can't saved in member table …"); } } }else{ echo ("You've entered an invalid username / activation code – please retry"); } ?>

my question is how to add the script that allow registered user details from email_activation db to member db during verification process done using the script above.

<?php require_once('recaptchalib.php'); $privatekey = "your_private_key"; $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { // What happens when the CAPTCHA was entered incorrectly die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." . "(reCAPTCHA said: " . $resp->error . ")"); } else { $username = $_POST['username']; $activation_code = $_POST['activation_code']; $db_host = "localhost"; $db_name = "databasename"; $db_use = "root"; $db_pass = "password"; $link = mysql_connect($db_host, $db_use, $db_pass); mysql_select_db($db_name, $link); $command = "UPDATE email_activation SET check_activation='$activation_code' WHERE username='$username' and activation='$activation_code'"; $result = mysql_query($command); if ($result) { echo "Congratulations. Your membership has been activated …"; }else{ echo ("You've entered an invalid username / activation code – please retry"); } } ?>