PHP - Testing For Dates: Having Issues With My Test Conditions

I have created a form in wich a user inputs until 5 ranges of numbers
<tr>
<td width='270' align='right'>Εύρος1__Από: </td>
<td><input type='text' name='fromNum' size='20' /></td>
<td width='270' align='right'>Εως: </td>
<td><input type='text' name='toNum' size='20'/></td>
</tr>
<tr>
<td width='270' align='right'>Εύρος2__Από: </td>
<td><input type='text' name='fromNum2' size='20' /></td>
<td width='270' align='right'>Εως: </td>
<td><input type='text' name='toNum2' size='20'/></td>
</tr>
<tr> the same and for ranges 3,4,5

i put a constraint for the ranges
$regExpNum = '/^[0-9]{6}$/';
$regExpNum2 = '/^[0-9]{6}$/';
$regExpNum3 = '/^[0-9]{6}$/';
$regExpNum4 = '/^[0-9]{6}$/';
$regExpNum5 = '/^[0-9]{6}$/';

$validfromNum = preg_match($regExpNum,$_POST['fromNum'],$matchesfrom);
$validtoNum = preg_match($regExpNum,$_POST['toNum'],$matchesto);
$validfromNum2 = preg_match($regExpNum2,$_POST['fromNum2'],$matchesfrom2);
$validtoNum2 = preg_match($regExpNum2,$_POST['toNum2'],$matchesto2);
$validfromNum3 = preg_match($regExpNum3,$_POST['fromNum3'],$matchesfrom3);
$validtoNum3 = preg_match($regExpNum3,$_POST['toNum3'],$matchesto3);
$validfromNum4 = preg_match($regExpNum4,$_POST['fromNum4'],$matchesfrom4);
$validtoNum4 = preg_match($regExpNum4,$_POST['toNum4'],$matchesto4);
$validfromNum5 = preg_match($regExpNum5,$_POST['fromNum5'],$matchesfrom5);
$validtoNum5 = preg_match($regExpNum5,$_POST['toNum5'],$matchesto5);

i want to wright a combination of contitions for the five ranges.
for one range here is the code, but could you please help me to write a code for all of them?


$regExpNum = '/^[0-9]{6}$/';
$validfromNum = reg_match($regExpNum,$_POST['fromNum'],$matchesfrom);
$validtoNum = preg_match($regExpNum,$_POST['toNum'],$matchesto);

$errorMsg='';

if (!$validfromNum || !$validtoNum) {
if (!$_POST['fromNum'] && !$_POST['toNum']) {
$errorMsg="μήνυμα";
$htmlData['errorMsg']= $errorMsg;
$this->loadPage($htmlData);
return false;
} else if ($validtoNum && !$_POST['fromNum']) {
set_time_limit(240);
$data = $this->R100WorkOrder->GetWoRangeData($_POST['toNum'], $_POST['toNum']);
} else if ($validfromNum && !$_POST['toNum']) {
set_time_limit(240);
$data = $this->R100WorkOrder->GetWoRangeData($_POST['fromNum'], $_POST['fromNum']);

} else {
$errorMsg="μήνυμα";
$htmlData['errorMsg']= $errorMsg;
$this->loadPage($htmlData);
return false;
}
} else {
####################################################### Form Validation ################################################# End
if ($_POST['fromNum'] > $_POST['toNum']) {
$errorMsg="μήνυμα ";
$htmlData['errorMsg']= $errorMsg;
$this->loadPage($htmlData);
return false;
} else if ($_POST['toNum'] - $_POST['fromNum'] > 100 ) {
$errorMsg="μήνυμα";
$htmlData['errorMsg']= $errorMsg;
$this->loadPage($htmlData);
return false;
} else {
set_time_limit(240);
$data = $this->R100WorkOrder->GetWoRangeData($_POST['fromNum'], $_POST['toNum']);
}
}

I forgot how to write multiple conditions with if().

if (A == B || C == D) {foobar;}
I know the above is if any of the conditions is true, then do foobar, but what is it again so they both have to be true? I have forgotten, but I'm guessing either

if (A == B && C == D) {foobar;}
if (A == B ++ C == D) {foobar;}

?

