PHP - Banging Head On Desk -- Need A Second Brain Please.

It's one of those days after a long weekend and a rainy morning.

Simply trying to get the correct message depending on the variable's value

if($a = 'one'){
echo "POOR";}
if($a = 'two'){
echo "GOOD";}
if($a = 'three'){
echo "VERY GOOD";}
if($a = 'four'){
echo "EXCELLENT";}

Not sure if I need to use ==, extra quotes, or ELSEIF for the best result.

 

Okay, I have a 3 column table layout on my forum,

I want users to beable to select where they want  1 of there profile sections to go under, (and display order) either, left middle or Right side.




See now I can code the javascript/etc ajax to make them update if selected to move to (any direction)

But I need help to do it server side, what kind of value/row in my db should i use? just 1 field and use arrays?
Also, let's say I want to move the "Calendar" to the middle or far right, and save that position, what kind of functions would i be working with (in php)

I can prob do it  if I use like 200 IF and ELSE conditions, but that would take way to long, any help?

hey peeps,
I am trying to get my site to display related youtube videos under the main video

here is what i have

$query=mysql_query("SELECT title,mp3ID,youtube_ID FROM songs ORDER BY RAND() LIMIT 10 ") or die("Error Occured");
$left = true;
while($row=mysql_fetch_array($query))
{
if ($left)
{
echo "<tr>";
}
echo "<td align='justify' width='100%' cellspacing='2' cellpadding='2' >";
echo "<td><img src='http://img.youtube.com/vi/".$row['youtube_ID']."/default.jpg'></td>";
echo "<td nowrap><a href='/music.php?id=".$row['mp3ID']."'>".$row['title']."</a></td>";
echo"</td>";
if (!$left)
{
echo"</tr>";
}
$left = !$left;
}
?>


this is basic info of how i am able to get youtube video titles and image....i want to use the same youtube.com video ID To get related videos


please help!!

Please are going to start hating me about this haha.

Hey guys i have been trying to do this for a few hours and my brain is hurting haha hope someone can help. Ok here is what i am trying to do. I have been making a website that allows users to make friends below is my friends table::

NAME: member_friends
id
friend_id << Person who has been sent the friend request
my_id << Person who sent the friend request
friend_since << when did they become friends
is_friend << is set to 0 then friend request pending

and this is the member_topics
message_id
member_id << this stores the id of the member from the members table
message_contents << stores their message
message_date
message_reported << if set to 1 the message has been reported

Ok basically i want the messages to be displayed on the members home page if they are friends, so if my name is JamesDean and i befriended a person called Harry if i post a message i want harry to see this and any other friends i may have. Same goes for their messages.

Sorry if im confusing you stay with me.

Ok here is what i am trying to do (did i mention im fairly new to php so please if im doing something wrong dont hurt me (: )

$query = mysql_query("SELECT * FROM member_friends");
while($row = mysql_fetch_array($query)){
       $friend_id = $row['friend_id']; // Ok this is where i want the while loop to loop through all of my friends
       // Ok set up the new filter im gunna get lost here now
      $sql = mysql_query("SELECT a.*,b.* FROM member_topics as a, member_friends as b WHERE (a.member_id = b.my_id OR a.member_id = b.my_id) 
AND ((b.friend_id = '$friend_id') AND b.my_id = '$my_id') ORDER BY a.message_id DESC");
     // $my_id is a variable created from session so thats ok and the $friend_id i want that to change fromt he first loop so the statement changes for all of my friends.
     // Sorry for the query above i have tried that many i dont even know my gender anymore 
    // So while loop in a while loop i think
     while($row = mysql_fetch_array($sql)){
$message_id = $row['message_id'];
$member_id = $row['member_id'];
$message_contents = $row['message_contents'];
$message_date = $row['message_date'];
$message_type = $row['message_type'];
$message_reported = $row['message_reported];


}
}

something like this hope someone can point me in the right direction before my brain fails thanks in advanced!!!!!!!

Help.  I used the great Simple SQL search tutorial provided by this site, but when I tried to customize it for my site, it keeps falling apart.  I am a newbie, but any disgust at my idiocy is fine as long as I find a ball of string to lead me out of the labyrinth.

Here's the code (modified from the tutorial) sans the login information:

$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());


mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {olsendai_ssn}. Error: " . mysql_error());

// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted.
// Since this is a search we will use $_GET
if (isset($_GET['search']))
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
  if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }

   
  // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT name, ssn FROM simple_search WHERE ";
     
      // grab the search types.
      $types = array();
      $types[] = isset($_GET['name'])?"`name` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['ssn'])?"`ssn` LIKE '%{$searchTermDB}%'":'';
 
   
      $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
     
      if (count($types) < 1)
         $types[] = "`name` LIKE '%{$searchTermDB}%'"; // use the name as a default search if none are checked
     
          $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `ssn`"; // order by ssn.

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
     
if ($num_rows < 1 ) {
          echo '<b>No Titles Found.</b><br><br><br>';
} 
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['ssn']}<br /><br />{$row['name']}<br /><br />";
            $i++;
         }
      }
   }
 

