PHP - If Statements Inside Array Replacement

I'm sure you can do this in PHP, but for some reason when I view news.php - It automatically tells me I liked the post, when I haven't even clicked like yet!


while($fetch = mysql_fetch_assoc($query))

{

if($_GET['like'] == $fetch['id'])

{

$like = mysql_real_escape_string($_GET['like']);

$has_liked = mysql_query("SELECT * FROM likes WHERE id = '$like' AND username = '". $_SESSION['user'] ."'");

if(mysql_num_rows($has_liked) > 0)

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>

<h3 class='date'>". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['content'])) ."</p>

</div>

<p class='meta'><b>You've already liked this announcement.</b></p>

</div>

";

}

else

{

mysql_query("UPDATE news SET likes = likes + 1 WHERE id = '". $_GET['id'] ."'");

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>

<h3 class='date'>". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['content'])) ."</p>

</div>

<p class='meta'><b>You liked this announcement.</b></p>

</div>

";

}

}

else

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font>

<h3 class='date'>". $fetch['date'] ."</h3>

<div class='entry'>

<p>". nl2br(stripslashes($fetch['content'])) ."</p>

</div>

<p class='meta'><a href='news.php?like=". $fetch['id'] ."'>Like</a></p>

</div>

";

}

}

I am trying to create a daily event listing.

The list will have Day & Date as the heading. Then it will list the events ORDERED BY the time.

First thing I'd like to do is skip or not show the days that do not have an event.
Ex.
Monday, January 23, 2012
7am event
8am event
6pm event

since Tuesday has no events, I'd like tuesday to not be in the list, but if the next tuesday has an event It'll need be visible.
Tuesday, January 24, 2012
(No events)

Wednesday, January 25, 2012
9am event
12 pm event
8pm event

The 2nd thing I'd like to do is If a particular day and time has more than one event, I'd like the time to show once and then list the events.
ex.
Monday, January 23, 2012
7am event
        event
        event
8am event
6pm event


Here's the code: since the listing is for a range of 7 days I've only included 3 days worth of code. I've include the mysql_statements for pulling the information as well as the php code to show how it's being rendered and placed.  HTML excluded.

Code: [Select]
<?php
//TODAY
$today2 = date('l, F j, Y');//php to format date