<?php
require_once('upper.php');
if(isset($_COOKIE['AdminCookie'])){
if(isset($_POST['submit'])){
require_once('database.php');
$ActivityName =$_POST['ActivityName'];
$EventName =$_POST['EventName'];
$BloodGroup =$_POST['BloodGroup'];
$Location =$_POST['Location'];
$Age =$_POST['Age'];
//$Sex =$_POST['Sex'];
echo $ActivityName;
$query="select * from registration WHERE  Flag='A' AND BloodGroup= '$BloodGroup' AND Age ='$Age'";
//$query="select * from registration WHERE  Flag='A'  AND Address like '%$Location%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');
while($row=mysqli_fetch_array($result))
{
echo $row['Name'];
}


/*if(isset($_POST['ActivityName']))
{
require_once('database.php');
$Search=$_POST['Search'];
$query="select * from registration where Flag='A' AND Activity like '%,$Search,%'";
$result=mysqli_query($dbc,$query) or die('Not Connected');
while($row=mysqli_fetch_array($result))
{
echo "<table border='2'><tr><td> Name--".$row['Name']."</td>
<td>Contact Number--".$row['ContactNumber']."</td>
<td>Email--".$row['Email']."</td>
<td>Address--".$row['Address']."</td></tr></table>";
}
}

elseif(isset($_POST['EventId'])){
require_once('database.php');
$Search=$_POST['Search'];
$query="SELECT * FROM registration r JOIN participation p ON r.LoginId = p.LoginId WHERE r.Flag='A' AND p.EventId ='$Search'";
$result=mysqli_query($dbc,$query) or die('Not Connected');
while($row=mysqli_fetch_array($result)){
echo "<table border='2'><tr><td> Name--".$row['Name']."</td>
<td>Contact Number--".$row['ContactNumber']."</td>
<td>Email--".$row['Email']."</td>
<td>Address--".$row['Address']."</td></tr></table>";
}}

elseif(isset($_POST['Location']))
{
require_once('database.php');
$Search=$_POST['Search'];
$query="select * from registration where Flag='A' AND Address like '%$Search%'";
$result=mysqli_query($dbc,$query) or die('Not Connected');
while($row=mysqli_fetch_array($result))
{
echo "<table border='2'><tr><td> Name--".$row['Name']."</td>
<td>Contact Number--".$row['ContactNumber']."</td>
<td>Email--".$row['Email']."</td>
<td>Address--".$row['Address']."</td></tr></table>";
}
}

elseif(isset($_POST['BloodGroup']))
{
require_once('database.php');
$Search=$_POST['Search'];
$query="select * from registration where Flag='A' AND BloodGroup ='$Search'";
$result=mysqli_query($dbc,$query) or die('Not Connected');
while($row=mysqli_fetch_array($result))
{
echo "<table border='2'><tr><td> Name--".$row['Name']."</td>
<td>Contact Number--".$row['ContactNumber']."</td>
<td>Email--".$row['Email']."</td>
<td>Address--".$row['Address']."</td></tr></table>";
}*/
}
?>
<html><body><form action='<?php echo $_SERVER['PHP_SELF']?>' method="post">
<?php 
require_once('database.php');
$result=mysqli_query($dbc,"select * from Activity");
echo "Select Activity &nbsp&nbsp
<select name='ActivityName'>
<option></option>";
while($row=mysqli_fetch_array($result)){
echo "
<option>".$row['Title']."</option>";
}
echo "</select><br>";



$result=mysqli_query($dbc,"select * from events");
echo "Select Events &nbsp&nbsp
<select name='EventName'>
<option></option>";
while($row=mysqli_fetch_array($result)){
echo "
<option>".$row[Title]."</option>";
}
echo "</select><br>";


$result=mysqli_query($dbc,"select * from registration");
echo "Select Blood Group &nbsp&nbsp
<select name='BloodGroup'>
<option></option>";
while($row=mysqli_fetch_array($result)){
echo "
<option>".$row[BloodGroup]."</option>";
}
echo "</select><br>";


echo" Enter Location &nbsp&nbsp 
<input type='text' name='Location'><br>";
echo"Enter Age &nbsp&nbsp
<input type='text' name='Age'><br>";


echo "Enter Sex &nbsp&nbsp 
<select>
<option></option>
<option>Male</option>
<option>Female</option>
</select><br>";

echo "<input type='submit' name='submit' value='Search'><br>";
echo"</form></body></html>";


echo "<a href='log_out.php'>Admin Log out</a><br>";
echo "<a href='AdminHome.php'>Back to Admin Home</a>";
}
else{echo 'Restricted Page'."<br><br>".'Access Denied';}

