PHP - Nested If Statements Causing Error

I am trying to dynamically create a form where I pass a table name and it presents me with a table of all the columns (varying number and names of columns) into an HTML table.  Both of my queries are working, but for some reason, my nested while statements are not working.

Any ideas?

function getLuTableBody($lu_tableName) {
    $tableBodyHtml ="";

    $tableColumns=getTableColumns($lu_tableName);
    $tableData=getTableData($lu_tableName);

    if ($tableData->num_rows > 0) {
        while($row = $tableData->fetch_assoc()) {
            if ($tableColumns->num_rows > 0) {
                $tableBodyHtml .= "<tr>";
                while($column = $tableColumns->fetch_assoc()) {
                    $columnName=$column['COLUMN_NAME'];
                    $tableBodyHtml .= "<td>$row[$columnName]<td>";
                }
                $tableBodyHtml .= "</tr>";
            } else {
                echo "problem with column data";
                }
            }
    } else {
        echo "problem with record data";
        }
    return $tableBodyHtml;
}

 

Here's the contents of the db

id	bundleRole	recordStatus
1	Database	A
2	Web			A
3	Base		A
4	Application	A
5	Print		A

Here's the output

 

<table id="advanced_table" class="table dataTable">
	<thead>
		<tr>
        	<th>Record ID</th>
          	<th>Bundle Role</th>
          	<th>Record Status</th></tr>
  		</thead>
    	<tbody>
			<tr>
            	<td>1</td>
              	<td></td>
              	<td>Database</td>
              	<td></td>
              	<td>A</td>
              	<td></td>
        	</tr>
  		</tbody>
</table>

 

Edited June 13, 2020 by pizote
added detail

 
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>");
   ?>

I found a script online that I am trying to get working. It was giving a 500 error from the get go and I've pinpointed it to the $data = fread() line. Does anyone know why?

<?php
$file 

= "../../media/v_360.m4v";
$filesize 

= filesize($file);
$offset 

= 0;
$length 

= $filesize;

if (isset($_SERVER['HTTP_RANGE']))
{

// if the HTTP_RANGE header is set we're dealing with partial content

$partialContent = true;

// find the requested range

// this might be too simplistic, apparently the client can request

// multiple ranges, which can become pretty complex, so ignore it for now

preg_match('/bytes=(\d+)-(\d+)?/', $_SERVER['HTTP_RANGE'], $matches);

$offset = intval($matches[1]);

$length = intval($matches[2]) - $offset;
}
else
{

$partialContent = false;
}


$file = fopen($file, 'r');

// seek to the requested offset, this is 0 if it's not a partial content request
fseek($file, $offset);
$data = fread($file, $length);

/*
fclose($file);

if ($partialContent)
{

// output the right headers for partial content

header('HTTP/1.1 206 Partial Content');

header('Content-Range: bytes ' . $offset . '-' . ($offset + $length) . '/' . $filesize);
}

// output the regular HTTP headers
header('Content-Type: ' . $ctype);
header('Content-Length: ' . $filesize);
header('Content-Disposition: attachment; filename="' . $fileName . '"');
header('Accept-Ranges: bytes');

// don't forget to send the data too
print($data);
*/
?>


Its trying to read a 60mb file. Do you think it is timing out and that is causing the error?

Hello there

 

I'm really struggeling with my prepared statement. I want to get the number of unread PMs to show at the user's homepage. Can someone help me with some explanation about my code? I don't really know what I'm doing yet. I've read a lot of code about prepared statements, but I still can't figure it out. 

public function count_unread_pm() {
        if($stmt = $this->db->prepare("SELECT unread FROM pm WHERE unread=1")) {

            /* Bind parameters, s - string, b - blob, i - int, etc */
			$stmt->bindParam(':unread', $id, PDO::PARAM_INT); 
            $stmt -> execute();

            var_dump($stmt); // no output 

            /* Bind results */
            $stmt -> bind_result($test); // Error: call to undefined method 

            /* Fetch the value */
            $stmt -> fetch();
            $numberofrows = $stmt->num_rows;

            /* Close statement */
            $stmt -> close();
        }
        var_dump($numberofrows); // no output 

    }

Edited September 16, 2019 by Fabel

Okay, I have no idea how this works out but this is really getting on my nerves.

