PHP - Need Help Outputting Html With Nested Php

Hi there i have a basic query that is simply not outputting, i just dont get it. Im pretty sure the query is sound. If you can spot anything wrong here please let me know.

Code: [Select]
$colname_RecordSet1 = "-1";
if (isset($_SERVER['MM_Username'])) {
  $colname_RecordSet1 = (get_magic_quotes_gpc()) ? $_SERVER['MM_Username'] : addslashes($_SERVER['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_resultp = sprintf("SELECT PlayerName, PlanetName, Class1, Class2, Class3, Class4 FROM planet WHERE PlayerName = %s", GetSQLValueString($colname_RecordSet1, "text"));
$resultp = mysql_query($query_resultp, $swb) or die(mysql_error());
$row_resultp = mysql_fetch_assoc($resultp);
$totalRows_resultp = mysql_num_rows($resultp);

<?php  do { 
echo 'Class: ';
echo $row_resultp['PlanetName'];
echo $row_resultp['Class1'];
echo $row_resultp['Class2'];
echo $row_resultp['Class3'];
echo $row_resultp['Class4'];

?>
  <?php } while ($row_resultp = mysql_fetch_assoc($resultp)); 

mysql_free_result($resultp); ?>
 
Thanks

I'm doing the following query where "ctext" comes from the clues table and "answerid" and "atext" come from the answers table...

Code: [Select]
$sql = "SELECT * from clues, answers
WHERE clues.quizid = '{$_GET['quizid']}'
AND answers.quizid = '{$_GET['quizid']}'";
$result = mysql_query($sql, $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
} else {

while ($info=mysql_fetch_array($result)) {

echo "<tr><td>" . $info['answerid'] . "</td>";

echo "<td>".$info['ctext']."</td>";

echo "<td>".$info['atext']."</td>";

}
echo "</tr>";
}
}
But when this displays in the browser, it's outputting each result set twice and kinda mixed up.  For example, it looks like this...

1 monkey funny
1 cat funny
2 monkey boring
2 cat boring

But I want (i.e. was expecting) it to display as...

1 monkey funny
2 cat boring

Can anyone tell me why it's showing TWO rows for each and seemingly mixing  up the returned results?

Ultimate question is this.  Do I have to break apart the mysql queries in order to get PHP to display the results how I want?  I gotta think there is a way to do just one query and do what I want, but I obviously can't figure it out

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

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?

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

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

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? 

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 />";
}

This topic has been moved to Third Party PHP Scripts.

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

Hello guys. I am facing a little problem on my website when I am trying to output the data from the database in the form of a table. If you go to http://sigmalogistix.com/track-trace/ and enter any on of the following B/L No's:

123456789
987651234
543216789

You can see that the table is being created but the data is not being shown to the user. If I switch back to the old code in which there was no table, then the data is being shown to the user upon entering the B/L No. Please help me guys. Attached below are the codes which I have inside the function.inc.php file and the index.php file.

function.inc.php

Code: [Select]
<?php
include 'db.inc.php';
function search_results($keywords) {
  $returned_results = array();
  $where = "";
  $keywords = preg_split('/[\s]+/', $keywords);
  $total_keywords = count($keywords);
foreach($keywords as $key=>$keyword){
        $where .= "`keywords` LIKE '%$keyword%'";
    if ($key != ($total_keywords - 1)) {
    $where .= " AND ";
     }
  }
  $results = "SELECT `Bill_No`, `Origin_City`, `Origin_Country`, `Destination_City`, `Destination_Country`, `Status`, `Current_Location` FROM `billoflading` WHERE $where";
  $results_num = ($results = mysql_query($results)) ? mysql_num_rows($results) : 0;
  if ($results_num === 0) {
    return false;
}   else {
    while ($results_row = mysql_fetch_assoc($results)) {
      $returned_results[] = array (
                'Bill_No' => $results_row['Bill_No'],
                'Origin_City' => $results_row['Origin_City'],
                'Origin_Country' => $results_row['Origin_Country'],
                'Destination_City' => $results_row['Destination_City'],
                'Destination_Country' => $results_row['Destination_Country'],
                'Status' => $results_row['Status'],
                'Current_Location' => $results_row['Current_Location']
     );
   }
  
   return $returned_results;
  }
  }
?>
index.php

Code: [Select]
<?php include 'func.inc.php'; ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
       "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>search</title>
</head>
<body>
<form action="" method="POST">
    <p>
        <input type="text" name="keywords" size="17" maxlength="9" value="Enter B/L No." onfocus="if(this.value == 'Enter B/L No.'){this.value = '';}" /> <input type="submit" class="formbutton" value="Track" />
    </p>
</form>
<?php
if  (isset($_POST['keywords'])) {
 $suffix = "";
 $keywords = mysql_real_escape_string(htmlentities(trim($_POST['keywords'])));
$errors = array();
if (empty($keywords)) {
  $errors[] = '';
 } else if (strlen($keywords)<9) {
  $errors[] = '<br><strong>Your Bill of Lading Number must contain 9-digits.</strong>';
 } else if (search_results($keywords) === false) {
  $errors[] = '<br><strong>Please enter a valid Bill of Lading Number.</strong>';
 }
if (empty($errors)) {
   $results = search_results($keywords);
   $results_num = count($results);
   $suffix = ($results_num !=1) ? 's' : '';
   foreach($results as $result) {
     echo '<br><table>
    <thead>
        <tr>
            <th><strong>B/L No.</strong></th>
            <th><strong>Origin City</strong></th>
            <th><strong>Origin Country</strong></th>
            <th><strong>Destination City</strong></th>
            <th><strong>Destination Country</strong></th>
            <th><strong>Status</strong></th>
            <th><strong>Current Location</strong></th>
        </tr>
    </thead>
    <tbody>
    <?php
    while ($row = mysql_fetch_assoc($results) {
    ?>
        <tr>
            <td><?php echo $row["Bill_No"]; ?></td>
            <td><?php echo $row["Origin_City"]; ?></td>
            <td><?php echo $row["Origin_Country"]; ?></td>
            <td><?php echo $row["Destination_City"]; ?></td>
            <td><?php echo $row["Destination_Country"]; ?></td>
            <td><?php echo $row["Status"]; ?></td>
            <td><?php echo $row["Current_Location"]; ?></td>
        </tr>
    <?php
    }
    ?>
    </tbody>
</table>';
 }
 } else {
   foreach($errors as $error) {
    echo $error, '</br>';
  }
 }
}
?>
</body>
</html>

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.

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%

Hi All,

I have done a select from my DB and the data contains a '.

echo "<td><a class='btn btn-primary col-sm-12' data-toggle='modal' data-userid='" . $uid . "' href='#userModal' data-firstname='" . $ufn ."' data-lastname='". $uln."' data-email='" . $ue . "' data-accountlevel='" . $ualid . "' data-mobile='".$um ."'data-role='".$urid."' data-active-sheets='".$ename."'>Manage</a></td>";

outputs

<a class="btn btn-primary col-sm-12" data-toggle="modal" data-userid="2" href="#userModal" data-firstname="Chelsea" data-lastname="Hockley" data-email="chelsea@hotmail.com" data-accountlevel="1" data-mobile="0774882" data-role="1" data-active-sheets="A new event,Chelsea" s="" event'="">Manage</a>

the issue part

data-active-sheets="A new event,Chelsea" s="" event'=""

Should be

data-active-sheets="A new event,Chelsea's event"

How do i prevent the ' from causing me this issue?

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 everyone

I have 2 queries which are pulling out results into arrays
I think they are right
I then insert a new column into each array one with [typeofdonation] as "cash" and one as "card" this is to be used later when outputting the results

I then need to combine the 2 arrays into 1 array and then sort the combined array by date showing the latest ones first
I then need to output the top 3 results
The way the results are outputted is dependant on what [typeofdonation] is as they are outputting and styled differently

Here is my code below I have got upto the combining the 2 arrays but am having difficulty doing this
Once I have done this I then need to sort the results but I think my code I have tested on each array works ok and so will work once I have the combined array.
Final part I am not sure on how to find and use what is in [typeofdonation] to determine the styling and way each of the 3 results is outputted

Thankyou in advance for everyone who can hopefully help me in the right direction
Peter

Code: [Select]
<b>Card Donations</b><br><br>
<?php 
$getcarddonations =  $wpdb->get_results("SELECT wp_supporters_donations.SFMemberNumber, wp_supporters_donations.KickbackAmount, wp_supporters_donations.MerchantName, wp_supporters_donations.SpendDate from supporter_2_cause RIGHT JOIN wp_supporters_donations ON supporter_2_cause.supp_id=wp_supporters_donations.SFMemberNumber WHERE supporter_2_cause.caus_id = '54' ORDER BY wp_supporters_donations.SpendDate");
//UNION SELECT id, amout, cause, date FROM cashdepo WHERE cause='Lisas charity' AND status='2' ORDER BY id DESC
foreach($getcarddonations as $getcarddonations){
$i = 0;
while($i < 100) {
$data[$i]['member'] = $getcarddonations->SFMemberNumber;
$data[$i]['ammount'] = $getcarddonations->KickbackAmount;
$data[$i]['merchant'] = $getcarddonations->MerchantName;
$data[$i]['date'] = $getcarddonations->SpendDate;
$data[$i]['typeofdonation'] = 'card';
$i++;
}
}

function compareItems($a, $b)
{
if ( $a->date < $b->date ) return -1;
if ( $a->date > $b->date ) return 1;
return 0; // equality
}

uasort($data, "compareItems");
print_r( $data );
?>
<br><br><br><b>Cash Donations</b><br><br>
<?php
$getcashdonationsdb = $wpdb->get_results("SELECT * FROM cashdepo WHERE cause='Lisas charity' AND status='2' ORDER BY id DESC");
foreach($getcashdonationsdb as $getcashdonationsdb){
$i = 0;
while($i < 11) {
$dataa[$i]['member'] = $getcashdonationsdb->id;
$dataa[$i]['ammount'] = $getcashdonationsdb->amout;
$dataa[$i]['merchant'] = $getcashdonationsdb->cause;
$dataa[$i]['date'] = $getcashdonationsdb->date;
$dataa[$i]['typeofdonation'] = 'cash';
$i++;
}
}

uasort($dataa, "compareItems");
print_r( $dataa );

?>
<br><br><br>
<b>Combined</b><br><br>
<?php 
$datar1 = ($data);
$datar2 = ($dataa);
$finalarray = array_combine($datar1, $datar2);

//sort
uasort($finalarray, "date");

//Print the output
print_r($finalarray);
?>