PHP - Query Not Outputting

At the moment I have multiple pages with different HTML tables coded in (some have 5 columns and some 6 etc) and PHP echoing out data to populate from the database. The table in each page holds different data. It looks messy to me to code a different table for every page so I'm wondering if it's possible to create a function to do this? The function would have to print tables with different amounts of columns and echo out different data depending on what the page is along with table headers etc. How would I go about that? 

I have converted xml into an array with no problems, however I'm having difficulty outputting the various attributes.

Here is a sample:

Code: [Select]
[0] => Array
                        (
                            [@attributes] => Array
                                (
                                    [YourId] => 1082-1
                                    [Name] => Woodwards Metals
                                    [Description] =>
                                 )
 
                        )
The bit that is confusing me is the @attributes part. How would I output the 'Name' element for example?

Hi guys,

I am very simply inserting text into a table with php and mysql, and outputting it, it all works fine but when I use paragraphs when inserting it, and then try to ouput it, all the paragraphs are gone and it looks like one big block of text, I suppose the way to go around this is to use <br> instead of just enters as it probably doesnt read this, but is it possible to make this text area do read and insert <br>'s where people use enter to make paragraphs?

Much help appreciated, I realize this must be a very beginner question but I am not really sure how to word this so I wasn't sure on specific search on this.

On my website, I have Sticky Forms that use the following style code...

<input id="firstName" name="firstName" type="text" maxlength="30"
value="<?php if(isset($firstName)){echo htmlspecialchars($firstName, ENT_QUOTES);} ?>" /><!-- Sticky Field -->




Do I need to use htmlspecialchars($firstName, ENT_QUOTES); anytime I output data to the screen??


For example, in this code do I need to wrap $username??

echo ' <div class="userInfo">
<a href="#" class="username">
<strong>' . $username . '</strong>
</a>';



Debbie

Hi All,

I'm working on an X-Cart site. Looking through the pages, any page with an apostrophe in the content is being loaded as an � instead.

The sites' char set is UTF-8. Changing it to ISO then creates an issue in itself with bulleted lists. Just wondering if anyone has had the problem in the past and if they have solved it?

Any help appreciated.

Cheers

This topic has been moved to Third Party PHP Scripts.

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

What is the proper way to output the contents of a class?

(We will assume that Getters and Setters are evil...)

Let's say I have the following class...

   class FormHandler2 {
      // Define Variables.
      private $myFormArray;

      // Constructor.
      public function __construct($param){
         $this->myFormArray = $param;
      }
   }

...and I want to be able to output its contents either via a variable dump OR by printing something to the screen.

How would I do that?



TomTees

Hello guys i am doing a search function whereby users can check whether a setting is Pass or Fail. After user press the search button, it will return the file which contain the settings the user wants. However i have encountered a problem, currently i am using if statement and && operator to search for file so if the file is missing a string whereby the preg_match function couldn't find it, it will not output the file if i check another setting. Hence i am interested on what other options can i use.

Also, Is it possible to use while loop? I tried for awhile and my browser just keeps loading and loading.

Thanks for the help!




Example: I want to check File 1 for Maximum Password Age settings but it does not contain Service Pack Requirement string...