$today_rehearsals = mysql_query(" SELECT Id, date, time, title, campus, room, ministry, category FROM events
     LEFT JOIN dates on events.dateId=dates.dateId
     LEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomIdLEFT JOIN ministries on events.ministryId=ministries.ministryId
     LEFT JOIN category on events.categoryId=category.categoryIdWHERE ministry='music' AND date='$today' OR category='music' AND date='$today'            
     ORDER By date, time")

//////DAY  ONE
$day1= mktime(0,0,0, date("m"), date("d")+1, date("Y")); //php to get current date and add 1 day
$day_1 = date("l, F j, Y", $day1); //php to format date

$day1_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+1 OR category='music' AND date=CURDATE()+1 ORDER BY time" ) or die(mysql_error());

/////DAY 2
$day2= mktime(0,0,0, date("m"), date("d")+2, date("Y")); //php to get current date and add 2 days
$day_2 = date("l, F j, Y", $day2); //php to format date

$day2_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+2 OR category='music' AND date=CURDATE()+2 ORDER By time")or die(mysql_error()); 



////TODAY
echo "$today2"; //renders Today's date 
    
     while($row = mysql_fetch_array( $today_rehearsals )){ 
          $time=date_create($row['time']);//grab time for db          
          $for_time=date_format($time, 'g:i a');//format time for viewing on page   

           echo "$for_time";           
           echo $row['title'];           
           echo $row['campus'] . " " . $row['room'];    
     }


////day1
echo "$day_1"; //renders day_1's (tomorrow's) date

     while($row = mysql_fetch_array( $day1_rehearsal )){ 
          $time=date_create($row['time']);//grab time for db         
          $for_time=date_format($time, 'g:i a');//format time for viewing on page
                          
          echo "$for_time";          
          echo $row['title'];          
          echo $row['campus'] . " " . $row['room'];
          }

////day2
echo "$day_2"; //renders day_2's (day after tommorrow) date

     while($row = mysql_fetch_array( $day2_rehearsal )){                      
         $time=date_create($row['time']);//grab time for db
         $for_time=date_format($time, 'g:i a');//format time for viewing on page                                     

          echo "$for_time"; 
          echo $row['title'];
          echo $row['campus'] . " " . $row['room'];
          }

MOD EDIT: code tags fixed . . .

Hi Everyone,

I have built a website utilizing a PHP abstract Webpage class to create the pages. When creating another class that inherits from Webpage class I rewrite abstract functions, etc. where needed. When instantiating an object of the extended classes I pass the constructor the $page_title, $css_file, $meta_data, $keywords, etc., etc.. I am able to pass html markup in a string variable to a class level "Setter" function  to populate a "main area" of the website and all works perfectly.

However, I have a contact form which I send the "Submit Message" button click to a PHP function that takes care of making sure the form fields are not empty, then sends email and returns a success message back to the calling page, if they are empty, the function returns what fields are empty(required). If the page includes empty and populated fields I want to put the populated fields into session variables so that I may populate the fields when the user is taken back to the page and display to the user the required fields that were empty(this functionality is already within the function).

This brings me to my question(see code below for reference):

Seeing that I am populating a variable with a string it seems I cannot use an if statement, echo or the like, my IDE gives me errors. How may I insert an if statement where needed to populate the empty form fields?
Code: [Select]
include('../php_functions/functions.php');//for the chechData() function

$error_message = NULL;

if(isset($_POST['submit']))
{
    $error_message = checkData($_POST, 'Renovation & Consulting');
}
$main_content =
'<form method="post" action="">
    <fieldset id="contactform">
        <legend>Renovations &amp; Consultations</legend>'.

        [color=red]//placing a variable here works fine![/color]
            $error_message
       
            .'<div class="row_div">
                <div class="label_div">
                    <label>First Name:</label>
                </div>
                <div class="input_div">
                    <input name="First Name" type="text" maxlength="50" size="50" value="'.[color=red]if(session variable not empty) echo it here;.'"[/color] />
                </div>
            </div>
            <div class="row_div">
                <input name="submit" type="submit" value="Send Message" />
            </div>
      </fieldset>
</form>';

Thanks for any and all responses.

Chuck

I've searched all over for the past few days trying to figure out what I'm doing wrong. Basically what I'm trying to do is create a prepared statement inside my User class. I can connect to the database, but my query does not execute as expected.

Here's the code for my User class

Code: [Select]
<?php include '../includes/Constants.php'; ?>
<?php

/**
 * Description of User
 *
 * @author Eric Evas
 */
class User {

    var $id,
    $fname,
    $lname,
    $email,
    $username,
    $password,
    $conf_pass;
    protected static $db_conn;

    //declare variables
    public function __construct() {
        $host = DB_HOST;
        $user = DB_USER;
        $pass = DB_PASS;
        $db = DB_NAME;

        //Connect to database
        $this->db_conn = new mysqli($host, $user, $pass, $db);

        //Check database connection
        if ($this->db_conn->connect_error) {
            echo 'Connection Fail: ' . mysqli_connect_error();
        } else {
            echo 'Connected';
        }
    }

    function regUser($fname, $lname, $email, $username, $password, $conf_pass) {


        if ($stmt = $this->db_conn->prepare("INSERT INTO USERS (user_fname,user_lname,
            user_email,username,user_pass) VALUES (?,?,?,?,?)")) {
            $stmt->bind_param('sssss', $this->fname, $this->lname, $this->email, $this->username, $this->password);

            $stmt->execute();

            $stmt->store_result();

            $stmt->close();
        }
    }

}

?>


And here's the file that I created to instantiate an instance of the user class.


Code: [Select]
<?php include_once 'User.php'; ?>
<?php

//Creating new User Object
$newUser = new User();

$newUser->fname = $_POST['fname'];
$newUser->lname = $_POST['lname'];
$newUser->email = $_POST['email'];
$newUser->username = $_POST['username'];
$newUser->password = $_POST['password'];
$newUser->conf_pass = $_POST['conf_pass'];


$newUser->regUser($newUser->fname, $newUser->lname, $newUser->email,
        $newUser->username, $newUser->password, $newUser->conf_pass);
?>



And lastly heres the form that I want to get info from the user to insert into the database

Code: [Select]
<html>
    <head>
        <title></title>
        <link href="stylesheets/styles.css" rel="stylesheet" type="text/css"/>
    </head>


    <body>
        <form action = "Resources/testClass.php" method="post" enctype="multipart/form-data">
            <label>First Name: </label>
            <input type="text" name="fname" id="fname" size="25" maxlength="25"/>
            <label>Last Name: </label>
            <input type="text" name="lname" id="lname" size="25" maxlength="25"/>
            <label>Email: </label>
            <input type="text" name="email" id="email" size="25" maxlength="40"/>
            <label>Username: </label>
            <input type="text" name="username" id="username" size="25" maxlength="32"/>
            <label>Password: </label>
            <input type="password" name="password" id="password" size="25" maxlength="32"/>
            <label>Re-enter Password: </label>
            <input type="password" name="conf_pass" id="conf_pass" size="25" maxlength="32"/>
            <br /><br />
            <input type="submit" name="submit" id="submit" value="Register"/>
            <input type="reset" name="reset" id="reset" value="Reset"/>
        </form>

    </body>
</html>

The Script:

$desired_width = 110;

if (isset($_POST['submit'])) {
    $j = 0; //Variable for indexing uploaded image

    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array
        $target_path = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/uploads/"; //Declaring Path for uploaded images

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable

        $new_image_name = md5(uniqid()) . "." . $ext[count($ext) - 1];
		$target_path = $target_path . $new_image_name;//set the target path with a new name of image
        $j = $j + 1;//increment the number of uploaded images according to the files in array       
      
	  if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded.
                && in_array($file_extension, $validextensions)) {
            if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder
                echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>';

                $tqs = "INSERT INTO images (`original_image_name`, `image_file`, `date_created`) VALUES ('" . $_FILES['file']['name'][$i] . "', '" . $new_image_name  . "', now())";
                $tqr = mysqli_query($dbc, $tqs);

                // Select the ID numbers of the last inserted images and store them inside an array.
                // Use the implode() function on the array to have a string of the ID numbers separated by commas.
                // Store the ID numbers in the "image_file_id" column of the "thread" table.

                $tqs = "SELECT `id` FROM `images` WHERE `image_file` IN ('$new_image_name')";
                $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

                $fetch_array = array();
                $row = mysqli_fetch_array($tqr);
                $fetch_array[] = $row['id'];


                /*
                 * This prints e.g.:
                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )
                 */
                print_r($fetch_array);

                // Goes over to create the thumbnail images.
                $src = $target_path;
                $dest = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/thumbs/" . $new_image_name;

                make_thumb($src, $dest, $desired_width);


            } else {//if file was not moved.
                echo $j. ').<span id="error">please try again!.</span><br/><br/>';
            }
        } else {//if file size and file type was incorrect.
            echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>';
        }
    }
}

Hey, sorry that I am posting this darn image upload script again, I have this almost finished and I am not looking to ask more questions when it comes to this script specifically.   With the script above I have that part where the script should store the ID numbers (the auto_increment column of the table) of the image files inside of one array and then the "implode()" function would get used on the array and then the ID numbers would get inserted into the "image_file_id" column of the "thread" table.   As you can see at the above part the script prints the following:

                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )

And I am looking to insert into the column of the table the following:

542, 543, 544

I thought of re-writing the whole image upload script since this happens inside the for loop, though I thought maybe I could be having this done with the script as it is right now.   Any suggestions on how to do this?