require_once('lower.php');?>
Hi frds..........
I want to search by "Age" and "Blood Group" first.On combobox when I select both Age and Blood Group it gives the rihgt result but when I select only one field and other remain blank it not works.............
I want when I select only one field, query executes for one condition only....
It means when I select only Blood Group and leave Age field blank it displays all Name have required Blood Group without any age condition.

I have a rule of conditions for access into an area of my site. The problem is, that when the wrong password is given, its still giving access to the area of the site. It is happening because I am using conditions wrong, and ask if someone could help me out by pointing out the correct way to do it.

When I say "conditions", I am referring to things such as && and ||


if ($row['laybypassword'] == $_POST['lay-bypassword'] && $row['status'] == "A" || $row['status'] == "B" || $row['status'] == "C")


So, if the correct password is given, and the row status equals A, B, or C, then do foobar.

Hey all,

I would like to some how clean up an if statement to be a little cleaner.

Code: [Select]
if(condition && condition && (condition && condition) || (condition && condition) || (condition && condition))

How can I do that?

Hello, Im trying to write a select query that has two conditions. First the playername is = username and second shipyard = 1 I keep getting a parse error: Parse error: syntax error, unexpected ',' in C:\wamp\www\SWB\planet1.php on line 85

Heres the code:

Code: [Select]
$tester = "1";
$colname_Planet1 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Planet1 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Planet1 = ("SELECT * FROM planet WHERE ShipYard = %s AND PlayerName = %s",  GetSQLValueString($tester, "int"),GetSQLValueString($colname_Planet1, "text"));
$Planet1 = mysql_query($query_Planet1, $swb) or die(mysql_error());
$row_Planet1 = mysql_fetch_assoc($Planet1);
$totalRows_Planet1 = mysql_num_rows($Planet1);

Please help :|

Do race conditions usually exist when writing OR appending to an existing file?

Code: [Select]
$f1 = fopen($filename1, 'r+');
$f2 = fopen($filename2, 'a');
flock($f1, LOCK_EX);
flock($f2, LOCK_EX);
fwrite($f1, 'foo');
fwrite($f2, 'foo');
flock($f1, LOCK_UN);
flock($f2, LOCK_UN);
fclose($f1);
fclose($f2);

What would happen if this code ran at the exact same time? Is there a chance that the data could be corrupted in the aforementioned code example?

Hello everyone! I'm new here on phpfreaks - Here's my problem. I get "1 <br/> 2" echoed, but not the query results. the connect() function connects and selects a table in a mysql database.

Here's the code:
Code: [Select]
<?php
connect();

$query = "SELECT `title`, `body`, `date` FROM `tutorials` ORDER BY `date` DESC" or die ("Query Error");

$counter = 0;

if ($query_run = mysql_query($query)) {

while ($query_row = mysql_fetch_assoc($query_run)) && ($counter <= 2) {
$title = $query_row['title'];
$body = $query_row['body'];
$date = $query_row['date'];
$counter ++;
echo $counter;
echo "<br/>";
echo $title;
echo $body;
echo $date;
}
}
?>
If anyone has any idea, please help! - I'm been battling this for a few hours now

Hello everyone,

I'm a newbie with PHP and mySQL and need some assistance with writing a php script that searches a mySQL database using a form.   The form has five fields that I want to search from and one is a required field (State).  I need to filter or narrow down the search by either two or more fields.  The problem I am having is if I used multiple WHERE clauses using the AND condition I have to enter valid information in all five fields and if I use the OR condition then my search does not produce the desired outcome (too many results).  I "think" I need to use the AND condition but I need to be able to leave some of the fields blank (except for the State field) and narrow my search with using anywhere from 2-5 search fields.

Also, another requirement is to be able to enter partial information in the search field "without" having to enter a wildcard in the search field.  Any assistance is very much appreciated and thanks in advance for your help.

Form Fields:
State                  SELECT FIELD
Lease                 TEXT FIELD
Operator Name   TEXT FIELD
County or Parish TEXT FIELD
Well No               TEXT FIELD

I have a table called well_permits and it is structure is as follows:

date            DATE
state           TEXT
county        VARCHAR
api              VARCHAR
permit_no   VARCHAR
operator      VARCHAR
phone         VARCHAR
contact       VARCHAR
lease           VARCHAR
well_no       VARCHAR
permit_for  VARCHAR
welltype      VARCHAR
wellspot      VARCHAR
lat              FLOAT
lon             FLOAT
depth         VARCHAR

This is what I have for the connecting to my database and selecting the fields:

