|
PHP - What Is Wrong With My Form Submit Code?
I have a form using PHP to submit to MySQL DB and also uses PHP for validation. It worked before I added the validation stuff, so something must be wrong, but I am not sure what. I don't get any errors.
Here is the code for the form <?php include("validation.php"); ?> <form id="ContactForm" method="POST" action=""> <fieldset> <div> <label>First Name</label> <input id="FirstName" name="FirstName" maxlength="120" type="text" autocomplete="off" value="<?php echo $valid_FirstName; ?>" /> </div> <div> <label>Last Name</label> <input id="LastName" name="LastName" maxlength="120" type="text" autocomplete="off" value="<?php echo $valid_LastName; ?>" /> </div> </fieldset> <fieldset> <div> <label>User Name</label> <input id="UserName" name="UserName" maxlength="120" type="text" autocomplete="off" value="<?php echo $valid_UserName; ?>" /> </div> <div> <label>Password</label> <input type="password" id="Password" name="Password" maxlength="120" type="text" autocomplete="off" value="<?php echo $valid_Password; ?>" /> </div> <div> <label>Email</label> <input id="email" name="email" maxlength="120" type="text" autocomplete="off" value="<?php echo $valid_email; ?>" /> </div> </fieldset> <fieldset> <div> <label>Zip Code</label> <input id="Zip" name="Zip" maxlength="12" type="text" autocomplete="off" value="<?php echo $valid_Zip; ?>" /> </div> <div> <label>Birthday (mm/dd/yyyy format)</label> <input id="Birthday" name="Birthday" maxlength="12" type="text" autocomplete="off" value="<?php echo $valid_DOB; ?>" /> </div> <div> <label>Security Question</label> <input id="Security" name="Security" maxlength="255" type="text" autocomplete="off" value="<?php echo $valid_Security; ?>" /> </div> </fieldset> <fieldset> <div class="controls"> <input id="submit" type="submit" name="submit" value="CREATE PROFILE"/> </div> </fieldset> </form> and the validation and submit to DB <?php ; $db_user = ""; $db_pass = ""; $db = ""; $link = mysql_connect('localhost',$db_user,$db_pass); $db_selected = mysql_select_db($db); /*debugging*/ if (!$link) { die('Could not connect: ' . mysql_error()); } if (!$db_selected) { die ('Can\'t use foo : ' . mysql_error()); } if($_POST) { $FirstName=mysql_real_escape_string($_POST['FirstName']); //This value has to be the same as in the HTML form file $LastName=mysql_real_escape_string($_POST['LastName']); //This value has to be the same as in the HTML form file $UserName=mysql_real_escape_string($_POST['UserName']); //This value has to be the same as in the HTML form file $Password= md5($_POST['Password']); //This value has to be the same as in the HTML form file $email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file $Zip=mysql_real_escape_string($_POST['Zip']); //This value has to be the same as in the HTML form file $Birthday=mysql_real_escape_string($_POST['Birthday']); //This value has to be the same as in the HTML form file $Security=mysql_real_escape_string($_POST['Security']); //This value has to be the same as in the HTML form file // First Name if (eregi('^[A-Za-z0-9 ]{3,20}$',$FirstName)) { $valid_FirstName=$FirstName; } else { $error_FirstName='Enter valid First Name.'; } // Last Name if (eregi('^[A-Za-z0-9 ]{3,20}$',$LastName)) { $valid_LastName=$LastName; } else { $error_LastName='Enter valid Last Name.'; } if (eregi('^[a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.([a-zA-Z]{2,4})$', $email)) { $valid_email=$email; } else { $error_email='Enter valid Email.'; } // Usename min 2 char max 20 char if (eregi('^[A-Za-z0-9_]{3,20}$',$UserName)) { $valid_UserName=$UserName; } else { $error_UserName='Enter valid Username min 3 Chars.'; } // Password min 6 char max 20 char if (eregi('^[A-Za-z0-9!@#$%^&*()_]{6,20}$',$Password)) { $valid_Password=$Password; } else { $error_Password='Enter valid Password min 6 Chars.'; } // Zip if (eregi('^[A-Za-z0-9 ]{3,20}$',$Zip)) { $valid_Zip=$Zip; } else { $error_Zip='Enter valid Zip Code.'; } // Security Phrase if (eregi('^[A-Za-z0-9 ]{3,20}$',$Security)) { $valid_Security=$Security; } else { $error_Security='Enter valid Security Phrase.'; } if((strlen($valid_FirstName)>0)&&(strlen($valid_LastName)>0)&&(strlen($valid_UserName)>0)&&(strlen($valid_Password)>0)&&(strlen($valid_email)>0)&&(strlen($valid_Zip)>0)&&(strlen($valid_DOB)>0) &&(strlen($valid_Security)>0) ) { mysql_query("INSERT INTO Profile (`FirstName`,`LastName`,`Username`,`Password`,`email`,`Zip`,`Birthday`,`Security`) VALUES ('$FirstName','$LastName','$UserName','$Password','$email','$Zip','$Birthday','$Security')" ); header("Location:login.php"); } else{ } } ?> Similar TutorialsI am not getting the result I am hoping for. The code below is full code after a form has been submitted containing a member name and amount of credits: Code: [Select] <?php if (isset($t)){ $t = $_GET['t'];} ?> <?php $amount = $_POST['amount']; $member = $_POST['member']; $sql = ("SELECT vtp_members.name, vtp_members.team_id FROM vtp_members WHERE vtp_members.team_id=".$_GET['t']." AND vtp_members.name='$member' AND teams.team_treasure >= '$amount' "); $result = mysql_query($sql); $numrows = mysql_num_rows($result); if($numrows == '1') { $sql2 = "UPDATE vtp_members, teams SET vtp_members.hits=(vtp_members.hits + '$amount'), teams.team_treasure=(teams.team_treasure - '$amount') WHERE vtp_members.name='$member' AND teams.team_id=".$_GET['t']." "; $results2 = mysql_query($sql2); $row2 = mysql_fetch_row($results2); $tmap2 = $row2[0]; echo "You sent ". $amount . "credits to " . $member . ". "; } else { echo "The treasure holdings are too low for this transfer<br>(or an error occured)";} ?> Problem; it returns the else statement although the "teams.team_treasure" is higher or equal to "$amount" This topic has been moved to JavaScript Help. http://www.phpfreaks.com/forums/index.php?topic=347131.0 Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once. Is that possible to do? Here's my code.
if(isset($_POST['submit'])) {
$entries = 10;
$id = 55;
$name = 'Smith';
$insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
$insert->bindParam(':id', $id);
$insert->bindParam(':name', $name);
$result_insert = $insert->execute();
if($result_insert == false) {
echo 'Fail';
} else {
echo 'Success';
}
}
?>
<form action="" method="post">
<input type="submit" name="submit" value="SUBMIT" />
</form>
Edited January 13, 2019 by imgrooot Hi. Pretty straight forward I guess but as the name suggests am a newbie. I have a form that requires the user to enter certain parameters. If the values are blank it submits to itself and loads the error messages. What I want to do is create PHP code that submits the form to a different url. What I thought was create two forms (the second with hidden fields replicating the first form), each form having a different url in the action"" code. What I cant work out is the PHP IF ELSE code to submit form 2 if Form1 is is validated correctly. This is the PHP code relevant to the form validation. Help? <?php //If form was submitted if ($_POST['submitted']==1) { $errormsg = ""; //Initialize errors if ($_POST[width]){ $title = $_POST[width]; //If title was entered } else{ $errormsg = "Please enter width"; } if ($_POST[drop]){ $textentry = $_POST[drop]; //If comment was entered } else{ if ($errormsg){ //If there is already an error, add next error $errormsg = $errormsg . " & content"; }else{ $errormsg = "Please enter drop"; } } } if ($errormsg){ //If any errors display them echo "<div class=\"box red\">$errormsg</div>"; } //If all fields present if ($title && $textentry){ //Do something echo 'THIS IS WHERE I WANT THE CODE TO SUBMIT FORM 2 or SUBMIT FORM 1 TO A DIFFERENT URL'; } ?> Hello, first time poster.. I've looked the web over for a long time and can't figure this one out. - Below is basic code that successfully checks MySQL for a match and displays result. I was debugging and forced the "height" and "width" to be 24 and 36 to make sure that wasn't the problem. That's good.. - I'd like to give the user ability to select width and height from a form.. and have it do an onchange this.form.submit so the form can be changing as fields are altered (thus the onchange interaction) - In a normal coding environment I've done this numerous times with no "Page cannot be displayed" problems. It would simply change one select-option value at a time til they get down the form and click submit... but in WordPress I'm having trouble making even ONE single onchange work! - I've implemented the plugins they offer which allows you to "copy+paste" your php code directly into their wysiwyg editor. That works with basic tests like my first bullet point above. - I've copied and pasted the wordpress url (including the little ?page_id=123) into the form "action" url... that didn't work... tried forcing it into an <option value=""> tag.. didn't work. I'm just not sure. I've obviously put xx's in place of private info.. Why does this form give me Page Cannot Be Displayed in WordPress every time? It won't do anything no matter how simple.. using onchange.. Code.. $con = mysql_connect("xxxx.xxxxxxx.com","xxxxxx","xxxxx"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("xxxxxx", $con); $myprodwidth=24; $myprodheight=36; $result = mysql_query("SELECT * FROM product_sizes WHERE prodwidth='$myprodwidth' and prodheight='$myprodheight'"); while($row = mysql_fetch_array($result)) { echo $row['prodprice']; } mysql_close($con); <form method="post" action=""> <select name="myheight" onchange="this.form.submit();"> <option selected="selected" value="">select height</option> <option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">36</option> <option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">48</option> </select> Good day all, I have this change password code and it works well when all the parameters are ok, like username correct and email correct. But when I test it to see the result if the wrong username or email is entered the else statement doesnt run, not even an error, just skips the code and shows the other parts of the page, just as if the code did not run. Here is the code: <?php include("mysql_connect.php"); $username=$_POST['username']; $email=$_POST['email']; $newpassword=$_POST['newpassword']; $confirm_newpassword=$_POST['confirm_newpassword']; $query = "SELECT * FROM users WHERE username='$username' AND email='$email'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ if ($username == $row["username"] && $email == $row["email"]){ echo "<center><h1>Thank you " . $row["firstname"] ." ". $row["surname"] .". Your password has been changed.<br/> An email has also been sent to $email with the details of the new password.</h1></center>"; $sql="UPDATE users SET password = '$newpassword', password_confirm='$confirm_newpassword' WHERE (id = $row[id])"; $update = mysql_query($sql) or die(mysql_error()); $to = $row["email"]; $subject = "Your password change at My Site"; $message = "Dear " . $row["firstname"] ." ". $row["surname"] .",\r\rYour Password Change has been completed successfully.\r\rYour New Password is:\r". $row["password"] .".\r\rPlease guard this Password carefully.\r\rRegards,\rAdmin - My Site"; require_once "class.phpmailer.php"; $mail = new PHPMailer(); $mail->IsSendmail(); $mail->SetFrom('admin@mysite.com', 'Admin - My Site'); $mail->AddAddress($to); $mail->Subject = $subject; $mail->Body = $message; $mail->Send(); } else{ echo"<center><h1>Invalid username and/or email.<br/>Please go back to the <a href=\"password_recovery.php\">Password Change Request</a> page and enter correct details.</h1></center>"; } } ?> here is code: Code: [Select] <?php session_start(); // Must start session first thing /* Created By Adam Khoury @ www.flashbuilding.com -----------------------June 20, 2008----------------------- */ // Here we run a login check if (!isset($_SESSION['id'])) { echo 'Please <a href="login.php">log in</a> to access your account'; exit(); } //Connect to the database through our include include_once "connect_to_mysql.php"; // Place Session variable 'id' into local variable $userid = $_SESSION['id']; // Query member data from the database and ready it for display $sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $name = $row["name"]; $phone = $row["phone"]; $username = $row["username"]; $address = $row["address"]; $city = $row["city"]; $state = $row["state"]; $zip = $row["zip"]; $cell = $row["cell"]; $email = $row["email"]; $accounttype = $row["accounttype"]; $rank = $row["rank"]; $badges = $row["badges"]; } // Set error message as blank upon arrival to page $errorMsg = ""; // First we check to see if the form has been submitted if (isset($_POST['username'])){ $name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters $phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters $username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters $address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters $city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters $state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters $zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters $cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters $email = stripslashes($_POST['email']); $email = strip_tags($email); $email = mysql_real_escape_string($email); if((!$email)){ $errorMsg = "You did not submit the following required information!<br /><br />"; if(!$email){ $errorMsg .= "--- Email Address"; } } else { $sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email) VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error()); $to = "$email"; // Change this to your site admin email $from = "events@final.net46.net"; $subject = "Complete your registration"; //Begin HTML Email Message where you need to change the activation URL inside $message = '<html> <body bgcolor="#FFFFFF"> Hi ' . $username . ', <br /><br /> You must complete this step to activate your account with us. <br /><br /> Please click here to activate now >> <a href="http://www.somewebsite.com/activation.php?id=' . $id . '"> ACTIVATE NOW</a> <br /><br /> Your Login Data is as follows: <br /><br /> E-mail Address: ' . $email . ' <br /> Password: ' . $password . ' <br /><br /> Thanks! </body> </html>'; // end of message $headers = "From: $from\r\n"; $headers .= "Content-type: text/html\r\n"; $to = "$to"; // Finally send the activation email to the member mail($to, $subject, $message, $headers); // Then print a message to the browser for the joiner print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br /> We just sent an Activation link to: $email<br /><br /> <strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br /> Link inside the message. After email activation you can log in."; exit(); // Exit so the form and page does not display, just this success message } // Close else after database duplicate field value checks } // Close else after missing vars check //Close if $_POST ?> <?php // if no id is specified, list the available articles if(!isset($_GET['eventid'])) { $self = $_SERVER['PHP_SELF']; $query = "SELECT eventid, event FROM Registration ORDER BY eventid"; $result = mysql_query($query) or die('Error : ' . mysql_error()); // create the article list $description = '<ol>'; while($row = mysql_fetch_array($result, MYSQL_NUM)) { list($eventid, $event, $date) = $row; $description .= "<li><a href=\"$self?eventid=$eventid\">$event</a></li>\r\n"; } $description .= '</ol>'; $Events = 'Events'; } else { // get the article info from database $query = "SELECT event, description, startdate, enddate location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid']; $result = mysql_query($query) or die('Error : ' . mysql_error()); $row = mysql_fetch_array($result, MYSQL_ASSOC); $event = $row['event']; $description = $row['description']; $startdate = $row['startdate']; $enddate = $row['enddate']; $location = $row['location']; $subevent1 = $row['subevent1']; $subevent2 = $row['subevent2']; $subevent3 = $row['subevent3']; $subevent4 = $row['subevent4']; $subevent5 = $row['subevent5']; $subevent6 = $row['subevent6']; $subevent7 = $row['subevent7']; $subevent8 = $row['subevent8']; $price1 = $row['price1']; $price2 = $row['price2']; $price3 = $row['price3']; $price4 = $row['price4']; $price5 = $row['price5']; $price6 = $row['price6']; $price7 = $row['price7']; $price8 = $row['price8']; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Register</title> <style type="text/css"> #apDiv1 { position:absolute; left:33px; top:320px; width:252px; height:48px; z-index:1; } #apDiv2 { position:absolute; left:33px; top:361px; width:254px; height:46px; z-index:2; } #apDiv3 { position:absolute; left:33px; top:525px; width:256px; height:43px; z-index:3; } #apDiv4 { position:absolute; left:33px; top:402px; width:250px; height:48px; z-index:4; } #apDiv5 { position:absolute; left:106px; top:616px; width:263px; height:255px; z-index:5; } #apDiv6 { position:absolute; left:323px; top:200px; width:898px; height:530px; z-index:5; } #apDiv7 { position:absolute; left:33px; top:443px; width:266px; height:42px; z-index:6; } #apDiv8 { position:absolute; left:111px; top:500px; width:125px; height:37px; z-index:7; } #apDiv8 strong { font-size: 24px; } #apDiv9 { position:absolute; left:33px; top:408px; width:267px; height:49px; z-index:8; } #apDiv10 { position:absolute; left:33px; top:449px; width:242px; height:23px; z-index:9; } #apDiv8 a { color: #000; } #apDiv11 { position:absolute; left:101px; top:490px; width:168px; height:42px; z-index:10; font-size: 24px; font-weight: bold; } #apDiv11 a { color: #000; } #apDiv12 { position:absolute; left:33px; top:210px; width:205px; height:107px; z-index:11; } #apDiv12 { text-align: center; } #apDiv13 { position:absolute; left:33px; top:320px; width:248px; height:47px; z-index:12; } #apDiv { position:absolute; left:33px; top:484px; width:225px; height:35px; z-index:11; } #apDiv14 { position:absolute; left:33px; top:566px; width:298px; height:51px; z-index:12; } #apDiv15 { position:absolute; left:101px; top:611px; width:168px; height:42px; z-index:10; font-size: 24px; font-weight: bold; } #apDiv5 a { font-size: 24px; color: #000; font-weight: bold; } #apDiv23 table tr td1 { font-size: 14px; } </style> <script type="text/javascript"> function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } </script> <style type="text/css"> #apDiv6 #form1 table tr th { text-align: center; } #apDiv6 table tr td table tr td { text-align: center; } #apDiv16 { position:absolute; left:330px; top:45px; width:208px; height:100px; z-index:13; } #apDiv6 table tr td #apDiv16 table tr th { font-size: 36px; } #apDiv17 { position:absolute; left:183px; top:342px; width:427px; height:65px; z-index:13; } #apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th { color: #999; } </style> <style type="text/css"> #apDiv19 { position:absolute; left:33px; top:320px; width:271px; height:33px; z-index:13; } #apDiv20 { position:absolute; left:578px; top:368px; width:157px; height:87px; z-index:14; } #apDiv21 { position:absolute; left:8px; top:705px; width:270px; height:683px; z-index:15; } #apDiv22 { position:absolute; left:476px; top:313px; width:596px; height:124px; z-index:16; } #apDiv6 table tr td table tr th { text-align: left; } #apDiv23 { position:absolute; left:626px; top:250px; width:247px; height:85px; z-index:16; text-align: center; font-size: 36px; } #apDiv23 table tr td { text-align: center; font-size: 24px; } #apDiv24 { position:absolute; left:626px; top:295px; width:247px; height:63px; z-index:17; text-align: center; font-size: 20px; } .klgjsa { font-size: 18px; } #apDiv24 { font-size: 16px; } #apDiv24 { font-size: 18px; } #apDiv24 { color: #C90; } </style> </head> <body onload="MM_preloadImages('button/pictures2.png','button/projects1.png','button/news2.png','button/eventmanager2.png','button/membermanager2.png','button/newsmanager2.png','button/myprofile2.png')"> <div id="apDiv6"> <table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699"> <tr> <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1> <p> </p> <p> </p> <p><?php echo $description; ?></p> <p> </p> <p> </p> <?php $sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $name = $row["name"]; $phone = $row["phone"]; $address = $row["address"]; $city = $row["city"]; $state = $row["state"]; $zip = $row["zip"]; $cell = $row["cell"]; $email = $row["email"]; } $sql = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']." LIMIT 1"); while($row = mysql_fetch_array($sql)){ $event= $row["event"]; $subevent1 = $row['subevent1']; $subevent2 = $row['subevent2']; $subevent3 = $row['subevent3']; $subevent4 = $row['subevent4']; $subevent5 = $row['subevent5']; $subevent6 = $row['subevent6']; $subevent7 = $row['subevent7']; $subevent8 = $row['subevent8']; $price1 = $row['price1']; $price2 = $row['price2']; $price3 = $row['price3']; $price4 = $row['price4']; $price5 = $row['price5']; $price6 = $row['price6']; $price7 = $row['price7']; $price8 = $row['price8']; } ?> <?php // when displaying an article show a link // to see the article list if(isset($_GET['eventid'])) { ?> <div id="jQueryUIAccordion"> <h3> </h3> <div> <p> <table width="575" border="0" cellspacing="2" cellpadding="2"> <tr> <th width="563" bgcolor="#999999" scope="col">Location</th> </tr> </table> <table width="574" height="16" border="0" cellpadding="2" cellspacing="2"> <tr> <th height="12" scope="col"><?php echo $location; ?></th> </tr> </table> <table width="573" border="0" cellspacing="2" cellpadding="2"> <tr> <th width="561" bgcolor="#999999" scope="col">Description</th> </tr> </table> <table width="576" border="0" cellspacing="2" cellpadding="2"> <tr> <th width="564" height="11" scope="col"><?php echo $title1; ?><br /><?php echo $price1; ?></th> <th width="564" scope="col"><?php echo $subevent1; ?></th> </tr> <tr> <th height="11" scope="col"><?php echo $title2; ?><br /><?php echo $price2; ?></th> <th scope="col"><?php echo $subevent2; ?> </th> </tr> <tr> <th height="11" scope="col"><?php echo $title3; ?><br /><?php echo $price3; ?></th> <th scope="col"><?php echo $subevent3; ?></th> </tr> <tr> <th height="11" scope="col"><?php echo $title4; ?><br /><?php echo $price4; ?></th> <th scope="col"><?php echo $subevent4; ?></th> </tr> <tr> <th height="11" scope="col"><?php echo $title5; ?><br /><?php echo $price5; ?></th> <th scope="col"><?php echo $subevent5; ?></th> </tr> <tr> <th height="11" scope="col"><?php echo $title6; ?><br /><?php echo $price6; ?></th> <th scope="col"><?php echo $subevent6; ?></th> </tr> <tr> <th height="11" scope="col"><?php echo $title7; ?><br /><?php echo $price7; ?></th> <th scope="col"><?php echo $subevent7; ?></th> </tr> <tr> <th height="11" scope="col"><?php echo $title8; ?><br /><?php echo $price8; ?></th> <th scope="col"><?php echo $subevent8; ?></th> </tr> </table> <hr /> <table width="200" border="0" cellspacing="2" cellpadding="2"> <tr> <th scope="col">Price:</th> </tr> </table> <table width="200" border="0" cellspacing="2" cellpadding="2"> <tr> <th scope="col">$<?php echo $price; ?></th> </tr> </table> </p> <?php if (isset($_GET['eventid'])) { include('connect1.php'); $sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $eventid = $row["eventid"]; $event = $row["event"]; $date = $row["date"]; $description = $row["description"]; $location = $row["location"]; } $result = mysqli_query($dbcon, $query) or die('error getting data'); echo "<table>"; while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo "<tr><td>"; echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>"; echo "</td></tr>"; } echo "</table>"; } ?> <div id="apDiv18"></div> <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p> <?php } ?></td></tr> </table> </div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div> <div id="apDiv4"><a href="projects.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','button/projects2.png',1)"><img src="button/projects1.png" name="Image4" width="235" height="50" border="0" id="Image4" /></a></div> <div id="apDiv11"><?php if ($accounttype == "Scout") { echo '<a href="../logout.php">Logout</a>';} ?></div> <div id="apDiv12"><?php echo "$accounttype"; ?> <p><?php echo "$name"; ?></p> <p>Troop 78</p> </div> <div id="apDiv5"><?php if ($accounttype == "Admin") { echo "<a href=\"../logout.php\">Logout</a>"; } ?></div> <div id="apDiv7"><a href="news.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','button/news2.png',1)"><img src="button/news1.png" name="Image6" width="235" height="50" border="0" id="Image6" /></a></div> <div id="apDiv"> <?php if ($accounttype == "Admin") { echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>"; } ?></div> <div id="apDiv3"><?php if ($accounttype == "Admin") { echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\" name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>"; } ?> </div> <div id="apDiv14"><?php if ($accounttype == "Admin") { echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\" name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>"; } ?> </div> <div id="apDiv19"><a href="myprofile.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','button/myprofile2.png',1)"><img src="button/myprofile1.png" name="Image5" width="235" height="50" border="0" id="Image5" /></a></div> <div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div> <div id="apDiv23"><?php echo $event; ?> <br /> </div> <div id="apDiv24"><?php echo $startdate;?> <span class="klgjsa">-</span> <?php echo $enddate; ?></div> <img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" /> </body> </html> here is error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a6254834/public_html/register.php on line 469 help? Can anyone see what is wrong with this code? I get the following parse error: syntax error, unexpected $end Code: [Select] if(isSet($_GET['answer'])) { $answ = $_GET['answer']; $nextanswer=$answ+1;} else{} $counter2 = 1; while ($counter2 <= $answ): echo $Answer[$counter2]."<br>"; $counter2++; endwhile; if($nextansw>0){ if(isset($Answer[$nextanswer])){ echo "<a href=\"/Code-sandbox.php?sid=".$name."&answer=".$nextanswer."\">next</a>";} else{echo "End of questions<br>";} else{} Ive made this code: Code: [Select] <?php $button = $_GET['submit']; $search = $_GET['search']; $s = $_GET['s']; if (!$s) $s = 0; $e = 10; $next = $s + $e; $prev = $s - $e; if (strlen($search)<=2) echo "Must be greater then 3 chars"; else { echo "<br /><table><tr><td><img src='juzzy.jpg' /></td><td><form action='search.php' method='GET'><input type='text' onclick=value='' size='50' name='search' value='$search'> <input type='submit' name='submit' value='Search'></form></td></tr></table>"; mysql_connect("localhost","*********","*******"); mysql_select_db("************"); $search_exploded = explode(" ",$search); foreach($search_exploded as $search_each) { $x++; if ($x==1) $construct .= "keywords LIKE '%$search_each%'"; else $construct .= " OR keywords LIKE '%$search_each%'"; } $constructx = "SELECT * FROM searchengine WHERE $construct"; $construct = "SELECT * FROM searchengine WHERE $construct LIMIT $s,$e"; $run = mysql_query($constructx); $foundnum = mysql_num_rows($run); //here is the thing which is causing the error. $run_two = mysql_query("$construct"); if ($foundnum==0) echo "No results found for <b>$search</b>"; else { echo "<table bgcolor='#0000FF' width='100%' height='1px'><br /></table><table bgcolor='#f0f7f9' width='100%' height='10px'><tr><td><div align='right'>Showing 1-10 of <b>$foundnum</b> results found for <b>$search.</b></div></td></tr></table><p>"; while ($runrows = mysql_fetch_assoc($run_two)) { $title = $runrows['title']; $desc = $runrows['description']; $url = $runrows['url']; echo "<table width='300px'> <h4><a href='http://$url'><b>$title</b></a><br /> $desc<br> <font color='00CC00'>$url</font></table></h4> "; } ?> <table width='100%'> <tr> <td> <div align="left"> <?php if (!$s<=0) echo "<a href='search.php?search=$search&s=$prev'>Prev</a>"; $i =1; for ($x=0;$x<$foundnum;$x=$x+$e) { echo " <a href='search.php?search=$search&s=$x'>$i</a> "; $i++; } if ($s<$foundnum-$e) echo "<a href='search.php?search=$search&s=$next'>Next</a>"; } } ?> </div> </td> </tr> </table> And when ive uploaded it to the host and tryed to search using it (this is just the main code, not the index code) it comes up with this one error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/seanhall/public_html/Search/search.php on line 54 Sorry for the amount of code below this is one full page. Ok, when I try to login to the member section it wont let me. I can succesfully register and have made sure that the data is there in MySQL. Every time I try to login the page just refreshes. Oh and I am new here. I think it has something to do with the (header("Location: http://www.PureReactionUK.com/member.php/"); exit;)? I could be wrong. Here is my code: Code: [Select] <?php session_start(); include 'config.php'; if(isset($_POST['login'])) { $username = trim(addslashes($_POST['username'])); $password = md5(trim($_POST['password'])); $query = mysql_query("SELECT * FROM Users WHERE Username = '$username' AND Password = '$password' LIMIT 1") or die(mysql_error()); $row = mysql_fetch_array($query); if(mysql_num_rows($query) > 0) { if($row['Activated'] > 0) { $_SESSION['s_logged_n'] = 'true'; $_SESSION['s_username'] = $username; $_SESSION['s_name'] = $row['Name']; header("Location: http://www.PureReactionUK.com/member.php/"); exit; } else { echo ' <!DOCTYPE HTML> <html> <head> <title>PureReactionUK - Home</title> <link rel="shortcut icon" href="images/favicon.ico"> <meta name="description" content="Here you will find a tone of things that you will find very helpfull." /> <meta name="keywords" content="Pure,Reaction,UK,HD,BD,x,Brutal,Democracy,iPad,iPhone,iPod,Theme,WinetrBoard,iOS,Hack,Mod,Cydia,Surik,Apple,Game,Apps,USB,Fix,Restore,Design,SummerBoard,Playstation,3,Xbox,360,MineCraft,Server,Call,Of,Duty,Modern,Warfare,2,3,4,5,6,7,8,9,Black,Ops,Icons,Zombies,Jtag,SSH,iFile,HTML,Jailbreak,CSS,Javascript,Craig,Stewart,YouTube,Music,Downloads,Servers,Bukkit,MCAdmin,Tiny,Umbrella,GreenpoisOn,SpringBoard,Windows,Microsoft,XP,Vista" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" type="text/css" href="css/style.css" /> <script src="javascript/rollover.js" type="text/javascript"></script> <style type="text/css"> body,td,th { font-family: "trebuchet ms", arial, sans-serif; font-size: 0.8em; } a:link { color: #09F; } </style> </head> <body> <div id="main"> <div id="header"> <div id="logo"> <div id="logo_text"> <h1><a href="index.html">PureReaction<span class="logo_colour">UK</span></a></h1> <h2>All You Need To Know Is Here, Have A Look</h2> </div> </div> <div id="menubar"> <ul id="menu"> <li class="selected"><a href="index.html" title="Home" target="_self">Home</a></li> <li><a href="tutorials.html" title="Tutorials" target="_self">Tutorials</a></li> <li><a href="downloads.html" title="Downloads" target="_self">Downloads</a></li> <li><a href="register.html" title="Register" target="_self">Register</a></li> <li><a href="login.html" title="Log In" target="_self">Log In</a></li> </ul> </div> </div> <div id="content_header"></div> <div id="site_content"> <div class="sidebar"> <h3>Latest Updates</h3> <h4> Website Launched</h4> <h5>January 1st, 2010</h5> <p>Take a good look around and take your time there is alot of content to explore. <br /> <a href="index.html" title="Home" target="_self">Read more</a></p> <p></p> <h4>New Downloads</h4> <h5>January 1st, 2010</h5> <p>Check out the latest downloads by clicking the link below. Remember you must sign up / sign in.<br /> <a href="downloads.html" title="Downloads" target="_self">Read more</a></p> <h3>Useful Links</h3> <ul> <li><a href="http://www.minecraft.net/" title="MineCraft" target="_blank">MineCraft</a></li> <li><a href="http://modmyi.com/" title="ModMyi" target="_blank">ModMyi</a></li> <li><a href="http://www.ifans.com/" title="iFans" target="_blank">iFans</a> <ul> <li><a href="http://www.minecraftforum.net/" title="MineCraft Forum" target="_blank">MineCraft - Forum</a></li> </ul> </li> </ul> </div> <div id="content"> <h1>Log In Here</h1><div id="error"><p>Sorry, you must activate your account first. Please check your email for the email.</p> <p>Didn'."'".'t get your validation email? <a href="resend.php">Click here</a> to resend the validation email.</p></div> </p> </div> </div> <div id="content_footer"></div> <div id="footer"> Copyright © All Rights Reserved By <a href="http://www.purereactionuk.com/" title="PureReactionUK" target="_self">www.PureReactionuk.com</a> - 2011</div> </div> </body> </html> '; } } else { echo ' <html> <head> <title>PureReactionUK - Home</title> <link rel="shortcut icon" href="images/favicon.ico"> <meta name="description" content="Here you will find a tone of things that you will find very helpfull." /> <meta name="keywords" content="Pure,Reaction,UK,HD,BD,x,Brutal,Democracy,iPad,iPhone,iPod,Theme,WinetrBoard,iOS,Hack,Mod,Cydia,Surik,Apple,Game,Apps,USB,Fix,Restore,Design,SummerBoard,Playstation,3,Xbox,360,MineCraft,Server,Call,Of,Duty,Modern,Warfare,2,3,4,5,6,7,8,9,Black,Ops,Icons,Zombies,Jtag,SSH,iFile,HTML,Jailbreak,CSS,Javascript,Craig,Stewart,YouTube,Music,Downloads,Servers,Bukkit,MCAdmin,Tiny,Umbrella,GreenpoisOn,SpringBoard,Windows,Microsoft,XP,Vista" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" type="text/css" href="css/style.css" /> <script src="javascript/rollover.js" type="text/javascript"></script> <style type="text/css"> body,td,th { font-family: "trebuchet ms", arial, sans-serif; font-size: 0.8em; } a:link { color: #09F; } </style> </head> <body> <div id="main"> <div id="header"> <div id="logo"> <div id="logo_text"> <h1><a href="index.html">PureReaction<span class="logo_colour">UK</span></a></h1> <h2>All You Need To Know Is Here, Have A Look</h2> </div> </div> <div id="menubar"> <ul id="menu"> <li class="selected"><a href="index.html" title="Home" target="_self">Home</a></li> <li><a href="tutorials.html" title="Tutorials" target="_self">Tutorials</a></li> <li><a href="downloads.html" title="Downloads" target="_self">Downloads</a></li> <li><a href="register.html" title="Register" target="_self">Register</a></li> <li><a href="login.html" title="Log In" target="_self">Log In</a></li> </ul> </div> </div> <div id="content_header"></div> <div id="site_content"> <div class="sidebar"> <h3>Latest Updates</h3> <h4> Website Launched</h4> <h5>January 1st, 2010</h5> <p>Take a good look around and take your time there is alot of content to explore. <br /> <a href="index.html" title="Home" target="_self">Read more</a></p> <p></p> <h4>New Downloads</h4> <h5>January 1st, 2010</h5> <p>Check out the latest downloads by clicking the link below. Remember you must sign up / sign in.<br /> <a href="downloads.html" title="Downloads" target="_self">Read more</a></p> <h3>Useful Links</h3> <ul> <li><a href="http://www.minecraft.net/" title="MineCraft" target="_blank">MineCraft</a></li> <li><a href="http://modmyi.com/" title="ModMyi" target="_blank">ModMyi</a></li> <li><a href="http://www.ifans.com/" title="iFans" target="_blank">iFans</a> <ul> <li><a href="http://www.minecraftforum.net/" title="MineCraft Forum" target="_blank">MineCraft - Forum</a></li> </ul> </li> </ul> </div> <div id="content"> <h1>Log In Here</h1><div id="error"><p>There was an error processing your login, it appears that your username and/or password was incorrect. Please try again.</p> <p>Didn'."'".'t get your validation email? <a href="resend.php">Click here</a> to resend the validation email.</p> </div> </div> <div id="content_footer"></div> <div id="footer"> Copyright © All Rights Reserved By <a href="http://www.purereactionuk.com/" title="PureReactionUK" target="_self">www.PureReactionuk.com</a> - 2011</div> </div> </body> </html> '; } } else { ?> <html> <head> <title>PureReactionUK - Home</title> <link rel="shortcut icon" href="images/favicon.ico"> <meta name="description" content="Here you will find a tone of things that you will find very helpfull." /> <meta name="keywords" content="Pure,Reaction,UK,HD,BD,x,Brutal,Democracy,iPad,iPhone,iPod,Theme,WinetrBoard,iOS,Hack,Mod,Cydia,Surik,Apple,Game,Apps,USB,Fix,Restore,Design,SummerBoard,Playstation,3,Xbox,360,MineCraft,Server,Call,Of,Duty,Modern,Warfare,2,3,4,5,6,7,8,9,Black,Ops,Icons,Zombies,Jtag,SSH,iFile,HTML,Jailbreak,CSS,Javascript,Craig,Stewart,YouTube,Music,Downloads,Servers,Bukkit,MCAdmin,Tiny,Umbrella,GreenpoisOn,SpringBoard,Windows,Microsoft,XP,Vista" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" type="text/css" href="css/style.css" /> <script src="javascript/rollover.js" type="text/javascript"></script> <style type="text/css"> body,td,th { font-family: "trebuchet ms", arial, sans-serif; font-size: 0.8em; } a:link { color: #09F; } </style> </head> <body> <div id="main"> <div id="header"> <div id="logo"> <div id="logo_text"> <h1><a href="index.html">PureReaction<span class="logo_colour">UK</span></a></h1> <h2>All You Need To Know Is Here, Have A Look</h2> </div> </div> <div id="menubar"> <ul id="menu"> <li class="selected"><a href="index.html" title="Home" target="_self">Home</a></li> <li><a href="tutorials.html" title="Tutorials" target="_self">Tutorials</a></li> <li><a href="downloads.html" title="Downloads" target="_self">Downloads</a></li> <li><a href="register.php" title="Register" target="_self">Register</a></li> <li><a href="login.php" title="Log In" target="_self">Log In</a></li> </ul> </div> </div> <div id="content_header"></div> <div id="site_content"> <div class="sidebar"> <h3>Latest Updates</h3> <h4> Website Launched</h4> <h5>January 1st, 2010</h5> <p>Take a good look around and take your time there is alot of content to explore. <br /> <a href="index.html" title="Home" target="_self">Read more</a></p> <p></p> <h4>New Downloads</h4> <h5>January 1st, 2010</h5> <p>Check out the latest downloads by clicking the link below. Remember you must sign up / sign in.<br /> <a href="downloads.html" title="Downloads" target="_self">Read more</a></p> <h3>Useful Links</h3> <ul> <li><a href="http://www.minecraft.net/" title="MineCraft" target="_blank">MineCraft</a></li> <li><a href="http://modmyi.com/" title="ModMyi" target="_blank">ModMyi</a></li> <li><a href="http://www.ifans.com/" title="iFans" target="_blank">iFans</a> <ul> <li><a href="http://www.minecraftforum.net/" title="MineCraft Forum" target="_blank">MineCraft - Forum</a></li> </ul> </li> </ul> </div> <div id="content"> <h1>Log In Here</h1><form name="login_now" method="post" action="<?= $_SERVER['PHP_SELF'] ?>"> <table width="589" border="0"> <tr> <td width="116">Username</td> <td width="258"><label for="username"></label> <input type="text" name="username" id="username"></td> <td width="201"> </td> </tr> <tr> <td>Password</td> <td><label for="date"></label> <input type="password" name="password" id="password"> <label for="date"></label></td> <td> </td> </tr> <tr> <td> </td> <td><input type="submit" name="submit" id="submit" value="Submit"> <input type="reset" name="reset" id="reset" value="Reset"></td> <td> </td> </tr> </table> </form> <p>Didn't get your validation email? <a href="resend.php">Click here</a> to resend the validation email.</p> <p>Need an account? <a href="register.php">Click here</a> to register, it's completely free! </p> </p> </div> </div> <div id="content_footer"></div> <div id="footer"> Copyright © All Rights Reserved By <a href="http://www.purereactionuk.com/" title="PureReactionUK" target="_self">www.PureReactionuk.com</a> - 2011</div> </div> </body> </html> <? } mysql_close($l); ?>
<?php
global $con;
$name = $_GET['name'];
$email = $_GET['email'];
if((!empty($name)) && (!empty($email))){
$check = $con->prepare('SELECT email FROM subs WHERE email = ?');
$check->execute([$email]);
$row = $check->fetch();
if($email == $row['email']){
echo '<span>'.$email.' already in database, try another email!.</span>';
}else{
$subscribe = $con->prepare('INSERT INTO subs (name, email) VALUES (?, ?)');
$subscribe->execute([$name, $email]);
if($subscribe){
echo '<span>Hi '.$name.'</b>,subscription is now active.</span>';
}else{
echo '<span>Try again</span>';
}
}
}else{
echo '<span>please enter something</span>';
}
?>
the problem found at if($subscribe){ //the echo not showing the span element when data is inserted }
any help please? Edited November 14, 2019 by cyberRobotadded code indents I had this code working, then I became curious and tried something else and it failed. I then I went to use the original code that worked but forgot it. Whats wrong with this code? <?php $A=(echo '2); if ($_POST['number'] == '1') {include $A;} ?> Hiya peeps! I have built this code, can anyone see anything wrong with this because its not working at all all it does is refer back to its self; <?php session_start(); include 'system/template/template.php'; include 'system/mysql/mysql.php'; include 'system/properties/property.php'; $mysql = new mysql(); $mysql->connect(); $property = new property(); if($property->landlord_loggedin()) { header('Location: login.php'); } $_SESSION['N_P_ID'] = 1; if(isset($_SESSION['N_P_ID']) && !empty($_SESSION['N_P_ID'])) { if(isset($_POST['videotitle']) && !empty($_POST['videotitle']) && isset($_FILES['videofile']) && !empty($_FILES['videofile'])) { $upload = $bad . '<form id="Upload" action="upload_video.php" enctype="multipart/form-data" method="post"> <h3>Upload a video of your property</h3> <label>Video Title</label> <input type="text" name="videotitle"><br /> <input type="file" name="videofile"> <label>Submit</label> <input type="submit" name="submit" value="Upload"><br /> <a href="landlord_account.php">Skip</a> </form>'; $extensions = array('mpg', 'avi', 'mpeg'); define ("MAX_SIZE","10240"); function getExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; } if(isset($_FILES['imageone'])) { if(!isset($_POST['videotitle'])) { $bad = '<p class="bad">Please enter a video title.</p>'; $form = $upload; } $filename = stripslashes($_FILES['videofile']['name']); $extension = strtolower(getExtension($filename)); if(!in_array($extension, $extensions)) { $bad = '<p class="bad">Video is incorrect format, please make sure your video format is either mpg/mpeg or avi.</p>'; $form = $upload; } else { $size = filesize($_FILES['videofile']['tmp_name']); if($size > MAX_SIZE*1024) { $bad = '<p class="bad">Video too large.</p>'; $form = $upload; } $time = time(); $image_name = $time . '.' . $extension; $newname = "uploads/properties/landlord_files/videos/" . $image_name; if(move_uploaded_file($_FILES['videofile']['tmp_name'], $newname)) { if($property->add_video($time, 'flv', $_POST['videotitle'])) { $srcFile = 'uploads/properties/landlord_files/videos/' . $image_name; $destFile = 'uploads/properties/landlord_files/videos/' . $time . '.flv'; $ffmpegPath = "/usr/bin/ffmpeg"; $flvtool2Path = "/usr/bin/flvtool2"; $ffmpegObj = new ffmpeg_movie($srcFile); $srcWidth = makeMultipleTwo($ffmpegObj->getFrameWidth()); $srcHeight = makeMultipleTwo($ffmpegObj->getFrameHeight()); $srcFPS = $ffmpegObj->getFrameRate(); $srcAB = intval($ffmpegObj->getAudioBitRate()/1000); $srcAR = $ffmpegObj->getAudioSampleRate(); $img = $image_name; $ff_frame = $ffmpegObj->getFrame(1); if($ff_frame) { $gd_image = $ff_frame->toGDImage(); if($gd_image) { imagepng($gd_image, $img); imagedestroy($gd_image); $property->add_image($img, 'png', 'frame_shot'); } } exec($ffmpegPath . " -i " . $srcFile . " -ar " . $srcAR . " -ab " . $srcAB . " -f flv -s " . $srcWidth . "x" . $srcHeight . " " . $destFile . " | " . $flvtool2Path . " -U stdin " . $destFile); @unlink($newname); function makeMultipleTwo ($value) { $sType = gettype($value/2); if($sType == "integer") { return $value; } else { return ($value-1); } } $ref = 1; } else { @unlink($newname); $bad = '<p class="bad">Video upload failed.</p>'; $form = $upload; } } else { $bad = '<p class="bad">Video upload failed.</p>'; $form = $upload; } } } if($ref == 1) { header('Location: landlord_account.php?page=3'); } } else { $form = '<form id="Upload" action="upload_video.php" enctype="multipart/form-data" method="post"> <h3>Upload a video of your property</h3> <label>Video Title</label> <input type="text" name="videotitle"><br /> <input type="file" name="videofile"> <label>Submit</label> <input type="submit" name="submit" value="Upload"><br /> <a href="landlord_account.php">Skip</a> </form>'; } $template = new template(); $array = array('TITLE' => 'Upload A Video', 'CONTENT' => $form); $template->newTemplate($array, 'add_property'); } else { header('Location: landlord_account.php'); } ?> Many thanks, James. <?php for ($count = 0; $count < 10; $count++) { $randomNumber = rand(1,50); if ($randomNumber < 10) goto less; else echo "Number greater than 10: $randomNumber<br />"; } less: echo "Number less than 10: $randomNumber<br />"; ?> i checked this code again and again,but couldn't find any error. who can help me,thank you. Ok, so basically what I want is the code to check the DB to see if a passworded username is already taken, then display an error if someone tries to post with that same name, but gives a wrong password for that name. What the code below does, is just that....except, even when you enter the correct password, it displays the error that the name has been taken...how can I fix this so when you enter the right password, it allows you to post? <script src="http://code.jquery.com/jquery-latest.js" type="text/javascript" charset="utf-8"></script> <script language="javascript" type="text/javascript"> //<![CDATA[ $(document).ready(function(){ $("form#reply").submit(function() { var success = 0; var username = $('#user').attr('value'); $.ajax({ type: "GET", url: "checkusername.php", data: "username="+ username, success: function(r){ success = r; }, async:false }); if(success == 1) { alert("Username already taken."); return false; }else return true; }); }); //]]> </script> The checkusername.php code is: <?php require "database.php"; #check user on users table $user = fetch("SELECT COUNT(pid) FROM posts WHERE user = '".$_GET["username"]."'"); if(!$user || !isset($user)) echo '0'; if($user[0] > 0) echo '1'; else echo '0'; exit(); ?> Code: [Select] SELECT a.*, b.* FROM friendlist a INNER JOIN attend b ON (a.friendemail=b.email) WHERE a.email='$email' GROUP BY b.eventid ORDER BY count(*) DESC LIMIT 5 This query returns the right results in PHPmyadmin, but when it's executed in a php file through the chrome or firefox, it doesn't display anything. As in the entire webpage won't show up. In chrome, it says server error any ideas? Hi- the code below lets me upload a CSV file to my database if I have 1 field in my database and 1 column in my CSV. I need to add to my db "player_id" from the CVS file and "event_name" and "event_type" from the form... any ideas??? here's the code: Code: [Select] <?php $hoststring =""; $database = ""; $username = ""; $password = ""; $makeconnection = mysql_pconnect($hoststring, $username, $password); ?> <?php ob_start(); mysql_select_db($database, $makeconnection); $sql_get_players=" SELECT * FROM tabel ORDER BY player_id ASC"; // $get_players = mysql_query($sql_get_players, $makeconnection) or die(mysql_error()); $row_get_players = mysql_fetch_assoc($get_players); // $message = null; $allowed_extensions = array('csv'); $upload_path = '.'; //same directory if (!empty($_FILES['file'])) { if ($_FILES['file']['error'] == 0) { // check extension $file = explode(".", $_FILES['file']['name']); $extension = array_pop($file); if (in_array($extension, $allowed_extensions)) { if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) { if (($handle = fopen($upload_path.'/'.$_FILES['file']['name'], "r")) !== false) { $keys = array(); $out = array(); $insert = array(); $line = 1; while (($row = fgetcsv($handle, 0, ',', '"')) !== FALSE) { foreach($row as $key => $value) { if ($line === 1) { $keys[$key] = $value; } else { $out[$line][$key] = $value; } } $line++; } fclose($handle); if (!empty($keys) && !empty($out)) { $db = new PDO( 'mysql:host=host;dbname=db', 'user', 'pw'); $db->exec("SET CHARACTER SET utf8"); foreach($out as $key => $value) { $sql = "INSERT INTO `table` (`"; $sql .= implode("`player_id`", $keys); $sql .= "`) VALUES ("; $sql .= implode(", ", array_fill(0, count($keys), "?")); $sql .= ")"; $statement = $db->prepare($sql); $statement->execute($value); } $message = '<span>File has been uploaded successfully</span>'; } } } } else { $message = '<span>Only .csv file format is allowed</span>'; } } else { $message = '<span>There was a problem with your file</span>'; } } ob_flush();?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>CSV File Upload</title> </head> <body> <form class="form" action="" method="post" enctype="multipart/form-data"> <h3>Select Your File</h3> <p><?php echo $message; ?></p> <input type="file" name="file" id="file" size="30" /> <br/> <label>Event Name:</label><input name="event_name" type="text" value="" /> <br/> <label>Event Type:</label><input name="event_type" type="text" value="" /> <br/> <input type="submit" id="btn" class="button" value="Submit" /> </form> <br/> <h3>Results:</h3> <?php do { ?> <p><?php echo $row_get_players['player_id'];?></p> <?php } while ($row_get_players = mysql_fetch_assoc($get_players)); ?> </body> </html> Hi all, What I am trying to achieve is, I thought quite simple! Basically, a user signs up and chooses a package, form is submitted, details added to the database, email sent to customer, then I want to direct them to a paypal payment screen, this is where I am having issues! Is their any way in php to submit a form without user interaction? Here is my code for the form process page Code: [Select] <?php include('config.php'); require('scripts/class.phpmailer.php'); $package = $_POST['select1']; $name = $_POST['name']; $email = $_POST['email']; $password = md5($_POST['password']); $domain = $_POST['domain']; $a_username = $_POST['a_username']; $a_password = $_POST['a_password']; $query=mysql_query("INSERT INTO orders (package, name, email, password, domain, a_username, a_password) VALUES ('$package', '$name', '$email', '$password', '$domain', '$a_username', '$a_password')"); if (!$query) { echo "fail<br>"; echo mysql_error(); } else { $id = mysql_insert_id(); $query1=mysql_query("INSERT INTO customers (id, name, email, password) values ('$id', '$name', '$email', '$password')"); if (!$query1) { echo "fail<br>"; echo mysql_error(); } if($package=="Reseller Hosting") { //email stuff here - all works - just cutting it to keep the code short if(!$mail->Send()) { echo "Message could not be sent. <p>"; echo "Mailer Error: " . $mail->ErrorInfo; exit; } ?> <form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="hidden" name="cmd" value="_xclick-subscriptions"> <input type="hidden" name="business" value="subscription@jollyhosting.com"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="item_name" value="Jolly Hosting Reseller Packages"> <input type="hidden" name="no_shipping" value="1"> <!--1st month --> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="a3" value="3.00"> <input type="hidden" name="p3" value="1"> <input type="hidden" name="t3" value="M"> <input type="hidden" name="src" value="1"> <input type="hidden" name="sra" value="1"> </form>'; <?php } //last } //end ?> This topic has been moved to HTML Help. http://www.phpfreaks.com/forums/index.php?topic=358229.0 |
|||||||