|
PHP - Html Code In Linux...sorry If Wrong Section
im taking my ojt.
i posted on different linux forums but no one replied i have php code that displays reports. and i want to add html code for UI. but it does'nt appear. i cant install xampp or anything so is there another way to run my code? help pls. Similar TutorialsHi, first of all I am trying to do a section hidden from guests on a website. I have groups for each user (groups_admin, _mod, _member etc.)
I have it so ADMIN only view content at the moment, but not sure how to add GROUPS_MOD & GROUPS_MEMBER:
<?php echo $user_data['group_id'] == GROUPS_ADMIN ? 'content' : ''; ?>Secondly, where the content section is, I have HTML placed inside it which works fine, but it also has some PHP code. How would I get it so the php code works? This is what I have... <?php echo $user_data['group_id'] == GROUPS_ADMIN ? '<form method="post" action="<?php echo get_url(\'/products/\', $product[\'category_id\'], $product[\'product_id\'], $product[\'product_name\']); ?>?action=review">' : ''; ?>As you can see the form action line has a php url to generate the relevant link for a specific product. If anyone has any suggestions or can help in any way that would be much appreictaed. Cheers, Paul I don't even really know how to title it. I have this piece of code, i wrote. it works with wordpress api but honestly i don't think that matters much. what it does, is pick $ci number of categories, and then picks 2 posts from each category. it then assigns the image in/attached to that post to an array, to be used later. this all works fine, the problem is when it picks a post that doesn't have an image. right now, it can't tell that. writing in a bit to be able to tell whether there is an image or not should be easy. i'm thinking it can be as basic as file_exists or as complicated as parsing the post. the part i have the problem with - is how do i make it go back and pick another post/category when it comes up short? more than once? i want it to keep going back until it comes up with an image. i'd rather not expand the search any farther than necessary Code: [Select] <?php if ( false === ( $scroller = get_transient( $stransient ) ) ) { if (!is_array($scroller) || count($scroller)==0) { $args = array( 'type' => 'post', 'parent' => 18, 'exclude' => 63, 149, 278, 62 ); $companies = get_categories( $args ); while (count($companies) > $ci){unset($companies[array_rand($companies)]);} shuffle($companies);$truckco= array(); foreach ($companies as $company){ $argus = array('numberposts' => 2, 'orderby' => 'rand', 'post_type' => 'post', 'category' => $company->cat_ID ); $listings = get_posts($argus); foreach($listings as $tn=>$post) { $truckco[$company->slug]['truck_'. $tn]['image'] = get_the_image( array( 'image_scan' => true, 'format' => 'array', 'width' => '172', 'height' => '129' ) ); $truckco[$company->slug]['truck_'. $tn]['pid'] = $post->ID; } } ?> thank you Is anyone running PHP storm on Windows and debugging their PHP code on a remote Linux box? I ask because I am contemplating buying PHPStorm. What opinions I have read on this configuration say it doesn't work well. Hi, I have some queries that update some statistics in a table I have. I need these queries to run only after 15 seconds have passed however. This way if the user leaves before the 15 seconds, the queries won't run. I've tried using Sleep, however it seems to just stop all the code all together for the allotted time. There must be a way to do this. Commented in red is the code that doesn't produce anything. It is 3/4 of the way down the page.. Thanks for looking! Code: [Select] <?php error_reporting(E_ALL); ini_set("display_errors", 1); $host= ""; $db_name= ""; $db_user= ""; $db_password= ""; ob_start(); if(isset($_POST['newBidder'])) { $newBidder= isset($_POST['newBidder']) ? $_POST['newBidder'] : ''; $bidderId= $newBidder; mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM bidders WHERE biddersId='$bidderId'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==0){ // Add $biddersId and redirect to anypage mysql_Query("INSERT INTO bidders (biddersId) VALUES ('$bidderId')"); header("Location: index.php"); exit(); } } //////////////////////////////////// if(isset($_POST['deleteBidder'])) { $deleteBidder= isset($_POST['deleteBidder']) ? $_POST['deleteBidder'] : ''; mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server"); mysql_select_db("$db_name")or die("cannot select DB"); mysql_query("DELETE FROM bidders WHERE biddersId='$deleteBidder'"); header("Location: index.php"); exit(); } //////////////////////////////////// if (isset($_POST['itemDescription'], $_POST['itemPrice'], $_POST['winningBidder'], $_POST['itemQty'])) { $itemDescription= isset($_POST['itemDescription']) ? $_POST['itemDescription'] : ''; $itemPrice= isset($_POST['itemPrice']) ? $_POST['itemPrice'] : ''; $winningBidder= isset($_POST['winningBidder']) ? $_POST['winningBidder'] : ''; $itemQty= isset($_POST['itemQty']) ? $_POST['itemQty'] : ''; mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM bidders WHERE biddersId='$winningBidder'"; $result=mysql_query($sql); $count=mysql_num_rows($result); // If result matched, table row must be 1 row if($count==0){ echo "That Bidder Number is NOT logged in, "; echo "would you like to set this bidder as active?"; echo " Enter 1 for NO or 2 for YES"; echo "<form action= \"process.php\" method= \"POST\">"; echo "<input type =\"text\" name= \"logUser\"/>"; echo "<input type= \"submit\" value = \"Submit\"/>"; exit(); } } $logUser= isset($_POST['logUser']) ? $_POST['logUser'] : ''; if ($logUser= '1') { header("Location: inprogress.php"); exit(); } if ($logUser= '2'){ // Add $biddersId and redirect to anypage mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server"); mysql_select_db("$db_name")or die("cannot select DB"); mysql_Query("INSERT INTO bidders (biddersId) ////This won't add biddersid to database///////[ VALUES ('$winningBidder')"); mysql_query("INSERT INTO transactions /////This won't add details to the database either?///// VALUES('$itemDescription', '$itemPrice','$winningBidder', '$itemQty', '$totalPrice')") or die(mysql_error()); header("Location: inprogress.php"); exit(); } //////////////////////////////////////// echo "<font color= \"red\" face=\"calibri\" size=\"4\">That bidder is already logged, Please press your browsers back button and try again.</font>"; ob_end_flush(); ?> I have one database with 2 tables as follows bidders table ONLY has biddersId field; transactions has (in order) itemDescription, itemPrice, bidderId, itemQty, totalPrice everything else works, except updating the database with the above? Am I doing something wrong in MySql. I have all eroors on , but i get NONE when running the script? good day PHP-test on OpenSuse Linux 11.3 - ugliest errors (garbage code wherever i look) - i get seasick - this is too much to me. I am willing to throw the computer out of the windows... Well to begin with the beginning: i am brandnew to PHP on OpenSuse 11.3 i just start with PHP while running a first test - this here <?php echo date("Y/m/d") . "<br />"; echo date("Y.m.d") . "<br />"; echo date("Y-m-d") ?> i get ugly Effekts see the output suse-linux:/usr/perl # php learnmecha.php PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /usr/perl/learnmecha.php on line 2 2010/11/15<br />PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /usr/perl/learnmecha.php on line 3 2010.11.15<br />PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /usr/perl/learnmecha.php on line 4 suse-linux:/usr/perl # well - can i say that php runs - but not safe or what is this -- do you have another test - i want to test if the PHP runs well !? Okay, I have no idea how this works out but this is really getting on my nerves. Here is my logic for the following code. I manually register a user, It goes into the database and dispatches an email notification explaining that a user must activate their account and change their user name (OPTIONAL) and password. In the email, There is an automatically generated password with the username, And a link to activate the account. This leads to stage 1 of the activation process, In this stage the user is accepted, Registered as a verified user and then is sent to another page to change the details like login and password. As far as I know this page works except through trial and error I found that this little snippet of code is causing browsers to show an error 500 page, If I remove this the page works: <?php if($messages){ displayErrors($messages); } else { echo("<p align=\"center\" class=\"standard\">Your account has been activated.</p><p align=\"center\" class=\"standard\">You now need to change your password. If you like you can also change your username, Remember that you only have 3 days to do so and this change will be permanent.</p>"); } ?> and this is the displayErrors function: <?php function displayErrors($messages) { print("<p align=\"center\" class=\"standard\">"."<b>There were problems with the previous action:</b>\n<ul>\n"); foreach($messages as $msg){ print("<li>$msg</li>\n"); } print("</ul>\n"."</p>"); } ?> The displayErrors function is in a file called functions.php, Which is included in config.php, Which is included in every page including this one. The entire "Change password and login page thingie" is he <?php include("config.php"); global $link, $messages; require_once('recaptchalib.php'); if($_GET['error']){ $id=$_GET['id']; $messages[]="There is more than one or no accounts with the verification code you are using. <a href=\"mailto:rentals@nivso.co.uk?subject=Two or no accounts with activation ID of $id\">Click here to email us about this and have the problem sorted.</a>"; doIndex(); exit; } if(isset($_POST['submit'])){ if(!isset($_POST['activationid'])){ die("Doesn't exist -.- might as well quit this is *STUFF* -.-"); } $privatekey = "YOUR NOT HAVING THIS"; $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { $messages[]="The code you entered is incorrect. Please go back and try again!"; doIndex(); exit; // exit or the below lines will be processed. } else { //This is where the fun starts! $login=$_POST['login']; $passw=$_POST['password']; $passc=$_POST['passwordc']; $id2=$_POST['activationid']; $changinglogin=false; $get1=excDB("SELECT * FROM `users` WHERE `activeID`='$id2'"); if($get1[0]){ $get1=$get1[1]; } else { die($get1[2]); } $pro1=mysql_fetch_array($get1); if($pro1['login']!=$login){ $changinglogin=true; field_validator("Login", $login, "alphanumeric", 4, 15); } field_validator("Password", $passw, "string", 6, 20); if($passw!=$passc){ $messages[]="The passwords do not match, Please make sure that the passwords are the same!"; } if($messages){ doIndex(); exit; } $passcl=mysql_escape_string($passw); $passen=md5($passcl); if($changinglogin){ $wri1=excDB("UPDATE `users` SET `login`='$login', `password`='$passen', `passchange`='1', `loginchange`='1' WHERE `activeID`='$id2';"); if($wri1[0]){ $wri1=$wri1[1]; } else { die($wri1[2]); } header("Location: login.php?created"); } else { $wri1=excDB("UPDATE `users` SET `password`='$passen', `passchange`='1', `loginchange`='0' WHERE `activeID`='$id2';"); if($wri1[0]){ $wri1=$wri1[1]; } else { die($wri1[2]); } header("Location: login.php?created2"); } } } else { doIndex(); } function doIndex(){ ?> <!DOCTYPE html> <head> <title>Family Rental System! - Rent your DVDs here - Design by Alex, Coding by Gergy008</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link type="text/css" href="css/main.css" rel="stylesheet"> <style type="text/css"> <!-- body { background-color: #333333; } --> </style></head> <body style="text-align:center;"> <div class="first"> <div class="backgrounder1"></div> <div class="headerbar1"></div> <div class="headerbar2"></div> </div> <div align="center"> <table border="0" cellpadding="0" cellspacing="0" width="900"> <tr> <td><img src="images/spacer.gif" width="52" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="123" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="352" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="33" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="55" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="110" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="110" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="50" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="15" height="1" border="0" alt="" /></td> <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td> </tr> <tr> <td colspan="9" background="images/template.slice.1.png"> </td> <td><img src="images/spacer.gif" width="1" height="20" border="0" alt="" /></td> </tr> <tr> <td colspan="5" background="images/template.slice.2.png"> </td> <td colspan="2" rowspan="2" background="images/template.slice.3.png"><span class="login"><?php echo(loginHandler()); ?></span></td> <td colspan="2" rowspan="3" background="images/template.slice.4.png"> </td> <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td> </tr> <tr> <td rowspan="8" background="images/template.slice.5.png"> </td> <td colspan="2" background="images/template.slice.6.png"><form> <div align="center"> <input name="textfield" type="text" id="textfield" size="40" style="height:16px;"> <input type="submit" name="button" id="button" value="Search" style="height:20px;"> </div> </form></td> <td colspan="2" rowspan="2" background="images/template.slice.7.png"> </td> <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td> </tr> <tr> <td colspan="2" rowspan="3" background="images/template.slice.8.png"><p> </p> <p> </p></td> <td colspan="2" background="images/template.slice.9.png"> </td> <td><img src="images/spacer.gif" width="1" height="70" border="0" alt="" /></td> </tr> <tr> <td rowspan="2" background="images/template.slice.10.png"> </td> <td colspan="4" background="images/template.slice.11.png"> </td> <td rowspan="6" background="images/template.slice.12.png"> </td> <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td> </tr> <tr> <td colspan="4" background="images/template.slice.13.png"></td> <td><img src="images/spacer.gif" width="1" height="8" border="0" alt="" /></td> </tr> <tr> <td rowspan="4" background="images/template.slice.14.png"> </td> <td colspan="4" background="images/template.slice.15.png"> </td> <td colspan="2" rowspan="4" background="images/template.slice.16.png"> </td> <td><img src="images/spacer.gif" width="1" height="35" border="0" alt="" /></td> </tr> <tr> <td colspan="4" background="images/template.slice.17.png"> </td> <td><img src="images/spacer.gif" width="1" height="37" border="0" alt="" /></td> </tr> <tr> <td colspan="4" align="center" valign="top" background="images/template.slice.18.png" style="vertical-align:top;"><p class="standard"> </p> <table width="80%" border="0"> <tr> <td colspan="2"> <?php if($messages){ //displayErrors($messages); } else { //echo("<p align=\"center\" class=\"standard\">Your account has been activated.</p><p align=\"center\" class=\"standard\">You now need to change your password. If you like you can also change your username, Remember that you only have 3 days to do so and this change will be permanent.</p>"); ?></td> </tr> <form name="ChangeDetails" method="post" action="<?=$_SERVER['PHP_SELF']?>"> <input type="hidden" name="activationid" value="<?php if($_GET['id']){ $id=$_GET['id']; echo($id); } elseif($_POST['activationid']){ $id=$_POST['activationid']; echo($id); } else { die("No ID") } ?>" /> <tr> <td width="50%"><div align="right" class="standard">New Username: </div></td> <td width="50%"><input name="login" type="text" id="login" size="35" maxlength="30" /></td> </tr> <tr> <td><div align="right" class="standard">New Password:</div></td> <td><input name="password" type="password" id="password" size="35" maxlength="30" /></td> </tr> <tr> <td><div align="right" class="standard">Re-enter password:</div></td> <td><input name="passwordc" type="password" id="passwordc" size="35" maxlength="30" /></td> </tr> <tr> <td><div align="right" class="standard">Please enter the code: </div></td> <td> <?php require_once('recaptchalib.php'); $publickey = "6Le4fsESAAAAAKMOHb8aaiyDfGRJyr0y0EU7dXm-"; // you got this from the signup page echo recaptcha_get_html($publickey); ?> </td> </tr> <tr> <td> </td> <td><input type="submit" name="submit" id="submit" value="Change your details" /></td> </tr> </form> </table> </td> <td><img src="images/spacer.gif" width="1" height="450" border="0" alt="" /></td> </tr> <tr> <td colspan="4" background="images/template.slice.19.png"> </td> <td><img src="images/spacer.gif" width="1" height="50" border="0" alt="" /></td> </tr> <tr> <td colspan="9" background="images/template.slice.20.png"> </td> <td><img src="images/spacer.gif" width="1" height="40" border="0" alt="" /></td> </tr> </table> </div> </body> </html> <?php } ?> Thanks to all you kind people that take your time to read and help me with this problem. I'm sorry if it is a really simple problem I missed out that makes me look like a right idiot and wasted your time, but that's me I'm always missing stuff out like that, I do proof read though just sometimes not good enough. Thanks in advance! i dont understand what is wrong plz help me.
here is code
$name = "img/".rand(1,9999999).".png";
$myFile = $name;
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = $html;
fwrite($fh, $stringData);
fclose($fh);
$file=$name;
$fst=file_get_contents($file);
$im=imagecreatefromstring($fst);
imagefilter($im, IMG_FILTER_GRAYSCALE);
imagefilter($im, IMG_FILTER_NEGATE);
//Convert to Grey Scale
for($i=0;$i<123;$i++){
for($j=0;$j<50;$j++){
$px=imagecolorat($im,$i,$j);
if($px<0x303030){
imagesetpixel($im,$i,$j,0);
}else{
imagesetpixel($im,$i,$j,0xffffff);
}
}
}
$database = unserialize(@file_get_contents("db.txt"));
if($database === false) $database = array();
// modify the database if needed
if($_SERVER['REQUEST_METHOD'] == 'POST'){
if($_POST['submit'] == 'Add')
$database[$_POST['ident']] = substr($_POST['letter'], 0, 1);
if($_POST['submit'] == 'Del')
unset($database[$_POST['ident']]);
if($fh = @fopen('db111.txt', 'w+')){
fwrite($fh, serialize($database));
fclose($fh);
}
}else{
$newimage = true;
}
$width = 130;
$height = 40;
$captcha_gridstart =1;
$captcha_gridspace =2;
$letters = findletters($im, $width, $height, $captcha_gridstart, $captcha_gridspace);
$count = count($letters);
$cellw = ($count > 0) ? intval(100 / $count) : 0;
//dispeckle the image and GET co-ordinates of the characters of captcha image and return them.
function findletters($image, $width, $height, $gridstart, $gridspace){
$offsets = array(); $o = 0;
$atstartx = true;
for($x = 0; $x < $width; $x++){
$blankx = true;
for($y = 0; $y < $height; $y++){
if(imagecolorat($image, $x, $y) == 0){
$blankx = false;
break;
}
}
if(!$blankx && $atstartx){
$offsets[$o]['startx'] = $x;
$atstartx = !$atstartx;
}else if($blankx && !$atstartx){
$offsets[$o]['endx'] = $x;
$atstartx = !$atstartx;
$o++;
}
}
$count = $o;
for($o = 0; $o < $count; $o++){
for($y = 0; $y < $height; $y++){
$blanky = true;
for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
if(imagecolorat($image, $x, $y) == 0){
$blanky = false;
break;
}
}
if(!$blanky){
$offsets[$o]['starty'] = $y;
break;
}
}
for($y = $height-1; $y > $offsets[$o]['starty']; $y--){
$blanky = true;
for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
if(imagecolorat($image, $x, $y) == 0){
$blanky = false;
break;
}
}
if(!$blanky){
$offsets[$o]['endy'] = $y;
break;
}
}
}
for($o = 0; $o < $count; $o++){
$offsets[$o]['ident'] = "";
for($x = $offsets[$o]['startx'] + $gridstart; $x < $offsets[$o]['endx']; $x += $gridspace){
for($y = $offsets[$o]['starty'] + $gridstart; $y < $offsets[$o]['endy']; $y += $gridspace){
$offsets[$o]['ident'] .= ((imagecolorat($image, $x, $y) == 0) ? "0" : "1");
#echo $offsets[$o]['ident'].'<br>';
}
}
}
return $offsets;
}
$a="";
foreach($letters as $letter){
$asciiletter = $database[$letter['ident']];
if(!empty($asciiletter)) {
$a.=$asciiletter;
}
}
This topic has been moved to mod_rewrite. http://www.phpfreaks.com/forums/index.php?topic=318858.0 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(); ?>
<?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 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{} 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); ?> 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? 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. 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? 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 <?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. |
|||||||