<?php require_once('../../../Connections/Wldatabase.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

//Variable to store Unique_ID aka API which will be passed to the well-search-results.php page
$var_api_rs_search = $_Get['api'];

$maxRows_rs_search = 20;
$pageNum_rs_search = 0;
if (isset($_GET['pageNum_rs_search'])) {
  $pageNum_rs_search = $_GET['pageNum_rs_search'];
}
$startRow_rs_search = $pageNum_rs_search * $maxRows_rs_search;

$var_state_rs_search = "%";
if (isset($_GET['state'])) {
  $var_state_rs_search = $_GET['state'];
}
$var_lease_rs_search = "%";
if (isset($_GET['lease'])) {
  $var_lease_rs_search = $_GET['lease'];
}
$var_well_no_rs_search = "%";
if (isset($_GET['well_no'])) {
  $var_well_no_rs_search = $_GET['well_no'];
}
$var_operator_rs_search = "%";
if (isset($_GET['operator'])) {
  $var_operator_rs_search = $_GET['operator'];
}
$var_county_rs_search = "%";
if (isset($_GET['County'])) {
  $var_county_rs_search = $_GET['County'];
}
mysql_select_db($database_Wldatabase, $Wldatabase);
$query_rs_search = sprintf("SELECT DISTINCT * FROM well_permits WHERE (well_permits.`state` LIKE %s AND well_permits.county LIKE %s) OR (well_permits.lease LIKE %s) OR (well_permits.operator LIKE %s) OR (well_permits.well_no LIKE %s) ORDER BY well_permits.county", GetSQLValueString($var_state_rs_search, "text"),GetSQLValueString($var_county_rs_search, "text"),GetSQLValueString($var_lease_rs_search, "text"),GetSQLValueString($var_operator_rs_search, "text"),GetSQLValueString($var_well_no_rs_search, "text"));
$query_limit_rs_search = sprintf("%s LIMIT %d, %d", $query_rs_search, $startRow_rs_search, $maxRows_rs_search);
$rs_search = mysql_query($query_limit_rs_search, $Wldatabase) or die(mysql_error());
$row_rs_search = mysql_fetch_assoc($rs_search);
?>

This is my form:

<form action="search.php" method="GET" name="frmsearch" target="_self">

<input name="api" type="hidden" value="" />
<div>

<table width="900" border="0" align="center" cellpadding="2" cellspacing="2">
    <tr>
       <td colspan="6">
           <p style="text-align:left">Select a State then enter at least one search criteria.  State is a required field.</p>
          * Denotes a required field.<br>
   </td>
    </tr>
    <tr>
       <td align="right">* State: </td>
       <td>
          <select name="state" size="1" dir="ltr" lang="en">
     <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MI">MI</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NM">NM</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OS">OS</option>
          <option value="PA">PA</option>
          <option value="SD">SD</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option>
          &nbsp;</select>
      </td>
      <td align="right">County or Parish: </td>
      <td align="left"><input name="County" type="text" value="" size="35" maxlength="40" /></td>
    </tr>
    <tr>
      <td width="63" align="right">Lease: </td>
      <td width="239"><input name="lease" type="text" value="" /></td>
      <td align="right">Well No: </td>
      <td><input name="well_no" type="text" value="" /></td>
    </tr>
    <tr>
      <td width="111" align="right">Operator Name: </td>
      <td width="261"><input name="operator" type="text" value="" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td align="left"><input name="search" type="submit" value="Search" /></td>
  </tr>
</table>
</form>


My Repeat Region starts here


<table width="100%" border="1" align="center" cellpadding="2" cellspacing="2">
  <tr>
    <td align="right">&nbsp;</td>
    <th align="center">Operator</th>
    <th align="center">Lease</th>
    <th align="center">Well Number</th>
    <th align="center">County</th>
    <th align="center">State</th>
  </tr>
  <tr> 
  <?php do { ?>
    <td align="center"><a href="results.php?recordID=<?php echo $row_rs_search['api']; ?>">Select</a></td>
    <td align="left"><?php echo $row_rs_search['operator']; ?></td>
    <td align="left"><?php echo $row_rs_search['lease']; ?></td>
    <td align="center"><?php echo $row_rs_search['well_no']; ?></td>
    <td align="center"><?php echo $row_rs_search['county']; ?></td>
    <td align="center"><?php echo $row_rs_search['state']; ?></td>
  </tr>
  <?php } while ($row_rs_search = mysql_fetch_assoc($rs_search)); ?>
</table>


<p align="center">Number of Wells Located: <?php echo ($startRow_rs_search + 1) ?> to <?php echo min($startRow_rs_search + $maxRows_rs_search, $totalRows_rs_search) ?> of <?php echo $totalRows_rs_search ?></p>


<table border="0" align="center">
  <tr>
    <td align="center"><?php if ($pageNum_rs_search > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, 0, $queryString_rs_search); ?>">First</a>
        <?php } // Show if not first page ?></td>
    <td align="center"><?php if ($pageNum_rs_search > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, max(0, $pageNum_rs_search - 1), $queryString_rs_search); ?>">Previous</a>
        <?php } // Show if not first page ?></td>
    <td align="center"><?php if ($pageNum_rs_search < $totalPages_rs_search) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, min($totalPages_rs_search, $pageNum_rs_search + 1), $queryString_rs_search); ?>">Next</a>
        <?php } // Show if not last page ?></td>
    <td align="center"><?php if ($pageNum_rs_search < $totalPages_rs_search) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, $totalPages_rs_search, $queryString_rs_search); ?>">Last</a>
        <?php } // Show if not last page ?></td>
  </tr>
