PHP - I Need Help With If/else Statements, Thanks In Advance.

Anything wrong with this because I got a parse error ONLY after adding to create this.

<?php
                            $visible = array('Yes', 'No');
                            foreach($visible as $visible):
                            $visible2 = array('yes', 'no');
                            foreach($visible2 as $visible2):
                        ?>      

I am trying to write an if statement that checks to make sure the information put in the text box is an imbedded file. Does anyone know how to do that?

Hello, I am learning PDO SQL statements, I have mananged to connect using PDO:


Code: [Select]
try
{
$this->link = $dbh = new PDO('mysql:host='.$this->dbhost.';dbname='.$this->dbname.'', $this->dbuser, $this->dbpass);
}
catch (PDOException $e)
{
echo 'Connection failed: ' . $e->getMessage();
}


I am not getting any error, so I guess that is a good start. I then tried the PDO SQL statement out. My old mySQL query is commented out in the


Code: [Select]
if (isset($_SESSION['id']) && isset($_SESSION['password']))
{
$_SESSION['id'] = ( isset( $_SESSION['id'] ) ) ? $_SESSION['id'] : FALSE;
$_SESSION['password'] = ( isset( $_SESSION['password'] ) ) ? $_SESSION['password'] : FALSE;


//$logged = mysql_query("SELECT * FROM `db_members` WHERE `id`='".$_SESSION['id']."' AND `password` = '".$_SESSION['password']."'");
//$logged = mysql_fetch_array( $logged );

// the new pdo statement
$ff = $dbh->prepare('SELECT * FROM db_members WHERE id = '.$_SESSION['id'].' AND password = '.$_SESSION['password'].'');

$ff->execute();
$logged = $ff->fetchAll();

echo $logged['username'];
}

I am trying to assign the session to logged variable. So all I am asking is go into db_members and check the id and password that is the same as session id and password and collect the rows data such as username.

My login script and everything works perfectly, even session id and password is valid when echo'd but I cannot assign it to the logged variable like my old sql statements.


Code: [Select]
$logged = mysql_query("SELECT * FROM `db_members` WHERE `id`='".$_SESSION['id']."' AND `password` = '".$_SESSION['password']."'");
$logged = mysql_fetch_array( $logged );

I used other PDO statements and it works perfectly but I just don't understand why this is not working.... can I please get some help if you have any solution to this?

Hey guys,

is there any way to have a LIKE condition on an IF statement?
Something like:
Code: [Select]
if $GET_['WTV'] LIKE %LOVE% {
$category=romance
Any clues?
Thanks in advance.

Okay i'm trying to compare these sets of variables.

code looks like this..

Code: [Select]
if(
               $row->cash > $finalcash &&
               $row->core1 > $finalcore1 &&
               $row->core2 > $finalcore2 &&
               $row->core3 > $finalcore3 &&
               $row->core4 > $finalcore4
               ) {
return true;
}
else {
return false;
}
First question is this the appropriate way of doing this?

Or would a nested if statement work better?

example:

Code: [Select]
if ($row->cash > $finalcash) {
    if ($row->core1 > $finalcore1) {
        if ($row->core2 > $finalcore2) {
            if ($row->core3 > $finalcore3) {
                if ($row->core4 > $finalcore4) {
                   
                } else {
                    return false;
                }
            } else {
                return false;
            }
        } else {
            return false;
        }
    } else {
        return false;
    }
} else {
    return false;
}
I know it looks pretty messy, so i'm wondering if anybody is aware of an alternative to achieving this?

Hello:

I am writing this code:
Code: [Select]
<?php

include('include/myConn.php');
include('include/myCodeLib.php');

$zip_id = $_REQUEST['zip_id'];

$query=mysql_query("SELECT zip_id,city,full_state,zip FROM zip_codes WHERE zip_id = $zip_id") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $zip_id=$result['zip_id'];
  $city=$result['city'];
  $full_state=$result['full_state'];
  $zip=$result['zip'];
}

?>

<!DOCTYPE HTML>

<head>

<title></title>

</head>