if ((preg_match("/\bService Pack Requirement:(.*)./", $allFiles)) && (preg_match("/\bMaximum Password Age Requirement:(.*)./", $allFiles))
&& (preg_match("/\bMinimum Password Length:(.*)./", $allFiles)) && (preg_match("/\bAudit Account Logon Events:(.*)./", $allFiles))
{
echo "<a href=\"$file\" target=\"_blank\"> $file </a><br />";
}

Hi   I have a self calling script which does the following:   Stage 1: First run, it detects that $_POST is empty, and so displays a chunk of html which prompts for a password. Stage 2: When resubmitted, it detects $_POST and displays another chunk of html which prompts the user for some values Stage 3; When resubmitted the second time, $_POST is detected, along with the user values and some php is executed and a menu displayed.   So, question is this, what is the best method to output the html at stage 1 and stage 2? I have tried using echo statements and wrapping each chunk in a function = messy.  I have tried using HEREDOCS (<<<VARNAME), better but ties my HTML to my script which is a pain I am thinking to use file_get_contents("../html/chunk1.htm") this seems quite elegant and allows me to get someone else on our team to design the HTML keeping it out of my script   Thoughts and suggestions?   Thanks as ever   p.s. who pays for this site, are donation accepted?

I am trying to load all rows from a table in a database into a table on a webpage. I cannot understand why the following code does not work:
Code: [Select]
<?php ...
echo "You are currently in a fleet. The details of the fleet are below.<br>";
$fleetName = $_SESSION['charFleetName'];
$sqlFleetDetails = "SELECT * FROM `$fleetName`";
$queryFleetDetails = mysql_query($sqlFleetDetails);
echo "<table>";
echo "<tr>";
echo "<th>Pilot</th>";
echo "<th>Ship</th>";
echo "<th>Type</th>";
echo "</tr>";
while($rowFleetDetails = mysql_fetch_array($queryFleetDetails)) {
$charId = $rowFleetDetails['charId'];
$charName = $rowFleetDetails['charName'];
$shipHull = $rowFleetDetails['shipHull'];
$shipType = $rowFleetDetails['shipType'];
echo "<tr>";
echo "<td><a href=\"#\" onClick=\"CCPEVE.showInfo{1377, " . $charId . "}>" . $charName . "</a></td>";
echo "<td>" . $shipHull . "</td>";
if($shipType == 1)
echo "<td>Logistics</td>";
if($shipType == 2)
echo "<td>DPS Boat</td>";
if($shipType == 3)
echo "<td>Sniper 120Km+</td>";
if($shipType == 4)
echo "<td>Off-grid Booster</td>";
echo "</tr>";
}
echo "</table><br>";
I originally had the $rowFleetDetails['charId'] and others in the echo instead of loading them into variables then echoing the variables but changed it to see if that was working, neither is. If I add an extra line outside of the while loop to echo the output of the array then the information is displayed fine, so I know that the information is being transferred from the table into the array correctly, but why is it not outputting properly in the While loop?

hope to input the below data via $_POST into a while loop to preg_split by comma and then recursively create xml element tag with the various firstName lastName's and even separate further aliasFirstName aliasLastName's into an attribute field

NAMES: firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName]



$xml .= '

<element1 attribute="' . $_POST('AGE') . '">';