</table>

Good afternoon all, I'm looking for some help with joins and dates.  Not something I have ever done before so hoping that someone can point me in the right direction.  Here is the code I have just now which works absolutely fine in terms of find the person with the oldest date of birth:

$get_oldest_player = mysql_query("
SELECT 
	P.PlayerDOB AS dob,
	CONCAT(P.PlayerFirstName, ' ', P.PlayerLastName) AS name, 
	P.PlayerID AS id
FROM 
	tplss_players P, tplss_appearances A, tplss_matches M
WHERE 
	P.PlayerID = A.AppearancePlayerID AND
	A.AppearanceMatchID = M.MatchID AND
	M.MatchDateTime = '$matchdate'
ORDER BY
	dob ASC
LIMIT 0,1
",$connection) or die(mysql_error());

Problem is, I have two tables I'm wanting to include in this query, and not entirely sure how I combine them in the search.  I have ONE table for the people (tplss_players) but TWO tables recorded instances of their involvement in matches (tplss_appearances and tplss_substitutions).    Should I use a LEFT JOIN somehow ?  Not sure where it sits in the layout of the query?   tplss_appearances and tplss_substitutions are the same in their structure.     Any help would be greatly appreciated.   Niall

Hi,

I'm using a form which contains many select boxes.
The select boxes looks like this:

            <select name="locatie" id="locatie">
                <option value="" selected>-----</option>
                <?php
                    require_once ('config.php');
                    $query = "select ID, locatie from locatie";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$locatie.'</option>';
                    }
                ?>
            </select>

            <select name="prijsVan" id="prijsVan">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, prijs from prijs";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">&euro; '.$prijs.'</option>';
                    }
                ?>
            </select>

           <select name="prijsTot" id="prijsTot">
             <option value="" selected>-----</option>
         <?php
                            $query = "select ID, prijs from prijs";
                            $result = mysql_query ($query);
             while($row = mysql_fetch_array($result)){
              extract($row);
              echo '<option value="'.$ID.'">&euro; '.$prijs.'</option>';
              }
                         ?>
        </select>

           <select name="ligging" id="ligging">
                <option value="" selected>-----</option>
      <?php
         $query = "select ID, ligging from ligging";
                        $result = mysql_query ($query);
                        while($row = mysql_fetch_array($result)){
              extract($row);
                             echo '<option value="'.$ID.'">'.$ligging.'</option>';
                        }
       ?>
       </select>

           <select name="oppervlakte" id="oppervlakte">
                <option value="" selected>-----</option>
      <?php
         $query = "select ID, oppervlakte from oppervlakte";
                        $result = mysql_query ($query);
                        while($row = mysql_fetch_array($result)){
              extract($row);
                             echo '<option value="'.$ID.'">'.$oppervlakte.' m&#178;</option>';
                         }
       ?>
      </select>

           <select name="kamers" id="kamers">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, kamers from kamers";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$kamers.'</option>';
                    }
                 ?>
      </select>

           <select name="woning" id="woning">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, type from woning";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$type.'</option>';
                    }
                ?>
      </select>

<input type="submit" name="submit" value="Zoeken">

To display the result i'm using a PHP processing page which contains the flowing code:


<?php
......
.....