<body>

<?php echo $city; ?>, <?php echo $full_state; ?> <?php echo $zip; ?>

</body>

</html>


It works fine as far as writing out the "City, State Zipcode", but I wanted to see if there is a way to "join" the 3 statements together so it can be written as just 1 statement. Like:
Code: [Select]
<?php echo $city, $full_state $zip; ?>

What is the trick to doing this?

Thanks in advance.

Hi,

What is a shorter way instead of having all these if statements?
Here it is:

Code: [Select]
      if($matchno==1)
         return 66;
      elseif($matchno==2)
         return 67;
      elseif($matchno==3)
         return 68;
      elseif($matchno==4)
         return 69;
      elseif($matchno==5)
         return 70;
      elseif($matchno==6)
         return 71;
      elseif($matchno==7)
         return 72;
      elseif($matchno==8)
         return 73;
      elseif($matchno==9)
         return 74;
      elseif($matchno==10)
         return 75;
      elseif($matchno==11)
         return 76;
      elseif($matchno==12)
         return 77;
      elseif($matchno==13)
         return 78;
      elseif($matchno==14)
         return 79;
      elseif($matchno==15)
         return 80;
      elseif($matchno==16)
         return 81;
      elseif($matchno==17)
         return 82;
      elseif($matchno==18)
         return 83;
      elseif($matchno==19)
         return 84;
      elseif($matchno==20)
         return 85;
      elseif($matchno==21)
         return 86;
      elseif($matchno==22)
         return 87;
      elseif($matchno==23)
         return 88;
      elseif($matchno==24)
         return 89;
      elseif($matchno==25)
         return 90;
      elseif($matchno==26)
         return 91;
      elseif($matchno==27)
         return 92;
      elseif($matchno==28)
         return 93;
      elseif($matchno==29)
         return 94;
      elseif($matchno==30)
         return 95;
      elseif($matchno==31)
         return 96;
      elseif($matchno==32)
         return 97;

someone please code shorter?
I will learn this way.

Thanks.

I need to insert a large variable number of records into a mysql table.
I can do this using a while loop and insert queries in the loop but its slow and ive been given to understand its a bad idea.
I have heard that I can insert multiple rows with one query, but how to construct the query?

This code can perfectly and reliably display a statement with echo:
Code: [Select]
<?php
$querytestquery='"INSERT INTO test(qval1, qval2) VALUES';
echo $querytestquery;
$querymax=10;
$querystart=0;
while ($querystart<$querymax) {
$qval1=1*$querystart;
$qval2=2*$querystart;
$queryadd="($qval1, $qval2)";
echo $queryadd;
if ($querystart<$querymax-1) {
echo ',';
}
$querystart++;
}
echo '"';
?>

"INSERT INTO test(qval1, qval2) VALUES(0, 0),(1, 2),(2, 4),(3, 6),(4, ,(5, 10),(6, 12),(7, 14),(8, 16),(9, 18)"

But I don't understand how to set a variable equal to the displayed query so that I can have php construct the statement based on the values and the number of records I want to update or insert.

 
i have been trying to make this work for days, this needs to also include a discount for staying over >=5 days in Tokyo, no matter what i do i always gets syntax error this class is making me crazy how do i go about getting the discount in this????? please help
<?php
      $destination = $_POST['destination'];
      $numTravelers = $_POST['numTravelers'];
      $numNights = $_POST['numNights'];
      $airFare = $_POST['airFare'];
      $hotel = $_POST['hotel'];
               
       if ($destination == Barcelona)
       {$airFare = 875.00;
       $perNight = 85.00;}
       elseif ($destination == Cairo)
       {$airFare= 950.00;
       $perNight = 98.00;}
       elseif ($destination == Rome)
       {$airFare = 875.00;
       $perNight = 110.00;}
       elseif ($destination == Santiago)
       {$airFare = 820.00;
       $perNight = 85.00;}
       elseif ($destination == Tokyo)
         {$airFare = 1575.00;
         $perNight = 240.00;}