function removeEmpty($var) {
   return (!empty($var));
}
?>
<html>
   <title>My Simple Search Form</title>
   <style type="text/css">
      #error {
         color: red;
      }
   </style>
   <name>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
         Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />
         Search In:<br />
         name: <input type="checkbox" name="name" value="on" <?php echo isset($_GET['name'])?"checked":''; ?> /> |
         ssn: <input type="checkbox" name="ssn" value="on" <?php echo isset($_GET['ssn'])?"checked":''; ?> /> |
         /><br />
                 Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />
         <input type="submit" name="submit" value="Search!" />
      </form>
      <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>
   </name>
</html>

When I try this, it gives me this message:

Parse error: syntax error, unexpected '}' in /home/olsendai/public_html/sqlfour.php on line 65.

Help.  Please!

It seems simple, but when I remove the unexpected '}', it comes back with this error - before I have even used the search feature

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/olsendai/public_html/sqlfour.php on line 60
The following had errors:
Search terms must be longer than 3 characters.

I have an array

$INFO = array(
  'joebob' => 'password',
  'fred' => 'password',
  'tom'=> 'password'
);

how can i just do a simple check to see if a name and password match?

something like  if (in_array(can'tthink));

thanks

Ok this should be straight forward but my tired brain cannot work this out. I'm creating a simple contact form and for some reason the validation isn't working. It wont go past the check fields are filled in validation. Can anyone spot what I'm doing wrong?

Code: [Select]
                <form method="get">
                  <h1 class='contact_form_h'>Contact Us</h1>
                  <div id="login_response"></div>
                  <input type='text' name='name' id='name' class='contact_form_input' value='Name' onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" />
                  <input type='text' name='email' id='email' class='contact_form_input' value='Email' onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" />
                  <textarea name='enquiry' id='enquiry' class='contact_form_textarea' rows='10' cols='10' onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;">Enquiry</textarea>
                    <input type='submit' name='contact' id='contact' class='contact_form_submit' value='Contact Us' />
              </form>
Code: [Select]
<?php
//Check if form is submitted
if(isset($_GET['contact'])) {

//Require check email function
require "check_email.php";

//Variables
$err_name=stripslashes($_GET['name']);
$err_email=stripslashes($_GET['email']);
$err_enquiry=stripslashes($_GET['enquiry']); 

$to="xxx@xxxx.com";
$subject="Website Contact Form";
$from = stripslashes($_GET['name'])."<".stripslashes($_GET['email']).">";
$message = $err_enquiry;
$headers = "From: $from\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: multipart/mixed;\r\n" .
" boundary=\"{$mime_boundary}\"";

//Check all form fields are filled in

if ($_GET["name"]!='' OR $_GET["name"]!='Name' OR $_GET["email"]!='' OR $_GET["email"]!='Email' )  {

if (isValidEmail($_GET['email'])){

//Send Mail
if (@mail($to, $subject, $message, $headers)) {
echo "3 - sent";
}
else{
echo "2 - not";
}

}
else {
echo "1 - not valid";
}

}
else {
echo"0 - Fill in";
}


}
?>


Below is the check email script.
Code: [Select]
<?php
   // This function tests whether the email address is valid  
   function isValidEmail($email){
      $pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";
     
      if (eregi($pattern, $email)){
         return true;
      }
      else {
         return false;
      }   
   }
?> 

Okay guys.

My brain has completely froze and I can't figure out how to do this.

I have one date, that is somewhat static it doesn't change regularly but it changes. Anyway let's say this timestamp is:

2011-07-12 10:30:00

and the current timestamp is

2011-07-13 10:30:00

That's exactly a day difference, which will produce 86400 seconds.

How would I write this in PHP?

Hi all,

for some reason I cant see this blantantly obvious query.

I have 3 rows in my database, all with an id of 1, their is a column called price which contains three different float values, how the hell do I write a query in php for this?!
Code: [Select]
$q = mysql_query("SELECT price FROM mytable WHERE id=1")
????Thanks!

Ok, so I've read a few tutorials of OOP and have a basic understanding of how it works but where is it generally handy? I have a basic site created with PHP that consists of a form that submits data to MySQL and then lists the data from the MySQL database on another page. Kind of like a little online planner. I don't see how me converting my site to use OOP would help here.

Maybe it's best for more complex situations such as a shopping cart where data needs to be shared across multiple pages? 

how you doing guys. I'm having a little bit of a problem right now, with this thing call view-profile.php, i hope you guys know what it is, I'm new to php, so please try to help.
it says the same thing everytime.

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\siteS\viewprofile.php on line 26

There was a problem accessing your profile


<h3>Mismatch - View Profile</h3>

<?php
  require_once('appvars.php');
  require_once('connectvars.php');

  // Connect to the database
  $dbc = mysqli_connect('localhost', '***', '*****', '*****');

  // Grab the profile data from the database
  if (!isset($_GET['user_id'])) {
    $query = "SELECT username, first_name, last_name, gender, birthdate, city, state, picture FROM mismatch_user WHERE user_id = '$user_id'";
  }
  else {
    $query = "SELECT username, first_name, last_name, gender, birthdate, city, state, picture FROM mismatch_user WHERE user_id = '" . $_GET['user_id'] . "'";
  }
  $data = mysqli_query($dbc, $query);
line26-----------> if (mysqli_num_rows($data) == 1) {
    // The user row was found so display the user data
    $row = mysqli_fetch_array($data);
    echo '<table>';
    if (!empty($row['username'])) {
      echo '<tr><td class="label">Username:</td><td>' . $row['username'] . '</td></tr>';
    }
    if (!empty($row['first_name'])) {
      echo '<tr><td class="label">First name:</td><td>' . $row['first_name'] . '</td></tr>';
    }
    if (!empty($row['last_name'])) {
      echo '<tr><td class="label">Last name:</td><td>' . $row['last_name'] . '</td></tr>';
    }
    if (!empty($row['gender'])) {
      echo '<tr><td class="label">Gender:</td><td>';
      if ($row['gender'] == 'M') {
        echo 'Male';
      }
      else if ($row['gender'] == 'F') {
        echo 'Female';
      }
      else {
        echo '?';
      }
      echo '</td></tr>';
    }
    if (!empty($row['birthdate'])) {
      if (!isset($_GET['user_id']) || ($user_id == $_GET['user_id'])) {
        // Show the user their own birthdate
        echo '<tr><td class="label">Birthdate:</td><td>' . $row['birthdate'] . '</td></tr>';
      }
      else {
        // Show only the birth year for everyone else
        list($year, $month, $day) = explode('-', $row['birthdate']);
        echo '<tr><td class="label">Year born:</td><td>' . $year . '</td></tr>';
      }
    }
    if (!empty($row['city']) || !empty($row['state'])) {
      echo '<tr><td class="label">Location:</td><td>' . $row['city'] . ', ' . $row['state'] . '</td></tr>';
    }
    if (!empty($row['picture'])) {
      echo '<tr><td class="label">Pictu </td><td><img src="' . MM_UPLOADPATH . $row['picture'] .
        '" alt="Profile Picture" /></td></tr>';
    }
    echo '</table>';
    if (!isset($_GET['user_id']) || ($user_id == $_GET['user_id'])) {
      echo '<p>Would you like to <a href="editprofile.php">edit your profile</a>?</p>';
    }
  } // End of check for a single row of user results
  else {
    echo '<p class="error">There was a problem accessing your profile.</p>';
  }

  mysqli_close($dbc);
?>

hey guys how you doing? I've been having a little bit of problem with php, in fact I'm frustrated, so please if you can help me in any tight of way, please do,
I've been trying to make this php code work, but it won't, i don't know what I'm doing wrong, I'm new to php and mysql

every time i try it, it saids one thing

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\siteN\approvescore.php:3) in C:\xampp\htdocs\siteN\authorize.php on line 17


<?php
  require_once ('authorize.php');
?>

<!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" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>Guitar Wars - Approve a High Score</title>
  <link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<h2>Guitar Wars - Approve a High Score</h2>

<?php
  require_once('appvars.php');
  require_once('connectvars.php');

  if (isset($_GET['id']) && isset($_GET['date']) && isset($_GET['name']) && isset($_GET['score'])) {
    // Grab the score data from the GET
    $id = $_GET['id'];
    $date = $_GET['date'];
    $name = $_GET['name'];
    $score = $_GET['score'];
    $screenshot = $_GET['screenshot'];
  }
  else if (isset($_POST['id']) && isset($_POST['name']) && isset($_POST['score'])) {
    // Grab the score data from the POST
    $id = $_POST['id'];
    $name = $_POST['name'];
    $score = $_POST['score'];
  }
  else {
    echo '<p class="error">Sorry, no high score was specified for approval.</p>';
  }

  if (isset($_POST['submit'])) {
    if ($_POST['confirm'] == 'Yes') {
      // Connect to the database
      $dbc = mysqli_connect('localhost', '999', 'adsd', 'guitarwars3');

      // Approve the score by setting the approved column in the database
      $query = "UPDATE gtwars1 SET approved = 1 WHERE id = $id";
      mysqli_query($dbc, $query);
      mysqli_close($dbc);

      // Confirm success with the user
      echo '<p>The high score of ' . $score . ' for ' . $name . ' was successfully approved.';
    }
    else {
      echo '<p class="error">Sorry, there was a problem approving the high score.</p>';
    }
  }
  else if (isset($id) && isset($name) && isset($date) && isset($score)) {
    echo '<p>Are you sure you want to approve the following high score?</p>';
    echo '<p><strong>Name: </strong>' . $name . '<br /><strong>Date: </strong>' . $date .
      '<br /><strong>Sco </strong>' . $score . '</p>';
    echo '<form method="post" action="approvescore.php">';
    echo '<img src="' . GW_UPLOADPATH . $screenshot . '" width="160" alt="Score image" /><br />';
    echo '<input type="radio" name="confirm" value="Yes" /> Yes ';
    echo '<input type="radio" name="confirm" value="No" checked="checked" /> No <br />';
    echo '<input type="submit" value="Submit" name="submit" />';
    echo '<input type="hidden" name="id" value="' . $id . '" />';
    echo '<input type="hidden" name="name" value="' . $name . '" />';
    echo '<input type="hidden" name="score" value="' . $score . '" />';
    echo '</form>';
  }

  echo '<p><a href="admin.php">&lt;&lt; Back to admin page</a></p>';
?>

first i have a standard html page. Just a form that submits data to upload.php

http://pixel.imgboard.co.uk

here is upload.php - note i know i have some weird echo's but ive been trying for 2 hours to get upload.php to display something... but nothing happens.. i cant even get it to output html. It just goes to upload.php and has a blank page. When i view source there is nothing there. Its literally a blank page. I can't work it out.  someone please help. I'm going to crack up.


<?php
ini_set("display_errors", "1");
error_reporting(E_ALL);
session_start();
include 'http://www.imgboard.co.uk/includes/functions.php';



$start =  "
<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">  
<html>
<head>
<link rel=\"stylesheet\" type=\"text/css\" href=\"http://www.imgboard.co.uk/style/pixel.css\" />
<title> Pixel - Image Hosting Beta</title>

</head>

<body>
    <div id =\"wrapper\">
    <div class = 'titlebar'>
    <div class = 'titlebarlinkbox'>
    <a href = 'http://www.imgboard.co.uk'>Forum</a>
    <a href = 'http://www.imgboard.co.uk/Wiki.php'>Wikis</a>
    <a href = 'http://www.imgboard.co.uk/bulletins/0'>Bulletins</a>
    <a href = 'http://www.imgboard.co.uk/faq/0'>Faq's</a>
    </div>
    </div>
    <div class = \"logo\"></div>


";


$end =  "
<div class = 'footerLinks'>
     
     Pixel @ 2010 - 2015 ! <br />
    <a href = 'http://www.imgboard.co.uk'>Forum</a> | 
    <a href = 'http://www.imgboard.co.uk/Wiki.php'>Wikis</a> | 
    <a href = 'http://www.imgboard.co.uk/bulletins/0'>Bulletins</a> | 
    <a href = 'http://www.imgboard.co.uk/faq/0'>Faq's</a> | 
    <a href = 'http://www.imgboard.co.uk/pixel/report.php'>Report Image</a>

</div>
<div class = 'TnC'>Pixel is a Trademark of imgboard.co.uk. Please ensure all content uploaded is decent. No Taboo, cp, gore allowed. Porn / memes / misc themes all welcome. Any offensive content will be removed and deleted. Any misuse of the service and result in banning and in seviere cases prosecution.</div>

    </div>
</body>
</html>


";



if(isset($_GET['uploadfile'])){

echo $start;
echo $end;


$validExtensions = array("png", "gif", "jpeg", "jpg", "bmp");
                                       $ext = end(explode(".",$_FILES["image"]["name"]));
                                       $ext2= strtolower($ext);


if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/png")
|| ($_FILES["file"]["type"] == "image/bmp")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 10000000))
&& in_array($ext2,$validExtensions))
   {
      

//create a unique name. 
$newname = date(dmYhis);
$newname .= rand(1111,9999);
//preg replace non alpha numeric characters

$fname = $_FILES['file']['name'];
$newname = $newname . "." .$ext2;

$location = "http://www.imgboard.co.uk/images/".$newname;
      
//copy the file. 

if(move_uploaded_file($_FILES['file']['tmp_name'],$location)){

//file uploaded create display Page. 
$t = $_POST['tags'];
add_uploaded_image($location,$t);
file_upload_display_page($location);

}

else{

die("Error Occured Moving File");
}
 




 }
 
 else{
 
 die("wrong mime type");
 
 }






}