$locatie = $_POST['locatie'];
$prijsVan = $_POST['prijsVan'];
$prijsTot = $_POST['prijsTot'];
$ligging = $_POST['ligging'];
$oppervlakte = $_POST['oppervlakte'];
$kamers = $_POST['kamers'];
$woning = $_POST['woning'];
$eigenschappen = $_POST['eigenschappen'];

// SHOW LOCATIE
if($locatie !='' && $prijsVan =='' && $prijsTot =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie. "' ORDER BY prijs.ID";   
}

// SHOW LOCATIE_PRIJSVAN
if($prijsVan !='' && $locatie !='' && $prijsTot =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie . "' AND prijs.ID >= '" . $prijsVan . "' ORDER BY prijs.ID";
}

// SHOW LOCATIE_PRIJSTOT
if($prijsTot !='' && $locatie !='' && $prijsVan =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie . "' AND prijs.ID <= '" . $prijsTot . "' ORDER BY prijs.ID";
}

// SHOW PRIJS VAN
if($prijsVan !='' && $locatie =='' && $prijsTot =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID >= '" . $prijsVan . "' ORDER BY prijs.ID";
}

// SHOW PRIJS TOT
if($prijsTot !='' && $locatie =='' && $prijsVan =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID <= '" . $prijsTot . "' ORDER BY prijs.ID";
}

// SHOW PRIJS_VAN_PRIJS_TOT
if($prijsVan !='' && $prijsTot !='' && $locatie =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID BETWEEN '" . $prijsVan . "' AND '" . $prijsTot . "' ORDER BY prijs.ID";
}
 
// SHOW LIGGING
if($ligging !='' && $prijsVan =='' && $prijsTot =='' && $locatie =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND ligging.ID = '" . $ligging. "' ORDER BY prijs.ID";   
}

...................... and so on.........


// Error: indien geen keuze gemaakt show deze error
if($prijsVan =='' && $prijsTot =='' && $locatie =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   ?> <center><font color="#666"> <?php postError(); ?></font></center><?php
}
else{
//Execute query
   $result = mysql_query($query) or die(mysql_error());
         
         while($row = mysql_fetch_array($result)){
           
         echo  $row['image_id'] ;
         echo  $row['locatie'] ;
         echo  $row['prijs'];
         echo  $row['type'];
         echo  $row['kamers'];
         echo  $row['oppervlakte'] . ' m&#178;';
         echo  $row['ligging'];
         echo  $row['eigenschappen'];
      }
}

mysql_close($con);

?>


As you see i have to use many IF condition to display the result of every select combinations.

Is there any way to do it in better way and using less coding?

Thanks.

I have the following code:

$fp = fopen(“path_to_file”, ‘a’);
flock($fp, LOCK_EX);
fwrite($fp, $string);
flock($fp, LOCK_UN);  
fclose($fp);

If I try to lock the file in two different places at the same time, this will cause a race condition. How can I prevent this? I know in Java, for example, it has a concurrent library which contains reentrant lock, which basically tries to get the lock and if can't waits. What can I do in PHP?

Just wanted some general advice/guidance,

I know there are plenty of articles and tutorials online about unit testing, but I just wanted to get a first hand perspective off of some of you guys...

What are some real world examples of actual PHP Unit Testing?

Also any unit testing frameworks you can recommend?

Apologies if this has been covered before.

Hello all,

I have a script uploading files on the server.

I would like to send a confirmation to user if the file had been uploaded well.

Code: [Select]

$targetFile =  str_replace('//','/',$targetPath) . $filename;

move_uploaded_file($tempFile,$targetFile);

if (str_replace($_SERVER['DOCUMENT_ROOT'],'',$targetFile))
{
mail($to, 'upload notification', "Dear Mr/Mrs $fixedname, the file entitled $filename has been successfully uploaded");
}else {
mail($to, ' upload notification', "Dear Mr/Mrs $fixedname, the file entitled $filename has been NOT uploaded");
}

I presume I do something wrong because it doesn't work. The successfull email is sent each time.

Thank you very much for helping,
Eric

Hi, I have a class XMLtool where one of the functions is to output a parameter-passed dom document and then output to the browser screen, so basically:

function outputXML($domDocument) {
   if has attributes
     print cur nodes attributes
   for each child,
      if child is element node
          outputXML(cur node)
      else if child is text
          print text
   end for each
}

Please I am not sure what type of unit tests I can perform. I'd appreciate all the help!