this is where i can not figure out how to put in the discount off the airfare for staying over five days
      elseif ($destination == Tokyo && $numNights >=5)            
      $tickets = $numTravelers * $airFare;
      $hotel = $numTravelers * $numNights * $perNight;
      $totalCost = $tickets + $hotel;
      
      print("<p>Destination: $destination<br />");
      print("Number of people: $numTravelers<br />");
      print("Number of nights: $numNights<br />");
      print("Airline Tickets: $".number_format($tickets, 2)."<br />");
      print("Hotel Charges: $".number_format($hotel, 2)."</p>");
      print("<p><strong>TOTAL COST: $".number_format($totalCost, 2)."</strong></p>");
   ?>

If my SQL statement returns a result I want to change the background color of a cell. If the user is logged in I want to then show one of two buttons. either book, or cancel, depending on whether the cell is available or not. So far I have this:


$sql = "SELECT * FROM diary WHERE day = '$mon' AND studio_id ='mon11'";
$query = mysql_query($sql) or die (mysql_error());
if (mysql_num_rows($query) < 1)
{ 
$bgcolour= '#5DFC0A';
if(isSet($_SESSION['logged']))
{
$book = '<form action="../book.php" method="POST"><input type="hidden" name="day" value='.$mon.' type="text"/><input type="hidden" name="month" value='.$month.' type="text"/><input type="hidden" name="year" value='.$year.' type="text"/><input type="hidden" name="book_id" value="mon11" type="text"/><input type="submit" name="submit" value="Book!"></form>';
}} else {
$bgcolour= '#FF0000';
}
if(isSet($_SESSION['logged']))
{
$book = '<form action="../cancel.php" method="POST"><input type="hidden" name="day" value='.$mon.' type="text"/><input type="hidden" name="month" value='.$month.' type="text"/><input type="hidden" name="year" value='.$year.' type="text"/><input type="hidden" name="book_id" value="mon11" type="text"/><input type="submit" name="submit" value="Cancel!"></form>';
}
echo "<td rowspan='3' bgcolor=".$bgcolour.">";
if (isset($book)) 
{
    echo $book;
}


I want to use the $session(logged) variable to show the appropriate button, but I can't get it to work in the other if statement,

Any ideas?

this is working fine :

Code: [Select]
while($tags=mysql_fetch_array($d_b->sql_answer,MYSQL_ASSOC)){
echo $tags['tag_name'] . "<br/>";
}
display :

Code: [Select]
html
css
javascript
c++
php
but when i try to do some sql statements inside like this :

Code: [Select]
while($tags=mysql_fetch_array($d_b->sql_answer,MYSQL_ASSOC)){
$sql="SELECT * FROM user
      WHERE user_languages LIKE '% {$tags[tag_name]} %'";

//to apply the $sql
$d_b->apply($sql);
//number of results
$num=$d_b->num_rows();
$sql="UPDATE tags
      SET tag_folowers={$num}";
$d_b->apply($sql);
}
it return an error : Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given

Hi There,

Im trying to figure out how to do this if/else statement. I need it to say, "if this is true, do this. if this is true, do this. If neither is true, do this.

So there are three different possible outcomes. I tried to put each new if inside of the previous else. but that doesn't seem to work.



$firstname = $_REQUEST['firstname'];
$lastname = $_REQUEST['lastname'];

if ($firstname == 'Joey' and $lastname == 'Hodara')
{
$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ', Oh Glorious Leader!';

}

