PHP - Moved: Firefox2 Prefix Conditional Statement

I want to write a conditional statement like the following:

if ($value = "300x") {

however, I want this to work if x is changed to anything. So the conditional should work if the following is true:

if ($value = "300dog") {

or

if ($value = "300cat") {

How do I make it work as long as 300 is present regardless of what follows after. Thanks in advance!

I have a membership directory that I've been working with for a long time, and recent server upgrades with MySQL, PHP, etc. forced me to do some recoding. While I was doing that, I wanted to try and make some improvements. I must give a brief description of the intent, and then the results I got, so someone can sort out the problem for me. I have a query that selects all "Agent" members, then orders them by County, then by Company Name. What I am trying to do is create a new heading in my list every time the County information changes as the list is sorted and output to my table.   I am going to attache 2 .php files with my code. The agent_member_list.php is the original code that pulls all of the members properly, and results can be viewed he http://www.nmlta.org...member_list.php   The agent2_member_list.php is where I'm trying to insert the new conditional statement to print my County headings when a new County is encountered in the results. The heading actually works, and changes correctly, but the problem is that the first member entry in every county is not printed in the output. I know the query is correct, so I'm sure I've got the conditional "if" for checking County field wrong, or misplaced.  Here is the link to it: http://www.nmlta.org...member_list.php   I'm hoping someone can spot my error pretty quickly, I only dabble in this very rarely.  Thanks for any help! Attached Files  agent2_member_list.php   5.06KB   3 downloads  agent_member_list.php   4.82KB   2 downloads

I have the following code which seems to be in error in the conditional statement.
The queries to the database produce the expected results, and the echo statements work OK.
I want to make a selection based on whether data exists in the database for passState when passState=1.

Can anyone tell me what is wrong with the conditional statement?

Code: [Select]
<?php
$query1 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 1 ORDER BY quizTitle ASC, passState DESC, userDate DESC ");

$query2 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 0 ORDER BY quizTitle ASC, passState DESC, userDate DESC "); 
 ?>
                <table width="778" style="font-size:16px">
                  <tr>
 <?php
if ($query1) {
while ($row1 = mysql_fetch_array($query1))
{
           echo'<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row1['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row1['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row1['userScore']}".'/'."{$row1['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';                  
}
}else{
while ($row2 = mysql_fetch_array($query2))
{

              echo '<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row2['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row2['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row2['userScore']}".'/'."{$row2['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';
                  
}
}
 ?>
                </table>

Hi,

Why doesn't this work? Driving me nuts! Thanks.

<?php
    if($_SERVER[PHP_SELF] == 'somepage.php')
   {
     Header("Location: http://www.thissite.com");
    } else {
     Header("Location: http://www.anothersite.com");
    }
?>

The code NEVER redirects to the first URL (thissite.com). It ALWAYS redirects to  the second URL (anothersite.com).

What the heck am I doing wrong? 

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...

Hi all.

I'm working on a PHP application that will serve several clients.  After a discussion on another thread about compliance, I've decided that using tables with a client specific prefix would be the safest way to go.  However, I'm having a lot of trouble wrapping my head around what the database connection script would look like.  I have a generic one that connects with host, user, pwd, and db as arguments but I'm not sure how to modify it to incorporate the table prefix requirement.  Thoughts on how I can incorporate the aforementioned requirement and enhance the script in general?


function connect_mysql($host,$user,$pass,$database){

$conn=mysql_connect($host,$user,$pass)or die('Cannot create link');

mysql_select_db($database)or die('Cannot select database');

};

Hi,
I have the below code to show the suggestion text, now it’s showing all the words which contain the letter when I first type in the text field. For example, If I typed the letter “a”, it should show only the words which start with the letter “a”, now it’s showing all the words which contain the letter “a” in the suggestion. Below is my code. Thanks in advance.

 

<?php
$xmlDoc=new DOMDocument();
$xmlDoc->load("links.xml");

$x=$xmlDoc->getElementsByTagName('link');

//get the q parameter from URL
$q=$_GET["q"];

//lookup all links from the xml file if length of q>0
if (strlen($q)>0) {
  $hint="";
  for($i=0; $i<($x->length); $i++) {
    $y=$x->item($i)->getElementsByTagName('title');
    $z=$x->item($i)->getElementsByTagName('url');
    if ($y->item(0)->nodeType==1) {
      //find a link matching the search text
      if (stristr($y->item(0)->childNodes->item(0)->nodeValue,$q)) {
        if ($hint=="") {
          $hint="<a href='" .
          $z->item(0)->childNodes->item(0)->nodeValue .
          "' target='_blank'>" .
          $y->item(0)->childNodes->item(0)->nodeValue . "</a>";
        } else {
          $hint=$hint . "<br /><a href='" .
          $z->item(0)->childNodes->item(0)->nodeValue .
          "' target='_blank'>" .
          $y->item(0)->childNodes->item(0)->nodeValue . "</a>";
        }
      }
    }
  }
}

// Set output to "no suggestion" if no hint was found
// or to the correct values
if ($hint=="") {
  $response="no suggestion";
} else {
  $response=$hint;
}

//output the response
echo $response;
?> 

 

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=312323.0

This topic has been moved to Editor Help (Dreamweaver, Zend, etc).

http://www.phpfreaks.com/forums/index.php?topic=308819.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306275.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=358684.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=322930.0

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=350701.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=327011.0

This topic has been moved to Other Programming Languages.

http://www.phpfreaks.com/forums/index.php?topic=354391.0