while ($row = ' . $_POST('NAMES') . ')
{
$row = preg_split('/[\s]*[,][\s]*/',' . $_POST["Actors"] . ',PREG_SPLIT_OFFSET_CAPTURE);


$xml .= '
<element2>
  <NAME names="' . $_POST('NAMES') . '" alias="' . $_POST('NAMES') . '"></NAME>

$xml .= '';

Hi, I'm having issues trying to add up the totals of each product type in a while loop- I'm sure it's straightforward to fix but for some reason I can't find a way to get it to add up all the totals of the various product types and list them so we have say 5 of product 1, 11 of product 2, 8 of product 3 and so on.

So firstly the user searches between two different dates / times to get the orders made during that time period: (I'm using separare date and time fields as the datetime-local input doesn't work in a lot of browsers)

if($_POST['search'])
{
    $searchdate1 = mysqli_real_escape_string($conn, $_POST['_Date1']);
    $searchdate2 = mysqli_real_escape_string($conn, $_POST['_Date2']);
    
    $searchtime1 = mysqli_real_escape_string($conn, $_POST['_Time1']);
    $searchtime2 = mysqli_real_escape_string($conn, $_POST['_Time2']);
    
    $datetime1 = $searchdate1 . ' ' . $searchtime1;
    $datetime2 = $searchdate2 . ' ' . $searchtime2;
    
    $nicedate1 = date("l F j, Y", strtotime($searchdate1) ); //Just used for readability in the report
    $nicedate2 = date("l F j, Y", strtotime($searchdate2) );

//Now get the orders from the db

$getorders = $oc_conn->query("SELECT * FROM oc_order WHERE date_added >= '$datetime1' AND date_added <= '$datetime2' AND order_status_id != 0 ORDER BY order_id DESC");

//Then generate start of a table in HTML, the while loop that follows will populate the rows

while ($row = $getorders->fetch_assoc()) { //Get the order data

          $firstname = $row["firstname"];
          $lastname = $row["lastname"];
          $fullname = $firstname . ' ' . $lastname;
        $orderid = $row["order_id"];
        $orderdate = $row["date_added"];    
          $email = $row["email"];
        $total = $row['total'];
          $total = number_format($total, 2);
            
        $niceorderdate = date('F j, Y H:i', strtotime($orderdate));    
            
             echo '<tr><td>'.$fullname.'</td><td>'. $orderid . '</td><td>';
    
            $getproducts = $oc_conn->query('SELECT * FROM oc_order_product WHERE order_id = '.$orderid); //Product names and details are held in a separate table
        
                while ($row = $getproducts->fetch_assoc()) {
                    
                    $orderproductid = $row["order_product_id"];
                    $productname = $row["name"];            
                    $quantity = $row["quantity"];
                    echo $quantity . ' x '.$productname.' <br>'; //This works for each individual order, but what I need is the total $quantity of each $productname, across ALL orders in the time range
                
                }
            echo '</td><td>'. $niceorderdate.'</td></tr>';           
        }
    echo '</tbody></table>';
}
?>

[/PHP]

As mentioned in the comment above, what I need is the total $quantity of each $productname, across ALL orders in the time range, so that I can see how many of each product ($productname) were ordered in total.

I tried using SUM for quantity in the mySQL, and COUNT for adding up the different product names but for some reason it didn't work. Can someone let me know what I need to do? Thanks :)

 

 

Below is my code:
   

    Code: [Select]
  function outputModule($courseId, $courseName, $moduleId, $moduleName, $sessionData)
    {
   
        if(!count($sessionData))
        {
            return false;
        }
   
        $markTotal = 0;
        $markGrade = 0;
        $weightSession = 0;
        $grade = "";
        $sessionsHTML = "";
   
        foreach($sessionData as $session)
        {
   
            $sessionsHTML .= "<p><strong>Session:</strong> {$session['SessionId']} <strong>Session Mark:</strong> {$session['Mark']}</strong> <strong>Session Weight Contribution</strong> {$session['SessionWeight']}%</p>\n";
            $markTotal += round($session['Mark'] / 100 * $session['SessionWeight']);
            $weightSession  += ($session['SessionWeight']);
            $markGrade = round($markTotal /  $weightSession * 100);
                 
            if ($markGrade >= 70)
            {
                $grade = "A";
            }
   
            else if ($markGrade >= 60 && $markGrade <= 69)
            {
                $grade = "B";
            }
   
            else if ($markGrade >= 50 && $markGrade <= 59)
            {
                $grade = "C";
            }
   
            else if ($markGrade >= 40 && $markGrade <= 49)
            {
                $grade = "D";
            }
   
            else if ($markGrade >= 30 && $markGrade <= 39)
            {
                $grade = "E";
            }
   
            else if ($markGrade >= 0 && $markGrade <= 29)
            {
                $grade = "F";
            }
    }
   
    $courseHTML = "<p><br><strong>Course:</strong> {$courseId} - {$courseName}</p><br>\n";
        $moduleHTML = "<p><strong>Module:</strong> {$moduleId} - {$moduleName} <strong>Module Mark:</strong> {$markTotal} <strong>Mark Percentage:</strong> {$markGrade} <strong>Grade:</strong> {$grade} </p>\n";
   
        return $courseHTML . $moduleHTML . $sessionsHTML;
    }
   
    $output = "";
   
    $studentId = false;
    $courseId  = false;
    $moduleId  = false;
   
    while ($row = mysql_fetch_array($result))
    {
   
      if($courseId != $row['CourseId'])
        {
   
            //Course has changed
            $courseName  = $row['CourseName'];
            $courseId = $row['CourseId'];
   
            $output .= outputModule($courseId, $courseName); 
        }
   
        if($moduleId != $row['ModuleId'])
        {
   
            //Module has changed
            if(isset($sessionsAry)) //Don't run function for first record
            {
   
                //Get output for last module and sessions
                $output .= outputModule($courseId, $courseName, $moduleId, $moduleName, $sessionsAry);
            }
   
            //Reset sessions data array and Set values for new module
   
            $sessionsAry = array();
            $moduleId    = $row['ModuleId'];
            $moduleName  = $row['ModuleName'];
        }
             
        //Add session data to array for current module
             
        $sessionsAry[] = array('SessionId'=>$row['SessionId'], 'Mark'=>$row['Mark'], 'SessionWeight'=>$row['SessionWeight']);
             
    }    //Get output for last module
   
    $output .= outputModule($moduleId, $moduleName, $sessionsAry);
   
    //Display the output
    echo $output;
Below is the output:


    Notice: Undefined variable: sessionData in /web/stud/u0867587/Mobile_app/student_overall_grade.php on line 69
   
    Notice: Undefined variable: sessionData in /web/stud/u0867587/Mobile_app/student_overall_grade.php on line 69
   
    Course: INFO101 - Bsc Information Communication Technology
   
   
    Module: CHI2550 - Modern Database Applications Module Mark: 41 Mark Percentage: 68 Grade: B
   
    Session: AAB Session Mark: 72 Session Weight Contribution 20%
   
    Session: AAE Session Mark: 67 Session Weight Contribution 40%

There is suppose to be another module with its own sessions below this but it does not show it. Also it is giving me notices that $SessionData is undefined. Why can it not find the variable $SessionData?

Below is what it should of outputted:

Course: INFO101 - Bsc Information Communication Technology Course Mark Grade
Year: 3


Module: CHI2550 - Modern Database Applications Module Mark: 41 Mark Percentage: 68 Grade: B

Session: AAB Session Mark: 72 Session Weight Contribution 20%

Session: AAE Session Mark: 67 Session Weight Contribution 40%


Module: CHI2513 - Systems Strategy Module Mark: 31 Mark Percentage: 62 Grade: B

Session: AAD Session Mark: 61 Session Weight Contribution 50%

Hello, this is my first post here.   I am trying to output the rows of a certain query in sequence after a POST has been requested.   I have been successful in getting the output in a pure php file but when I try to implement this in a web page with html/css, I can't echo the array in arbitrary locations after the post has processed.   This is the code which outputs successfully in a pure php file, but I need it to work in a <textarea> field as the results of a search

$rows2 = array();
$rows3 = array();
while($stmt->fetch()){
$rows2[] = $stratoparse;
$rows3[] = $date;
}
 $search = array();
for($i=0;$i<=$num_rows;$i++){
echo $rows3[$i].'&nbsp;'.$rows2[$i].'<br>'.'<br>';
}
}

