PHP - Stopping Loop Help?

I have below script. it does the while loop 100%. it updates the mysql database one at a time as it should. the problem I have now is that the while loop does not end and go to the next statement as it should. it keeps pollong the database. so when in back end you change to 0 it automatically updates again.

Please see if you can help me to see where I can stop this while loop when there are no more loops

// Here I select the amount of rows

$sql_query = "SELECT ae FROM `debitorderrejectionimport` WHERE ae = '0'"; 
$rowCount = mysqli_query($conn,$sql_query); 
$rowCountUpdate = mysqli_num_rows($rowCount); 
echo $rowCountUpdate; 
while($rowCountUpdate > 0)
{ $sql = "UPDATE `ttee`.`au1` 
INNER JOIN `ttee`.`au` ON (`au1`.`id` = `au`.`id`) 
INNER JOIN `ttee`.`ae1` ON (`ae1`.`idd` = `au1`.`idd`) 
INNER JOIN `ttee`.`debitorderrejectionimport` ON (`debitorderrejectionimport`.`nr` = `ae1`.`id`) 
SET `au`.`amount` = `ae1`.`amount` + `au1`.`amount`, `debitorderrejectionimport`.`ae` = au.id ;"; 

$result = mysqli_query($conn, $sql);
$updated = mysqli_affected_rows($conn); 
$rowCountUpdate - ($updated);}

// if it finished updating and there is no more rows it must continue with below query

mysqli_query($conn, " 
INSERT INTO `sataxicrm754`.`debitorderrejectionimport_back` 
( `Outbound`, `Allocation`, `AccountName`, `QueryComplaintType`,
`QueryStatus`, `Querytypeoption`, `Description`, `DealID`, 
`Deals`, `Assignedusername`, `Teams`, `CampaignName`, `CampaignID`, 
`inserted`, `idnumber`, `nr`, `datew`, `premium`, `policynumber`,
`ContactNumber`, `CollectionType`, `OpportunityAmount`, `Broker`, 
`impref`, `id` ) SELECT `Outbound`, `Allocation`, `AccountName`, 
`QueryComplaintType`, `QueryStatus`, `Querytypeoption`, `Description`, 
`DealID`, `Deals`, `Assignedusername`, `Teams`, `CampaignName`, 
`CampaignID`, `inserted`, `idnumber`, `nr`, `datew`, `premium`, 
`policynumber`, `ContactNumber`, `CollectionType`, `OpportunityAmount`, 
`Broker`, `impref`, `id` FROM `sataxicrm754`.`debitorderrejectionimport` 
WHERE QueryComplaintType <> 'QueryComplaintType' ");

 

I'm writing PHP for my son's cub scout pack.  It populates the MySQL db users table from data contained in a csv file. 
So far, it puts the scout's info in just fine...until I try to run another query as a nested query to retrieve the auto-generated userID for the scout that was just placed in the DB.

The result of this if I don't include the second query--the one trying to get the new userID for that scout, it iterates through the whole file as expected and puts all the scouts in the users table.  The second I uncomment the 2nd query and try to get it to run, it only puts the 1st scout in the DB, properly retrieves the newly generated userID for him, and then stops. 

I need to have this userID for the scout to properly associate that scout with the parents later on and in other sections of this project. 

the db_connect() function just creates the PDO object and contains the username, etc for the connection.  That part is working fine so I'm not posting that function here.

I've tried renaming the connection, query, etc to add "ID" to the end to ensure I wasn't trampling on var names, but that hasn't made a difference


Code: [Select]
//include necessary files:
 include_once("../../sys/php/includes/data_fns.php");
 
 //start session
 session_start();
$conn = db_connect();
$bufferConn = $conn->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);



////////////////////////////////////////
//  Read through the .csv file and populate the users table
/*  Uses the model from the php documentation on fgetcsv:

 *  $row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}

 */
