PHP - Add Question Statement

Hi and thanks for taking the time to read through this first and foremost. I have a bit of code that I have managed to piece together with help from other sites and what it does is connect to our local ms sql server and retrieve a few tables from our database. The info is relating to property management and it basically displays the unit address, current date and its rental status. (Occupied or Vacant)

This makes it easy for us to at a glance check the status of our rentals instead of having to log into our software and navigate through all that.. anyways, I have two issues I need help with.

First problem, in my code, is it possible to write a conditional statement that would check for a certain status in a view and then if it is there, print a simple yes or no in a table with that appropriate property.

For example, we have property 1000 name street and it is currently vacant, however the viewPendingLease shows us information regarding future bookings. I would like to be able to look through that view with the code, check property 1000 name street for any future pending leases, and if there is one, print out a "Yes" in a Future Booked column that I would create.

If any of that makes sense, I can post the print out of the tables of the viewPendingLease if it makes it easier for anyone to see the data output to understand what I am meaning.

The second issue, is it possible to change the color of the text according to a variable, say a word in a generated table with html or css? I would like to color the words vacant or occupied green and red respectively just to make it much easier to zero in on the vacant properties. Or even maybe just color every other row a background color just to help distinguish between the different properties.

Here is my code that pulls up my current tables to show Property, Street and current rented status.

Code: [Select]
<?php 

//connect to a DSN "*******" 
$conn = odbc_connect('*******','*****','************'); 

if ($conn) 
{ 
//the SQL statement that will query the database 
$query = "Select unit.PropertyUnitID, unit.Street, unit.Status, from unit";
//perform the query 
$result=odbc_exec($conn, $query); 

echo "<table border=\"1\"><tr>"; 

//print field name 
$colName = odbc_num_fields($result); 
for ($j=1; $j<= $colName; $j++) 
{ 
echo "<th>"; 
echo odbc_field_name ($result, $j ); 
echo "</th>"; 
} 

//fetch tha data from the database 
while(odbc_fetch_row($result)) 
{ 
echo "<tr>"; 
for($i=1;$i<=odbc_num_fields($result);$i++) 
{ 
echo "<td>"; 
echo odbc_result($result,$i); 
echo "</td>"; 
} 
echo "</tr>"; 
} 

echo "</td> </tr>"; 
echo "</table >"; 

//close the connection 
odbc_close ($conn); 
} 
else echo "odbc not connected"; 
?>

I currently have the viewPendingLease.Active (which shows if there is a future pending lease) taken out due to a repeating data issue I am also trying to figure out...

I'm having issues with the following:

Code: [Select]
<?php
session_start();
$_SESSION['username']=$_POST['username'];
$_SESSION['password']=$_POST['password'];
if($_SESSION['username']=="username" && $_SESSION['password']=="password"){
if($_GET['product']=="add"){
$content.='
<p><label>Product Name:</label> <input type="text" name="product_name" size="30" />
<label>Product Price:</label> <input type="text" name="product_price" size="5" />
</p>
<p><label>Product Category:</label> <input type="text" name="product_category" size="30" /></p>
<p><label>Product Link:</label> <input type="text" name="product_link" size="30" /></p>
<p><label>Product Image:</label> <input type="text" name="product_image" size="30" /></p>
<p><label>Product Tag:</label> <input type="text" name="product_tag" size="30" /></p>
<p><label>Product Keywords:</label> <input type="text" name="keyword" size="30" /></p>
<p><label>Product Features:</label><br />
<textarea name="product_features" rows="10" cols="60"></textarea>
</p>
<p><label>Product Pros:</label><br />
<textarea name="product_pros" rows="5" cols="30"></textarea>
</p>
<p><label>Product Cons:</label><br />
<textarea name="product_cons" rows="5" cols="30"></textarea>
</p>
<p><label>Product Description:</label><br />
<textarea name="product_description" rows="10" cols="60"></textarea>
</p>
<p><label>Product Notes:</label><br />
<textarea name="product_notes" rows="5" cols="30"></textarea>
</p>
';
$logout='<div><a href="./acp_admincp.php?log-out">Log-Out</a></div>';
}
elseif($_GET['product']=="view"){
}
else{
$content.='
<a href="./admincp.php?product=add">Add New Product</a>
<br />
<a href="./admincp.php?product=view">View Products</a>
';
}
}
elseif(isset($_GET['log-out'])){
session_start();
session_unset();
session_destroy();
header("Location: ./admincp.php");
}
else{
$content='
<form action="./admincp.php" method="post">
<p><label>Username:</label> <input type="text" name="username" size="30" />';
$content.='</p>
<p><label>Password:</label> <input type="password" name="password" /></p>';
$content.='<p><input type="submit" value="Submit" name="Submit" /></p>
</form>';
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<base href="http://ghosthuntersportal.com/" />
<title>Ghost Hunter's Portal - Admin Control Panel</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="verify-v1" content="" />
<meta name="keywords" content="ghost, hunters, hunter, ghosts, spirit, spirits, paranormal, investigation, investigator, investigators, k2, emf, meter, kii" />
<meta name="description" content="Ghost Hunters Potal. Parnormal research equipment store." />
<meta name="author" content="Andrew McCarrick" />
<meta name="robots" content="index, follow"
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<img src="./logo.png" alt="Ghost Hunter's Portal Admin Control Panel" />
<br />
<div style="color: #AA44AA; font-size: 26px; margin-top: -30px; margin-left: 125px;">Admin Control Panel</div>
<?php
echo $logout;
echo $content;
?>
</body>
</html>

I can log-in, and get to the page with the two links on it. However, once I click one of the links it falls back to the log-in page, and it ends up being a never ending loop.

It's doing this:
Log-In --> Page with links ---> Log-In page again

Should be doing this:
Log-In --> Page with links --> Add Product page or View Products page

I can never get into the the actual sub page.

Just to be clear, the address bar actually shows product=add or product=view, but it still shows the log-in page.

Hello Everyone,
I have to change the if statements to a switch statement, in this game. Can anyone help? Thanks.

var checkKeyPressed = function (e) {
// Press key A or key D to make dog run to the left or right
// The running speed is specified by the step variable, 10 by default.
// If you replace 10 with a larger integer, the dog will run faster.

    //press A, dog runs left
    if (e.keyCode == "65") {
        if (prex[0] > 5) {
            prex[0] = prex[0] - step;
        }
    }
    //press D, dog runs right
    if (e.keyCode == "68") {
        if (prex[0] < right) {
            prex[0] = prex[0] + step;
        }
    }
};

when in a form, I wish to build a conditional that if the response to a radio button is a value of 2 (female), it will display an input requesting for users maiden name. If not 2 goes to the next input statement.

Here is code I was experimenting with:


<html>
<body>
<form action="" name="test"  method='POST'>
<input type="radio" id="sex" value=1 checked><label>Male</label>
<input type="radio" id="sex" value=2><label>Femaleale</label>

    <?php
    $result = "value";
    if ($result == 2)
        echo "<input type='int' id='gradYear' size='3' required>";
        else
        echo "Not a female!"
    ?>

    <input type="submit" value="GO">
</form>
</body>
</html>


The code passes debug, however, Not a Female is displayed.

My question is - Can I do this and if so, what value do I test against id='sex' or value. I tried each one but gave the same results. I realize that $_POST[sex] would be used after the submit button is clicked. But this has me stumped.

Thanks for the assis in advance.

I need help with my if/else statement.

Code: [Select]
function show_list()

{

$query = "SELECT show_id,show_name,host,description_short,show_graphic1 FROM shows";

$result = mysql_query($query) or die(mysql_error());

echo "<table>";

while($row = mysql_fetch_array($result))

  {
     echo "<tr>
            <td rowspan='3' width='155' class='show_image'>
             <a href='". $site ."show_page.php?show_id=". $row['show_id'] ."'>
             <img src='". $site ."images/". $row['show_graphic1'] ."' height='150' width='150'></img></a>
        </td>
            <td class='show_name'>
             <h1>";
              if ($row['host'] == "")
                {
                 echo $row['show_name']" with " $row['host'];
                }
              else
                {
                 echo $row['show_name'];
                }
echo  " </h1>
        </td>
           </tr>
           <tr>
            <td height='100'>"
             . $row['description_short'] .
           "</td>
       </tr>
       <tr>
        <td align='right'>
             <a href='". $site ."show_page.php?show_id=". $row['show_id'] ."'>More Info</a>
            </td>
           </tr>";
  }

echo "</table>";

}


This function is for a page showing a list of shows from a database. Not all shows have a host. So it does not need to show "with host name" for those shows. I tried if / else statement stating that if there "is" data in the row to display one thing and if there "is not" data in the row to display another.

Here is that piece of code.

Code: [Select]
if ($row['host'] == "")
                {
                 echo $row['show_name']" with " $row['host'];
                }
              else
                {
                 echo $row['show_name'];
                }

I keep getting this error

"Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/ansonb/lwr_config.php on line 46"

What am I doing wrong ? I'm sure it is something simple, I just can't figure it out.

I think I know the answer to this, but it would make things easier if I could do what I think I can't.

Can I use LIKE and NOT LIKE in an if statement?  Doesn't seem to be working for me.

Code: [Select]
<?php

//$rightlic is a twelve character string ending either P00, P01, V00, or V01.  I want to do different things based on V or P 

if ($rightlic not like '%V00' AND $rightlic not like '%V01'){
echo "<br>purchaser ran demo as public but is now trying to purchase a private account.  Stop the process.";
exit;
}

?>


Can I do something like this or do I have to separate the string and look for the last characters that way?

Thanks in advance for any help.

this if statement isn't working..
$newid is an integer, which is the name of a variable of an array e.g. $53.  The below code should check if the array exist.  it should echo yes.. instead it is blank.

Code: [Select]
if(isset(${"$newid"})) {
echo "yes";
//code
}

need a little of help if i click on a users profile and they are on the freinds list i need to echo profile with the send message link if not echo the profile with the contact request link.

this my code so far but i get an Parse error: syntax error, unexpected T_ELSE

Code: [Select]
<?php
session_start();
$myusername=$_SESSION['myusername'];
$getuname=$_POST['to_user'];
$amessage =" is Checking you out ";
$message=$_POST['message'];


require "database.php";
 

 $queryuser=mysql_query("SELECT * FROM freinds WHERE username='$myusername' ");
//$result=mysql_query($sql);
$checkuser=mysql_num_rows($queryuser);
if($checkuser != 0){


 
 if (!isset($_GET['username'])) {
       $data = mysql_query("SELECT * FROM users LEFT JOIN status  ON status.username=users.username WHERE status.username = '".$_SESSION['myusername']."' ORDER BY id DESC LIMIT 1;") or die(mysql_error());
}  else  {
       $getuname = mysql_real_escape_string($_GET['username']);
       $data = mysql_query("SELECT * FROM users LEFT JOIN status  ON status.username=users.username WHERE status.username = '".$getuname."' ORDER BY id DESC LIMIT 1;") or die(mysql_error());
}

while($info = mysql_fetch_array( $data )) {



?>

<!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>Untitled Document</title>
<link href="css/main.css" rel="stylesheet" type="text/css">
</head>

<body>
<div class="header">
<img name="Untitled1" src="Untitled-1.gif" width="1000" height="40" border="0" id="Untitled1" usemap="#m_Untitled1" alt="" /><map name="m_Untitled1" id="m_Untitled1">
<area shape="rect" coords="874,0,931,40" href="eurochat.php" alt="" title="Euro Chat"/>
<area shape="rect" coords="828,0,865,40" href="englandchat.php" alt="" title="UK Chat"/>
<area shape="rect" coords="754,0,822,40" href="usachat.php" alt="" title="USA Chat"/>
<area shape="rect" coords="201,21,242,40" href="search.php" alt="" title="Profile Search" />
<area shape="rect" coords="697,0,747,40" href="http://datenight.netne.net/ausnz.php" alt="" title="AU n NZ Chat" />
<area shape="rect" coords="167,20,201,40" href="http://datenight.netne.net/inbox.php" alt="" title="Inbox" />
<area shape="rect" coords="119,21,164,40" href="http://datenight.netne.net/login_success.php" alt="" title="Home"/></map>


</div>

<div class="profile">
<?
 
//Outputs the image and other data
Echo '<a href="freinds.php?username=' . "$getuname" . '">Contact request</a>';
Echo '<a href="new_message.php?username=' . "$getuname" . '">send meesage</a>';

 Echo "<img src='http://datenight.netne.net/images/".$info['img'] ."' width='150' height='150''> <br>";

  Echo "<b>Name:</b> ".$info['username'] . "<br> <hr>";
 Echo "<b>Sex:</b> ".$info['sex'] . " <br><hr>";
 Echo "<b>Intrested in</b>" . "<br><hr>";
 Echo "".$info['rel'] . " ";
 Echo "".$info['frwb'] . " ";
 Echo "".$info['ons'] . " ";
 Echo "".$info['fr'] . "<br><hr>";
 Echo "<b>About me:</b> ".$info['aboutme'] . "<br><hr> ";
 Echo "<b>Looking for:</b> ".$info['looking'] . " <br><hr>";
 Echo "<a href='login_success.php'>'Back'</a>";
 





else {

Echo '<a href="freinds.php?username=' . "$getuname" . '">Contact request</a>';
Echo '<a href="new_message.php?username=' . "$getuname" . '">send meesage</a>';

 Echo "<img src='http://datenight.netne.net/images/".$info['img'] ."' width='150' height='150''> <br>";

  Echo "<b>Name:</b> ".$info['username'] . "<br> <hr>";
 Echo "<b>Sex:</b> ".$info['sex'] . " <br><hr>";
 Echo "<b>Intrested in</b>" . "<br><hr>";
 Echo "".$info['rel'] . " ";
 Echo "".$info['frwb'] . " ";
 Echo "".$info['ons'] . " ";
 Echo "".$info['fr'] . "<br><hr>";
 Echo "<b>About me:</b> ".$info['aboutme'] . "<br><hr> ";
 Echo "<b>Looking for:</b> ".$info['looking'] . " <br><hr>";
 Echo "<a href='login_success.php'>'Back'</a>";


}
}
mysql_query("INSERT INTO alog (from_user, to_user, message ) VALUES ('$myusername', '$getuname','$amessage')") OR die("A log error <br>".mysql_error());



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

Trying to code a first fit algorithm (explanation here). It doesn't output everything correctly at the end. There probably is an easier way to achieve this, but I need to do it using do and while statements.

From the output I only get the first array, none of the others display.

function first_fit(&$arr, &$max)
{
$bin = array(array(), array(), array(), array(), array(), array(), array(), array(), array() ,array() );
$i=0;
$j=0;

do
{

do

{

if (array_sum($bin[$j])+$arr[$i] <= $max) {$bin[$j][] = $arr[$i]; $k=1;

}

$j++;

}

while($k = 0);

$i++;

$j=0;
}
while($i<=9);
outputarray($bin[0]);
outputarray($bin[1]);
outputarray($bin[2]);
outputarray($bin[3]);
outputarray($bin[4]);
outputarray($bin[5]);
outputarray($bin[6]);
outputarray($bin[7]);
outputarray($bin[8]);
outputarray($bin[9]);
}



The function outputarray() just prints the array in a nicely formatted way.

Any help would be much appreciated.

Hi I am trying to perform an echo yes if field from query is equal to one  or no if anything else.  See the code below, Now its erroring saying unexpected t variable in string and its also saying expecting '
It seems to be erroring at the start of my IF statement.
So can anyone please help with what I have done wrong.  This will be my first personal written IF statement so if it is miles off i apologise.
<?php 
   $qGetCat = ("SELECT * FROM category ORDER BY `id`");
   $rGetCat = mysql_query($qGetCat) or die(mysql_error());
   while($Cat = mysql_fetch_assoc($rGetCat)) {
  
  ?>
            <td height="31" align="left" nowrap="nowrap"><?= $Cat['id']  ?></td>
            <td align="left" nowrap="nowrap"><?= $Cat['cat1']  ?></td>
            <td align="left" nowrap="nowrap">
<?php if $Cat['top']='1' 
{ echo "Yes";}
   else  {  echo "No";}
   ?>            </td>
            <td><a href="updatetopcategory.php?=<?= $Cat['id'] ?>"><img src="../images/Edit.png" width="29" height="29" /></a></td>
            <td><img src="../images/delete.jpg" width="29" height="29" /></td>
            <? } ?>

I've never really had this problem before. I'm trying to make it so only moderators can edit titles.

This is currently my if statement:

elseif($type == 2 && acc_status(getUsername()) > 1 && !isset($_POST['title']) || !isset($_POST['content']))

(I can assure you getUsername() works)

Interpretation: If the editing type is 2 (thread/topic) and the user's account status is higher than 2 (meaning admin & mod) and the title or message/content isn't set, display the content within the if statement block. Why is it users with a user status of 1 can see the information within the block statement, allowing them to see the "edit title" field?

I'm having a problem whit the pdo - sql statement:
It dosen't return anything
but when i try $sql = " SELECT en FROM word WHERE MATCH (sp) AGAINST (:word IN BOOLEAN MODE ) "; without the pdo it's working perfectly
Code: [Select]

$sql = " SELECT en FROM word WHERE MATCH (:sp) AGAINST (:word IN BOOLEAN MODE ) ";
$st = $con->prepare($sql);
$st->bindValue(":word",$word,PDO::PARAM_STR);

  $st->bindValue(':sp','sp',PDO::PARAM_STR);


   
$st->execute();

Code: [Select]
<?php
  mysql_connect("localhost","root") or die(mysql_error());
    mysql_select_db("Regis") or die(mysql_error());
     $m=$_POST['message'];
   if (isset($_POST['submit']))
  {
   // makes sure they filled it in // checks it against the database
   $check = mysql_query("SELECT * FROM registration WHERE username = '".$_POST['username']."'")or die(mysql_error());
   //Gives error if user dosen't exist
   $check2 = mysql_num_rows($check);
   if ($check2 == 0)
 {
   echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('That user does not exist in our database')</SCRIPT>")
   ?>
   <html><head></head><body>
   <form name="register" method="post" action="login.php"  onsubmit="return a()">
  <table border='0'>
  <input type="hidden" name="message" value="<?php echo $m;?>">
  <tr><td>Username:</td><td><input type="text" name="username" maxlength="60"></td></tr>
  <tr><td>Password:</td><td><input type="password" name="pass" maxlength="10"></td></tr>
  <tr><td>Confirm Password:</td><td><input type="password" name="pass2" maxlength="10"></td></tr>
  <tr><th colspan=2><input type="submit" name="sub" value="Register"></th></tr></table>
  </form>
  </body>
  </html>

  <?

 while($info = mysql_fetch_array( $check ))

 {

  $_POST['pass'] = stripslashes($_POST['pass']);

  $info['password'] = stripslashes($info['password']);

  $_POST['pass'] = md5($_POST['pass']);

 } }
 
 }
else
{
  ?>
<html>
<head>
<script type="text/javascript">
function addsmiley(code)
{
var pretext = document.smile.message.value;
              this.code = code;
              document.smile.message.value = pretext + code;
}

function a()
{
 var x = document.smile.message.value;
 if(x=="")
 {
  alert("Please insert an message!");
  return false;
 }

}

</script>
<style type="text/css">
body{ background-color: #d8da3d }
</style>
</head>
<body>
  <form name="smile" method="post" action="registration.php" onSubmit="return a()" >
   <input type="hidden" name="message" value="<?php echo $m;?>">
   Your message:<br><textarea name='message' cols='40' rows='2'></textarea><br>
   <img src="smile.gif" alt=":)" onClick="addsmiley(':)')" style="cursor:pointer;border:0" />
   <img src="blush.gif" alt=":)" onClick="addsmiley('*blush*')" style="cursor:pointer;border:0" />
   <input type='submit' name='submit' value='Set Name' class='biasa'  ></form>
   

 
  <br> <br>
  </body>
</html>
              <?php

 } 

 

 ?>

im doing if statments if the  $check2==0 it will show the registration form and else it will show the
 form name="smile" method="post" action="registration.php" onSubmit="return a()" >
   <input type="hidden" name="message" value="<?php echo $m;?>">
   Your message:<br><textarea name='message' cols='40' rows='2'></textarea><br>
   <img src="smile.gif" alt="" onClick="addsmiley('')" style="cursor:pointer;border:0" />
   <img src="blush.gif" alt="" onClick="addsmiley('*blush*')" style="cursor:pointer;border:0" />
   <input type='submit' name='submit' value='Set Name' class='biasa'  ></form>


but my problem is it cannot direct to else matter although the name is already in database may i know which error is wrong or the if statement is wrong