Here is my logic for the following code. I manually register a user, It goes into the database and dispatches an email notification explaining that a user must activate their account and change their user name (OPTIONAL) and password. In the email, There is an automatically generated password with the username, And a link to activate the account. This leads to stage 1 of the activation process, In this stage the user is accepted, Registered as a verified user and then is sent to another page to change the details like login and password. As far as I know this page works except through trial and error I found that this little snippet of code is causing browsers to show an error 500 page, If I remove this the page works:

<?php
if($messages){

displayErrors($messages);
} else {

echo("<p align=\"center\" class=\"standard\">Your account has been activated.</p><p align=\"center\" class=\"standard\">You now need to change your password. If you like you can also change your username, Remember that you only have 3 days to do so and this change will be permanent.</p>");
}
?>

and this is the displayErrors function:

<?php
function displayErrors($messages) {

print("<p align=\"center\" class=\"standard\">"."<b>There were problems with the previous action:</b>\n<ul>\n");

foreach($messages as $msg){

print("<li>$msg</li>\n");

}

print("</ul>\n"."</p>");
}
?>


The displayErrors function is in a file called functions.php, Which is included in config.php, Which is included in every page including this one.

The entire "Change password and login page thingie" is he


<?php
include("config.php");
global $link, $messages;
require_once('recaptchalib.php');
if($_GET['error']){

$id=$_GET['id'];

$messages[]="There is more than one or no accounts with the verification code you are using. <a href=\"mailto:rentals@nivso.co.uk?subject=Two or no accounts with activation ID of $id\">Click here to email us about this and have the problem sorted.</a>";

doIndex();

exit;
}
if(isset($_POST['submit'])){

if(!isset($_POST['activationid'])){

die("Doesn't exist -.- might as well quit this is *STUFF* -.-");

}

$privatekey = "YOUR NOT HAVING THIS";

$resp = recaptcha_check_answer ($privatekey,

$_SERVER["REMOTE_ADDR"],

$_POST["recaptcha_challenge_field"],

$_POST["recaptcha_response_field"]);

if (!$resp->is_valid) {

$messages[]="The code you entered is incorrect. Please go back and try again!";

doIndex();

exit; // exit or the below lines will be processed.

} else {

//This is where the fun starts!

$login=$_POST['login'];

$passw=$_POST['password'];

$passc=$_POST['passwordc'];

$id2=$_POST['activationid'];

$changinglogin=false;

$get1=excDB("SELECT * FROM `users` WHERE `activeID`='$id2'");

if($get1[0]){ $get1=$get1[1]; } else { die($get1[2]); }

$pro1=mysql_fetch_array($get1);

if($pro1['login']!=$login){

$changinglogin=true;

field_validator("Login", $login, "alphanumeric", 4, 15);

}

field_validator("Password", $passw, "string", 6, 20);

if($passw!=$passc){

$messages[]="The passwords do not match, Please make sure that the passwords are the same!";

}

if($messages){

doIndex();

exit;

}

$passcl=mysql_escape_string($passw);

$passen=md5($passcl);

if($changinglogin){

$wri1=excDB("UPDATE `users` SET `login`='$login', `password`='$passen', `passchange`='1', `loginchange`='1' WHERE `activeID`='$id2';");

if($wri1[0]){ $wri1=$wri1[1]; } else { die($wri1[2]); }

header("Location: login.php?created");

} else {

$wri1=excDB("UPDATE `users` SET `password`='$passen', `passchange`='1', `loginchange`='0' WHERE `activeID`='$id2';");

if($wri1[0]){ $wri1=$wri1[1]; } else { die($wri1[2]); }

header("Location: login.php?created2");

}

}
} else { 

doIndex();
}
function doIndex(){
?>
<!DOCTYPE html>
<head>
<title>Family Rental System! - Rent your DVDs here - Design by Alex, Coding by Gergy008</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link type="text/css" href="css/main.css" rel="stylesheet">
<style type="text/css">
<!--
body {

background-color: #333333;
}
-->
</style></head>
<body style="text-align:center;">
<div class="first">
<div class="backgrounder1"></div>
<div class="headerbar1"></div>
<div class="headerbar2"></div>
</div>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="900">
  <tr>
   <td><img src="images/spacer.gif" width="52" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="123" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="352" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="33" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="55" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="110" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="110" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="50" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="15" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>

  <tr>
   <td colspan="9" background="images/template.slice.1.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="20" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="5" background="images/template.slice.2.png">&nbsp;</td>
   <td colspan="2" rowspan="2" background="images/template.slice.3.png"><span class="login"><?php echo(loginHandler()); ?></span></td>
   <td colspan="2" rowspan="3" background="images/template.slice.4.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td>
  </tr>
  <tr>
   <td rowspan="8" background="images/template.slice.5.png">&nbsp;</td>
   <td colspan="2" background="images/template.slice.6.png"><form>
     <div align="center">
       <input name="textfield" type="text" id="textfield" size="40" style="height:16px;">
       <input type="submit" name="button" id="button" value="Search" style="height:20px;">
     </div>
   </form></td>
   <td colspan="2" rowspan="2" background="images/template.slice.7.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="2" rowspan="3" background="images/template.slice.8.png"><p>&nbsp;</p>
    <p>&nbsp;</p></td>
   <td colspan="2" background="images/template.slice.9.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="70" border="0" alt="" /></td>
  </tr>
  <tr>
   <td rowspan="2" background="images/template.slice.10.png">&nbsp;</td>
   <td colspan="4" background="images/template.slice.11.png">&nbsp;</td>
   <td rowspan="6" background="images/template.slice.12.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" background="images/template.slice.13.png"></td>
   <td><img src="images/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
   <td rowspan="4" background="images/template.slice.14.png">&nbsp;</td>
   <td colspan="4" background="images/template.slice.15.png">&nbsp;</td>
   <td colspan="2" rowspan="4" background="images/template.slice.16.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="35" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" background="images/template.slice.17.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="37" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" align="center" valign="top" background="images/template.slice.18.png" style="vertical-align:top;"><p class="standard">&nbsp;</p>
     <table width="80%" border="0">
      <tr>
        <td colspan="2">
          <?php
          

if($messages){

//displayErrors($messages);

} else {

//echo("<p align=\"center\" class=\"standard\">Your account has been activated.</p><p align=\"center\" class=\"standard\">You now need to change your password. If you like you can also change your username, Remember that you only have 3 days to do so and this change will be permanent.</p>");

?></td>
        </tr>
      <form name="ChangeDetails" method="post" action="<?=$_SERVER['PHP_SELF']?>">
      <input type="hidden" name="activationid" value="<?php if($_GET['id']){ $id=$_GET['id']; echo($id); } elseif($_POST['activationid']){ $id=$_POST['activationid']; echo($id); } else { die("No ID") } ?>" />
      <tr>
        <td width="50%"><div align="right" class="standard">New Username: </div></td>
        <td width="50%"><input name="login" type="text" id="login" size="35" maxlength="30" /></td>
      </tr>
      <tr>
        <td><div align="right" class="standard">New Password:</div></td>
        <td><input name="password" type="password" id="password" size="35" maxlength="30" /></td>
      </tr>
      <tr>
        <td><div align="right" class="standard">Re-enter password:</div></td>
        <td><input name="passwordc" type="password" id="passwordc" size="35" maxlength="30" /></td>
      </tr>
      <tr>
        <td><div align="right" class="standard">Please enter the code: </div></td>
        <td>

<?php

require_once('recaptchalib.php');

$publickey = "6Le4fsESAAAAAKMOHb8aaiyDfGRJyr0y0EU7dXm-"; // you got this from the signup page

echo recaptcha_get_html($publickey);
            ?>
        </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td><input type="submit" name="submit" id="submit" value="Change your details" /></td>
      </tr>
      </form>
    </table>
     </td>
   <td><img src="images/spacer.gif" width="1" height="450" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" background="images/template.slice.19.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="50" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="9" background="images/template.slice.20.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="40" border="0" alt="" /></td>
  </tr>
</table>
</div>
</body>
</html>
<?php
} ?>


Thanks to all you kind people that take your time to read and help me with this problem. I'm sorry if it is a really simple problem I missed out that makes me look like a right idiot and wasted your time, but that's me I'm always missing stuff out like that, I do proof read though just sometimes not good enough.

Thanks in advance!