////////////////////////////////////////
$row = 0; //set the row counter
$table1 = "<table id='csvTable'>"; //start the table HTML markup
if(($handle= fopen("../../sys/source/pack238.csv", "r"))!== FALSE) //open the csv file
{
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) //fgetcsv reads through the csv file line by line
{
//ignore the first row which has the header data--we don't want that in the database
if($row==0){$row++; continue;}
$num = count($data);
//get the scout's info, check to see if he's already in the db, then put it in if not--the scout should NOT already be in db when we run this for the first time, but later versions will only add new scouts.  For now, just alert us if they're already in and halt
//TODO  Figure out why this still runs if the table name doesn't exist!!
$query = "SELECT * FROM users WHERE fName=:firstName && lName=:lastName";
$stmt = $conn->prepare($query);
$stmt->execute(array(':firstName'=>$data[1],
    ':lastName'=>$data[0]));
$dbCount=0;
while ($stmt->fetch()){$dbCount++;}
if($dbCount >0) //we found this scout--he shouldn't be in the DB.  Halt the process and check what's going on
{
echo "<br/>The scout, $data[1] $data[0] was found in the database already.  We cannot continue. 
<b/>Please check this duplicate data and try running this setup again";
die();
}
else //he's not in the DB....put him in there
{
//get the Den unit as a number, dropping "Den"
$den = substr($data[10],4);
//get birthday as something to be used as PHP date object
if($data[7]!="")
{
$bdayO = date_create($data[7]);
$now = date_create("now");
$interval = date_diff($bdayO, $now);
$age = $interval->format('%y years');
$bday = $bdayO->format('Y-m-d');
}
else{
$bdayO = NULL;
$bday = NULL;
$age = NULL;
}
echo "<br/> Test message:  The scout $data[1] $data[0], Den:$den would be put into the database!  His bday is:$bday. AGE IS: $age";

$query = "insert into users (gen,fName,lName, nName,memberOf,bday) VALUES ('M',:firstName,:lastName,:nickName,:den,:bday)";
$stmt= $conn->prepare($query);
$stmt->execute(array(':firstName'=>$data[1],
':lastName'=>$data[0],
':nickName'=>$data[3],
':den'=>$den,
':bday'=>$bday));
//get the new userID for this scout now that he's in the db
$connID = db_connect();
$queryID = "SELECT userID from users WHERE fName=:firstName && lName=:lastName";
$stmtID = $connID->prepare($queryID);
$stmtID->execute(array(':firstName'=>$data[1],
':lastName'=>$data[0]));
while ($row = $stmtID->fetch())
{
$scoutUserID = $row[0];
echo "<br/>This scout's userID is: $scoutUserID";
}

}//end else
//get the father's info, check to see if he's already in the db, then put it in if not
//if he is in the db, get this scout's userID number and add it to the father's children array
$query = "SELECT * FROM users WHERE fName=:firstName && lName=:lastName";
$stmt = $conn->prepare($query);
$stmt->execute(array(':firstName'=>$data[18],
    ':lastName'=>$data[19]));
$dbCount=0;
while ($stmt->fetch()){$dbCount++;}
if($dbCount >0) //This father is already in the DB...we need to add this scout to his children array
{
echo "<br/>For testing purposes, this father is already in the DB...let's add this scout, ".$data[1]." to his children array";
//get the userID of the current scout
}
else //he's not in the DB....put him in there
{}
//get the mother's info, check to see if he's already in the db, then put it in if not
//if she is in the db, get this scout's userID number and add it ot the mother's children array
}// end while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) 
}//end if(($handle= fopen("../../sys/source/pack238.csv", "r"))!== FALSE)

The code I am using designed to display the terms I am using in my search.

For example:

.php?description=red&purple&widgets displays red and purple widgets.

However, I am also echoing the terms so people know what they are searching for:

"Your are searching for red and purple widgets"

However, by using the & sign it now displays "Your are searching for red"

If I using .php?description=red%purple%widgets then nothing is displayed.