else 
{  

if ($firstname == 'Matt' and $lastname == 'Fig') 
{
$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ', Portagee!';
}

else{
if ($firstname == 'Jon' and $lastname == 'Spense') 
{
$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ', bro!';
}

}

$output = 'Welcome to our site, ' . 
htmlspecialchars($firstname, ENT_QUOTES, 'UTF-8') . ' ' . htmlspecialchars($lastname, ENT_QUOTES, 'UTF-8') . '!';




?>

Hello, I'm currently working on just a quick little frontend for  VirtualBox and I'm just running into a little bit of a problem that I can't find my way around. Now this is my first project in php. I'm familiar with programming concepts (well except this one apparently  ) and by familiar were talking I like to tinker with small languages.. no formal training.
Anyway, here we go.

So heres the main page. Pretty simple, you type the argument that goes with the following command and check the box next to the command you'd like to execute.

Code: [Select]
<HTML>
<HEAD>
<TITLE>LCCP ver1</TITLE>
</HEAD>

<BODY>
<?php include "header.php"; ?>
<form method="post" action="lccp_ver1.php">
<p>cmd="createvm"<br>
        Enter the name of the Virtual Guest you'd like to create:
        <input type="text" name="id">
        <input type="checkbox" name="createvm">
        </p>
<p>cmd="showvrtinfo"<br>
Enter the name of the Virtual Machine you'd like to view:
<input type="text" name="id2">
<input type="checkbox" name="showvminfo">
</p>
<p>cmd="unregistervm"<br>
Enter the name of the Virtual Guest you'd like to delete:
<input type="text" name="id3">
<input type="checkbox" name="unregistervm">
</p>
<p>cmd="startvm"<br>
Enter the name of the Virtual Machine you'd like to start:
<input type="text" name="id4">
<input type="checkbox" name="startvm">
</p>
<p>cmd="controlvm"<br>
Enter the name of the Virtual Machine you'd like to control:
<input type="text" name="id5">
<input type="checkbox" name="controlvm">
</p>
<p>Then.. would you like to...</p>
<p>arg="pause" <input type="checkbox" name="controlvm_pause"></p>
<p>arg="resume" <input type="checkbox" name="controlvm_resume"></p>
<p>arg="reset" <input type="checkbox" name="controlvm_reset"></p>
<p>arg="poweroff" <input type="checkbox" name="controlvm_poweroff"></p>
<p>arg="savestate" <input type="checkbox" name="controlvm_savestate"></p>
<input type="submit" name="Submit" value="Submit">
</form>
</BODY>
</HTML>

And then here is the execution page
Code: [Select]
<HTML>
<HEAD>
<TITLE>LCCP command
<?php 
function ServerLoad()
{

$stats = exec('uptime');

preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/', $stats, $regs);

return ($regs[1].', '.$regs[2].', '.$regs[3]);
}
echo ServerLoad(); 

?>
</TITLE>
</HEAD>

<BODY>
<?php include "header.php"; ?>
<?php
function createvm($id) {
                        $output = shell_exec("VBoxManage createvm --name " . $id . " --register");
                        return $output;
                        }
function showvminfo($id) {
$output = shell_exec("VBoxManage showvminfo " . $id);
return $output;
}
function unregistervm($id) {
$output = shell_exec("VBoxManage unregistervm ". $id ." --delete");
return $output;
}
function startvm($id) {
$output = shell_exec("VBoxManage startvm ". $id ." --type headless");
return $output;
}
function controlvm($id,$arg) {
$output = shell_exec("VBoxManage controlvm ". $id ." ". $arg);
return $output;
}
function print_output($output) {
 echo'
 <pre>'. $output . '
         </pre>';
}
//******************exec main**********************

        if (isset($_POST['createvm'])) {
//              createvm($_POST['id2']);
                print_output(createvm($_POST['id']));
                }
if (isset($_POST['showvminfo'])) {
// showvminfo($_POST['id']);
print_output(showvminfo($_POST['id2']));
}
if (isset($_POST['unregistervm'])) {
// unregistervm($_POST['id3');
print_output(unregistervm($_POST['id3']));
}
if (isset($_POST['startvm'])) {
// startvm($_POST['id4']);
print_output(startvm($_POST['id4']));
}
if ((isset($_POST['controlvm'])) AND (isset($_POST['controlvm_pause'))) {
//controlvm($_POST['id5']," pause");
print_output(controlvm($_POST['id5']," pause"));
}
if ((isset($_POST['controlvm'])) AND (isset($_POST['controlvm_resume'))) {
//controlvm($_POST['id5']," resume");
print_output(controlvm($_POST['id5']," resume"));
}
if ((isset($_POST['controlvm'])) AND (isset($_POST['controlvm_reset'))) {
//controlvm($_POST['id5']," reset");
print_output(controlvm($_POST['id5']," reset"));
}
if ((isset($_POST['controlvm'])) AND (isset($_POST['controlvm_poweroff'))) {
//controlvm($_POST['id5']," poweroff");
print_output(controlvm($_POST['id5']," poweroff"));
}
if ((isset($_POST['controlvm'])) AND (isset($_POST['controlvm_savestate'))) {
//controlvm($_POST['id5']," savestate");
print_output(controlvm($_POST['id5']," savestate"));
}
//**********working on***************
//teleport?

?>
</BODY>
</HTML>

Now my question is with the if statements. Well, number one I guess is there a more efficient way of doing this that I'm overlooking? I looked into switches but I don't know how I'd pull that off with checkboxes without some complicated loop and somehow converting the checkboxes "yes" or "nos" into numbers or something. If statements just seemed like less of a headache but I may be finding otherwise haha.

Number two here is how do I get the "controlvm" command to work? When I comment out that last indented lines of if statements the program runs perfect (and thats with the controlvm function as well. so.. the problem isn't there). Basically whats the appropriate way to do this. I'm stuck and my limited program knowledge and Google searching is starting to run thin.

Thanks in advance for the help!

I have a general dbInsert class method that accepts three arguments: table, fields, and values - the last two each as an array. I am using a PDO connection and prepared statements to sanitize everything. I am having a problem with the bindParam() function accepting the parameter ID's though... here's my code and the result I am getting, any advice?

My arguments:


$this->_table   =  "testdata";
$this->_fields  =  array('product_id', 'store_id', 'description', 'price', 'colors', 'sizes');
$this->_values  =  array("20002157", "2005", "Kids polo shirt", "12.59", "White", "Large");


My object:


$_crud = new Crud();
$_makeCrud = $_crud->dbInsert($this->_table, $this->_fields, $this->_values);


My class:


public function dbInsert($table, $fields, $values) {

      $_table = $table;
      $_fields = implode(", ", $fields);

      // Create and format the list of insert values
      $_values = "";  

      // replaces values with "?" placeholders
      foreach ($values as $value) {
            $_values .= "?" . ", ";
      }

      // trims off last comma and space
      $_values = substr($_values, 0, -2);

      // checks database connection
      if (isset($this->_dbh)) {

            // Create the SQL Query  
    $this->_sql = 'INSERT INTO ' . $_table . ' (' . $_fields . ') VALUES (' . $_values . ')';

            // Build the query transaction
            $this->_dbh->beginTransaction();

            // Build the prepared statement
            $this->_stmt = $this->_dbh->prepare($this->_sql);

            // Bind the parameters to their properties
            foreach ($values as $key => $val) {
                  
                  // starts $key at 1
                  $key = (int) $key + 1;
                  $this->_stmt->bindParam($key, $val);
               }

            // Execute the query
            $this->_stmt->execute();

            $this->_affectedRows = $this->_stmt->rowCount();

      }
}


What my new table row should look like:

Code: [Select]

product_id     store_id      description                        price       colors      sizes
----------------------------------------------------------------------------------------------
20002157       2005          kids polo shirt                    12.59        white      large



But this is what my new row DOES look like:

Code: [Select]

product_id     store_id      description                        price       colors      sizes
----------------------------------------------------------------------------------------------
Large              0         Large                               0.00        Large      Large



So it's taking the value of that last $value and inserting it in all the fields, the store_id and price are 0 and 0.00 because of their numeric type...

I assume it is a syntax error, missing quotes somewhere, but where?

I always have trouble reading shorthand statements, as i am used to always using brackets. So when i view someones code and they use shorthand, i get confused.  Can i get a clear explanation on the example below:

if ( have_posts() ) : while ( have_posts() ) : the_post();
					the_content();
					
					endwhile; else: 
					
						echo "<p>Sorry, no posts matched your criteria.</p>";
					
					endif;

I've always been accustomed to using brackets, so i have trouble understanding the above quickly.