function add_uploaded_image($link, $tags){

$c = protect($_COOKIE['supercookie']);
$ip = $_SERVER['REMOTE_ADDR'];
$t = protect($tags);

mysql_query("INSERT INTO pixel (filename,tags,date,ip,cookie) VALUES ('$link','$t',NOW(),'$ip','$c')") or die(mysql_error());

}



function file_upload_display_page($location){

echo "

   
    <table class = 'uploadTable' cellspacing = '0'>
    
    
    
    
    <tr>
    <td class = \"label\">
    Image Uploaded: </td><td><img src = '$location' HEIGHT = '150'/>
    </td>
    </tr>
    
    <tr>
    <td class = \"label\">
    Direct Link: </td><td><input type = 'text' name = 'file' id = 'file'  value = '$location'/>
    </td>
    </tr>
    <tr>
    <td class = \"label\">
    Html Code </td><td><input type = 'text' name = 'tags'  value = \"<img src = '$location' ALT = 'Hosted On http://Pixel.imgboard.co.uk'/>\"/>
    </td>
    </tr>
    <tr>
    <td>
     <td class = \"label\">
    BB Code: </td><td><input type = 'text' name = 'file' id = 'file'  value = '[img]http://$location[/img]'/>
    </td>
    </td>
    </tr>
      
    
    </table>
    
    
    


";






}

Hi All,

I am trying to use headers at the end of functions to put the user where they need to be.

header("location: register.php?user_may_exist");

I understand how they work and their qwuirks.

My issue is, in my head file, i am outputting which causes issues for the headers which come after.

I have the following in head.php

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>
		<?php 
			if(isset($currentPageTitle)){
				echo $currentPageTitle;
			}else{
				echo 'Cricket Club';
			}; 
		?>
	</title>
	<?php 
			if(isset($currentPageMeta)){
				echo "<meta name='description' content='$currentPageMeta'>";
			}else{
				echo "<meta name='description' content='All the latest from CC'>";
			}; 
		?>
	
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

Is there a better way for me to achieve this?

Are there any problems with calling an include file from within the <header> tags?

The reason I'm asking is that I'm trying to load a speficied Style sheet based on a user's location and so I'm running a short script to determine which Style sheet needs to be displayed ... and that script is called from within the header tag.

I haven't heard of any problems with doing this in the past, but the script seems to be generating an extra set of <HTML> tags in my source code and I can't figure out why this might be!

Thanks,