Code: [Select]
function sanitizeString($description)
{
$description = mysql_real_escape_string($description);
$description = stripslashes($description);
$description = htmlentities($description);
return $var;

I have a script which registers people to a database, however it doing something very strange.  Whenever I place it into even a single CSS div it adds the registration to the dabase but stops loading the next page (index.php)

I find this totally bizarre as I haven't seen anything like this behave before.  With CSS affecting how PHP works.  Especially when the CSS is not inside the <php> of <form> tags.

Code: [Select]
<?php

include("connect.php");

if($_POST['submit']) {
    $username = mysql_real_escape_string(trim($_POST['username']));
    $password = trim($_POST['password']);
    $password2 = trim($_POST['password2']);
    $email = mysql_real_escape_string(trim($_POST['email']));
    $error = false;
    
    if(!isset($username) || empty($username)) {
        $error = "You need to enter a username.";
    }
    $query = mysql_query("SELECT id FROM users WHERE username = '".$username."' LIMIT 1");
    if(mysql_num_rows($query) > 0 && !$error) {
        $error = "Sorry, that username is already taken!";
    }
    
    if((!isset($password) || empty($password)) && !$error) {
        $error = "You need to enter a password.";
    }
    if((!isset($password2) || empty($password2)) && !$error) {
        $error = "You need to enter your password twice.";
    }
    if($password != $password2 && !$error) {
        $error = "The passwords you entered did not match.";
    }
    
    if((!isset($email) || empty($email)) && !$error) {
        $error = "You need to enter an email.";
    }
    if(preg_match("/[a-zA-Z0-9-.+]+@[a-zA-Z0-9-]+.[a-zA-Z]+/", $email) == 0 && !$error) {
        $error = "The email you entered is not valid.";
    }
    $query = mysql_query("SELECT id FROM users WHERE email = '".$email."' LIMIT 1");
    if(mysql_num_rows($query) > 0 && !$error) {
        $error = "Sorry, that email is already in use!";
    }
    
    if(!$error) {
        $query = mysql_query("INSERT INTO users (username, password, email) VALUES ('".$username."', '".mysql_real_escape_string(md5($password))."', '".$email."')");
        if($query) {
            $message = "Hello ".$_POST['username'].",\r\n\r\nThanks for registering! We hope you enjoy your stay.\r\n\r\nThanks,\r\nJohn Doe";
            $headers = "From: ".$website['name']." <".$website['email'].">\r\n";
            mail($_POST['email'], "Welcome", $message, $headers);
            setcookie("user", mysql_insert_id(), $time);
            setcookie("pass", mysql_real_escape_string(md5($password)), $time);
            header("Location: index.php");
        } else {
            $error = "There was a problem with the registration. Please try again.";
        }
    }
}

?><html>

<head>
<title>Register</title>
</head>

<body>
<form action="" method="post">
    <?php if($error) echo "<span style=\"color:#ff0000;\">".$error."</span><br /><br />"; ?>
    <label for="username">Username: </label> <input type="text" name="username" value="<?php if($_POST['username']) echo $_POST['username']; ?>" /><br />
    <label for="password">Password: </label> <input type="password" name="password" value="<?php if($_POST['password']) echo $_POST['password']; ?>" /><br />
    <label for="password2">Retype Password: </label> <input type="password" name="password2" value="<?php if($_POST['password2']) echo $_POST['password2']; ?>" /><br />
    <label for="email">Email: </label> <input type="text" name="email" value="<?php if($_POST['email']) echo $_POST['email']; ?>" /><br /><br />
    <input type="submit" name="submit" value="Register" />
</form>
</body>

I wrote a small application to force downloads of various large video files using readfile. This worked fine. However, the users have changed hosts and now it doesn't work. Small files are fine, but large files will cut off before finishing. Test file is 114MB, but it is always cut off at exactly 67.2MB or 51.4MB depending on a couple criteria.

I've stripped the application down to the key part that's not working and run it on a test page the just immediately goes the file - no logins or any of that shenanigans and htaccess blocking either:

$file = some/file/on/the/server.wmv; //114MB
hea der('Content-Description: File Transfer');
hea der("Content-Type: application/octet-stream");
hea der("Content-Disposition: attachment; filename=" .basename($file));
hea der("Content-Transfer-Encoding: binary");
hea der('Expires: 0');
hea der('Cache-Control: must-revalidate, post-check=0, pre-check=0');
hea der('Pragma: public');
hea der('Accept-Ranges: bytes');
hea der("Content-Length: ".filesize($file));
ob_clean();
flush();
@readfile($file);

(gaps in the header words are to prevent forum breakage)

I've tried the following variations:
transfer encoding - chunked (this results in getting a 51.4 MB download rather than 67.2) content-type application/force-download tried the default force-download code from the php.net manual tried the chunking function variations on php.net readfile page tried without accept ranges originally (only spotted that on this site) set_time_limt to one hour set max memory to 300MB (phpinfo has shown these changes did get accepted) used htacess to disable gzip and deflate (this results in getting a 51.4 MB download rather than 67.2)
(SetEnv no-gzip dont-vary
or
RewriteEngine On
RewriteRule . - [E=no-gzip:1]
or
RemoveOutputFilter DEFLATE html txt xml css js php wmv)
None of these have solved the issue. The code worked fine on the old site, works fine on my site, and works fine on my test server. Direct downloads from the broken site also work fine, just not readfile downloads. The filesize is reading correctly if I echo just that, and it reads properly on the progress bar when downloading through readfile.

The hosting company are blaming my coding. The htaccess is the bit I'm least sure of and I find it hard to get solid info on this part on the web.

Is there anything wrong with my code that could be causing this? Am I missing something? What could be causing the problem?

Many Thanks