To further iterate what I am asking. When errors are stored, you write something like

$errors['username']="A username is required.";

Then in any location of a webpage I can call this or show it, provided by this

<?php isset($errors['username']) ? $errors['username']:" ");?>

That is the same thing I am trying to do with this array which can be an arbitrary count of rows...   I have not been successful in getting this to work... I have been told of string concatenation...   I don't know what to do       Thank you for any help    

Hi,
It's been a while since I've been on here...

I've got a script that takes an image url and resizes it, then outputs it to the screen (using image headers etc).
I've then got a htaccess file that changes my nice url, such as:
'images/thumb/50-70/logo.jpg'
to:
'incudes/resize.php?width=50&height=70&img=logo.jpg'

Which is the resize script, so I can use a nice url in img tags.

The width and height are just the maximum allowed, so sometime the image will be smaller.

Now, this all works correctly, but I am now trying to find out the width and height of the thumbnailed image, from outside of the resize.php script.
I thought that I could use getimagesize, but this doesn't seem to work...

I first tried it using the 'nice' url: '/images/thumb/50-70/logo.jpg'
Thinking that .htaccess would re-direct, but no. I then tried a direct link to the resize file:
'/incudes/resize.php?width=50&height=70&img=logo.jpg'
But that returns a file not found error... Although I can access the file directly.

Trying the direct url without the get variables, however, successfully finds the file, but it doesn't seem to be able to detect the image dimensions.
I just get a blank result..


Is PHP able to recognise htaccess re-directs?
Is PHP able to parse a php file that outputs as an image? (I have all the correct headers etc set!)


Thanks