PHP - Php Dom-document And Xpath : Fetch Class Data

Hi

I have the following code works well

However, if there is more than one record in the search result it shows the table lables on every record rather than just the one

is it possible to have the table lables for just the result headings and not on each line after

<?php
 require "header.php";
?>

<main>
	<link href="style.css" rel="stylesheet" type="text/css">

  <div class="wrapper-main">

        <div class="welcomelogged1">
          <p>Searching For A Starter<p>                  
        </div>
        <form action="" method="post">
        	<select name="WeekComm" id="WeekComm">
			<option value="Enter Week No To Search">Enter Week No To Search</option>
			<option value="WC 6th April">WC 6th April</option>
			<option value="WC 13th April">WC 13th April</option>
			<option value="WC 20th April">WC 20th April</option>
			</select>
			<input type="submit" name="Search" value="Search Starters">
        </form>

 <?php

$dBServername = "localhost";
$dBUsername = "root";
$dBPassword = "";
$dBName = "CandidateManagement";

mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);


$conn = mysqli_connect($dBServername, $dBUsername, $dBPassword, $dBName);


if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

if (isset($_POST['Search'])) 
{
	$WeekComm = $_POST['WeekComm'];

	$query = "SELECT * FROM contract where WeekComm='$WeekComm' ";
	$query_run = mysqli_query($conn,$query);

	while($row = mysqli_fetch_array($query_run))
	{
		?>
			<form action="" method="POST">
				<table>
					<Tr><td><label></label></td>
						<td><label>Week Commencing</label></td>
						<td><label>First Name</label></td>
						<td><label>Last Name</label></td>
						<td><label>Start Date</label></td>
						<td><label>Client Name</label></td>	
						<td><label>Action</label></td>						
					</Tr>
					<tr>
				<td><input type="hidden" name="id" value="<?php echo $row['id'] ?>"></td>
				<td><input type="text" name="WeekComm" value="<?php echo $row['WeekComm'] ?>"></td>
				<td><input type="text" name="FirstName" value="<?php echo $row['FirstName'] ?>"></td>
				<td><input type="text" name="LastName" value="<?php echo $row['LastName'] ?>"></td>
				<td><input type="date" name="StartDate" value="<?php echo $row['StartDate'] ?>"></td>
				<td><input type="text" name="ClientName"value="<?php echo $row['ClientName'] ?>"></td>
			</tr>
			</form>
		<?php
	}

			}

 

I have attached a picture to show what i mean

 

 

 

Thanks

Hi,

I am quite new to PHP and to learn more about it I decided I would make a little project to easy my life a little bit

I want to make a site that fetches lunch menus from the restaurants nearby my work. I would just like some help getting pointed in the right direction on how to make this happen

Thanks!

Br,
Niklas

Hi,

I am trying to fetch all data from database.
but any data show  twice.

like this:

Ali
Ali
30
30
Osman
Osman
20
20
Omer
Omer
40
40
Salim
Salim
10
10
Suzan
Suzan
25
25


$mem_qry = "SELECT * FROM tbl_name";
$res = mysql_query($mem_qry);

function mysql_fetch_all($res) {
   $return = array();
   while($row=mysql_fetch_array($res)) {
       $return[] = $row;
   }
   return $return;
}

$all = mysql_fetch_all($res);
foreach($all as $k=>$v) {
foreach($v as $k2=>$v2){
echo $v2.'<br />';
}
}

There is a school locator script at https://www.ocps.net/parents/pages/FindaSchool.aspx
When we input any address it returns schools located in that locality.

For example:

Use these details and submit the form

Street Number : 3902
Street Name   : Bobolink
Street Type   : Lane
City         : Orlando


It returns a row having three schools Elementary,Middle and High school
On clicking the more button it takes to the respective school details
So for each school I need the respective school names

Audobon Elementary
Glenridge Middle
Winter Park High

Please suggest some ways to achieve this functionality


Thanks



_________________________________________________ ____________________
http://travelinfo.techserveglobal.com/
http://blog.techserveglobal.com/

<html>
<title>Micro Elite Brigade - Participated Events</title><LINK REL="SHORTCUT ICON" HREF="images/favicon.png"><?php
require_once('upper.php');
if($_COOKIE['LoginIdCookie']){
require_once('database.php');
require_once('LoginStatement.php');
$LoginId=$_COOKIE['LoginIdCookie'];
$query="select * from participation where LoginId='$LoginId'";
$result=mysqli_query($dbc,$query) or die ('Not Connected');
//echo "<div class='search_output_data'>
echo "<table border='0' cellspacing='0' cellpadding='0'>";
echo "<tr><th align='left' valign='top' width='100' height='20'>Event Title</th>
<th align='right' valign='top' width='250' height='30'>Date of Participation</th>
</tr>";
while($row=mysqli_fetch_array($result))
{

echo "
<tr><td colspan='4' align='left' valign='top' ><table align='left' border='0' cellspacing='0' cellpadding='0'><tr><td align='left' valign='top'  width='200' height='20'>".$row['Title']."</td> <td width='50'>&nbsp;</td> <td align='left' valign='top' width='130'>".$row['Date']."</td> </tr></table>
</td></tr>";
}
echo "</table>";}
else{ echo 'Sorry, You must have to login.';}
require_once('lower.php');

?>


HI friends.....
I have a table named events in which I have a "Title" column.
When I print the value of Title column, it not displayed not more than 40 characters....
Where is the problem ???
Anyone??????

I am new in PHP Programming , Please Help me.

I have made a data table, then i have connected this table after that  I have made a table in my index.php file . but i am facing problem to show data from data table in my index.php file, can you help me to solve this problem?

 

<?php include "db.php"; ?>

<!doctype html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">

    <title>Post Global Variable</title>
</head>

<body>

    <div class="row p-5">
        <table class="table table-dark">
            <thead>
                <tr>
                    <th scope="col">#</th>
                    <th scope="col">Name</th>
                    <th scope="col">User Name</th>
                    <th scope="col">Email Address</th>
                    <th scope="col">Password</th>
                    <th scope="col">Phone</th>
                    <th scope="col">Join Date</th>
                    <th scope="col">Action</th>
                </tr>
            </thead>
            <tbody>


                <?php
            
            $myQuery = "SELECT * FROM users";
            $allUsers = mysqli_query ($db, $myQuery);
      
            while ($row = mysqli_fetch_assoc($allUsers)){
                
                $id= $row['id'];
                $name= $row['name'];
                $userName= $row['userName'];
                $email= $row['email'];
                $password= $row['password'];
                $phone= $row['phone'];
                $join_date= $row['join_date'];
                
               
                ?>

                <tr>
                    <th scope="row"><?php echo $id; ?></th>
                    <td><?php echo $name; ?></td>
                    <td><?php echo $userName; ?></td>
                    <td><?php echo $email; ?></td>
                    <td><?php echo $password; ?></td>
                    <td><?php echo $phone; ?></td>
                    <td><?php echo $join_date; ?></td>
                    <td><a class="btn btn-success btn-sm" href="#" role="button">Update</a>
                        <a class="btn btn-danger btn-sm" href="#" role="button">Delete</a>
                    </td>
                </tr>

                <?php
                
            }
      
        ?>

            </tbody>
        </table>
    </div>



    <!-- Optional JavaScript -->
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
</body>

</html>

 

Edited March 3, 2020 by MH90

//my controller
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

class homeController extends Controller
{
    public function index() {
        
        $employee = DB::table('employee')->orderBy('id','desc')->get();
        
        $department = DB::table('department')->orderBy('id','desc')->get();

    	return view('index', ['employee' => $employee , 'department' => $department]);
    }
}

//my routes

Route::get('index','homeController@index');

//my view using blade temmplating engine
@foreach($employee as $emp)
<div class="employee">
  <b>{{ $emp->name }} </b>
  <a href="employee/{{ $emp->id }}">
	<p class="intro">{{ substr($emp->intro ,0, 50) }}...</p>   
  </a>
</div>
@endforeach

@foreach($department as $dep)
<div class="department">
  <b>{{ $dep->name }} </b>
  <a href="department/{{ $dep->id }}">
	<p class="desc">{{ substr($dep->description ,0, 100) }}...</p>   
  </a>
</div>
@endforeach

I want to fetch using ajax, how can i do it, teach/help me

Hi,

 I want to make the phone number in the below code as clickable. Below is the code php and mysql code I used.

 

    <?php  
    $connect = mysqli_connect('localhost', 'root', '1234', 'contact');  
    $query ='SELECT * FROM tbl_employee ORDER BY ID DESC';  
    $result = mysqli_query($connect, $query); 
    ?>

   

<table id="employee_data" class="table table-striped table-bordered">
                <thead>  
                <tr>  
                <td>Name</td>  
                <td>Location</td>  
                <td>Department</td>  
                <td>Phone Number</td>  
                </tr>  
                </thead>  
                          <?php  
                          while($row = mysqli_fetch_array($result))  
                          {  
                               echo '  
                               <tr>  
                                    <td>'.$row["name"].'</td>  
                                    <td>'.$row["location"].'</td>    
                                    <td>'.$row["department"].'</td>  
                                    <td>'.$row['phone_number'].'</td>
                  
                               </tr>  
                               ';  
                          }  
                          ?>  
</table>

 

I want to reuse the data from getFaq for different levels of a website. 

$fcid is the variable. 
 

Creating the full page in the getFaq function could work but limits the function to one set of results,

Do I need to create a new function if I want to create another page with the data and a new call to the database?

It seems to me there must be a way to store the array from $fcid  and call it from another page to get a subset of the data. 

I added the getFP class as an attempt to do just that but I am getting no results. 

If I place the code in the getFP class in the getFAQ function the script works as envisioned. 

I want to create a getFAQpage, a getFAQheader and a getFAQsubset based on  categories. 

The data is all there in $fcid but I have no idea on how to access it from outside the class. 

Dbh is the PDO connection. 

 

Class GetData extends Dbh {
	
			
		public function getFaq($site) {
			$sql = "SELECT faq_cats.faqc_name, faqs.faq_question, faqs.faq_answer FROM faq_cats INNER JOIN faqs ON faq_cats.faqc_id = faqs.faq_cat WHERE faq_cats.faqc_site = ? ORDER BY faq_cats.faqc_name";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute([$site]);
			$fcid = $stmt->fetchAll();
			return $fcid;	
		}

	}

	Class getFP extends GetData {

		
		public function getFaqPage([$fcid]) {
			
			$fcid = $this->fcid;
			$fhead = null;		
				foreach ($fcid as $faq) {
					$fname = $faq["faqc_name"];			
					$fquest = $faq["faq_question"];
					$fans = $faq["faq_answer"];
					
						if ($fhead != $fname) {
							echo "<h2>".$fname."</h2>";
						}
	
					echo $fquest."<br />".$fans."<br /><br />";
					$fhead = $fname;
				}
		}
	

	}
	
	
	$faqob = new getFP(); 
	$faqob->getFaqPage([$fcid]);

 

I'm new to OOP and trying to write tiny classes to get practice.

The next class I want to create will be used to clean HTTP data from when a form gets submitted.

I'm embarrassed to say, but I'm scratching my head trying to figure out what types of things I should do as far as "sterilizing" POST and GET data?!   

Can someone get me started here?

Thanks,


TomTees

Hello, my first post here.

I created a Validation class that depends entirely on static methods. It appears to be working well, but perhaps I misunderstood exactly the purpose and the consequences of using static methods.

My class essentially looks like this:


class Validate
{
static public $errors  = array();
static public $valid   = array();

static public function Name($name)
{
if ($name != '')
{
self::$valid['name'] = $name;
return true;
}
                                else
                                {
                self::$errors['name'] = 'Name is empty';
                return false;
                                 }
}
}


Does this create any chance whatsoever for a collision of data from multiple users? I am beginning to think it does, simply because from what I have recently learned about static methods, theyr'e essentially global variables because they are not instantiated. If that's the case, then it would seem possible that during times of heavy use, any application depending on this class would confuse submitted data.

Any thoughts?

Thanks in advance.

I need to set up a threaded comments system in a PHP project and I got this script shown below from http://www.jongales....#comment-436261

class Threaded_comments
{
    
    public $parents  = array();
    public $children = array();

    /**
     * @param array $comments 
     */
    function __construct($comments)
    {
        foreach ($comments as $comment)
        {
            if ($comment['parent_id'] === NULL)
            {
                $this->parents[$comment['id']][] = $comment;
            }
            else
            {
                $this->children[$comment['parent_id']][] = $comment;
            }
        }        
    }
   
    /**
     * @param array $comment
     * @param int $depth 
     */
    private function format_comment($comment, $depth)
    {   
        for ($depth; $depth > 0; $depth--)
        {
            echo "\t";
        }
        
        echo $comment['text'];
        echo "\n";
    }
    
    /**
     * @param array $comment
     * @param int $depth 
     */ 
    private function print_parent($comment, $depth = 0)
    {   
        foreach ($comment as $c)
        {
            $this->format_comment($c, $depth);

            if (isset($this->children[$c['id']]))
            {
                $this->print_parent($this->children[$c['id']], $depth + 1);
            }
        }
    }

    public function print_comments()
    {
        foreach ($this->parents as $c)
        {
            $this->print_parent($c);
        }
    }
  
}

Here’s the example usage with the data provided as an array:

$comments = array(  array('id'=>1, 'parent_id'=>NULL,   'text'=>'Parent'),
                    array('id'=>2, 'parent_id'=>1,      'text'=>'Child'),
                    array('id'=>3, 'parent_id'=>2,      'text'=>'Child Third level'),
                    array('id'=>4, 'parent_id'=>NULL,   'text'=>'Second Parent'),
                    array('id'=>5, 'parent_id'=>4,   'text'=>'Second Child')
                );

$threaded_comments = new Threaded_comments($comments);

$threaded_comments->print_comments();

I have a sample select query that pulls data from a database and stores the result in the $comments array as shown below. The $comments array is then passed as an argument to the $threaded_comments object:

$sql = 'SELECT * FROM test_comments';
// submit the query and capture the result
$result = $conn->query($sql);
$comments = array();
while ($row = $result->fetch_assoc()) {
    $comments[] = $row;
}

The challenge is that nothing is printed to the screen when I run the script. Inspection of the comments array with the var_dump function is shown below:

array (size=4)
  0 => 
    array (size=3)
      'id' => string '1' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  1 => 
    array (size=3)
      'id' => string '2' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  2 => 
    array (size=3)
      'id' => string '3' (length=1)
      'parent_id' => string '1' (length=1)
      'text' => string 'comment ' (length=8)
  3 => 
    array (size=3)
      'id' => string '4' (length=1)
      'parent_id' => string '3' (length=1)
      'text' => string 'comment ' (length=8)

I was wondering if the array format from my select query is the issue? Could anyone provide a clue as to how to fix this?   Thanks.
Edited by terungwa, 11 January 2015 - 05:07 PM.

Hi...

I have query in highlighting null data using this code:

Code: [Select]
<?php

include 'config.php';

$currentEmpID = $_SESSION['empID']; 
 
 if(!isset($_POST['Regsubmit_'])){ 
     
    $DATE1 = $_GET['Regfirstinput'];
    $DATE2   = $_GET['Regsecondinput'];
 
 $sql = "SELECT DISTINCT IF(ISNULL(a.LOG_IN), 'rdc', '') AS LOGIN_CLASS, IF(ISNULL(a.LOG_OUT), 'rdc', '') AS LOGOUT_CLASS, a.EMP_ID, CONCAT(LASTNAME, ', ' , FIRSTNAME) AS FULLNAME, a.LOG_IN, a.LOG_OUT
 FROM $ATTENDANCE.attendance_build AS a JOIN $ADODB_DB.employment em ON (a.EMP_ID = em.EMP_NO AND em.STATUS IN ('Reg Operatives', 'Reg Staff')) 
 WHERE LOG_IN BETWEEN '$DATE1' AND '$DATE2' 
 OR ISNULL(LOG_IN) OR ISNULL(LOG_OUT)";
 
    $DTR = $conn3->GetAll($sql);
    $smarty->assign('attendance', $DTR);
 }
 $smarty->display('header_att.tpl');
 $smarty->display('RegAttendance.tpl');
 $smarty->display('footer.tpl');
?>

and here is the tpl code:

Code: [Select]
{section name=att loop=$attendance}
  <tr>
    <td colspan="2">{$attendance[att].EMP_ID}</td>
    <td colspan="2">{$attendance[att].FULLNAME}</td> 
    <td colspan="2" class="{$attendance[att].LOGIN_CLASS}">{$attendance[att].LOG_IN|date_format:"%d-%m-%Y %I:%M %p"}</td>
    <td colspan="2" class="{$attendance[att].LOGOUT_CLASS}">{$attendance[att].LOG_OUT|date_format:"%d-%m-%Y %I:%M %p"}</td>
  </tr>
{sectionelse}
  <tr><td colspan="1">No DATA</td></tr>
{/section}

this code highlight the null value of login or logout or both.

this is the css:
Code: [Select]
.rdc {background-color:#ff0000;}

Now, I need to revised my query statement, because i have separate code for adding attendance if the employee has no attendance or no login or no logout.

I just want to happen is if the employee is already add his attendance in NRS table or should I said if the LOG_IN in attendance table is equal to TIME_IN in NRS table the data will have a color yellow.

For Example:

I have this data in attendance table:

EMP_ID = 012012
LOG_IN = NULL
LOG_OUT = 2011-12-12 13:35:00

I will his attendance in NRS table to have his attendance:

EMP_NO = 012012
TIME_IN = 2011-12-12 05:35:00
TIME_OUT = 2011-12-12 13:35:00



In my above query the LOG_IN has a background color of RED.

I want to happen is if I add his attendance in NRS the EMP_NO, LOG_IN, LOGOUT will have a color to notice that it is already have in NRS.

Because theirs a scenario that the employee has no login or no logout or both.


Feel free to ask me if my explanation is not clear to you.

Thank you in advance

My parser:
<?php        
if (isset($_GET['formSubmit'])) {
$option = $_GET['option'];
$option = array_values($option);
if (!empty($option)){
$xml = simplexml_load_file('differences.xml');
$i = 0;
$count = count($option); ?>
<table>
<tr>
<td>Item</td>
        <td>Code</td>
        <td>Type</td>
        <td>Level</td>
    </tr>
<?php
while($i < $count)
{
$selected = $xml->xpath("//item[contains(@name,'".$option[$i]."')]");
echo "<tr>";
echo "<td>".$selected[0]['name']."</td>";
echo "<td>".$selected[0]['code']."</td>";
echo "<td>".$selected[0]['type']."</td>";
echo "<td>".$selected[0]['requiredLevel']."</td>";
echo "</tr>";
$i++;
} ?>
 </table>


This works great however requiredLevel is showing nothing. Here is what is stored in the $selected array:


Array ( [0] => SimpleXMLElement Object ( [@attributes] => Array ( [buildingName] => EiffelTower [code] => lM [type] => building ) [requiredLevel] => 5 [cost] => 5000 [built] => 03/31/1889  => SimpleXMLElement Object ( [@attributes] => Array ( [itemClass] => EiffelTower_construct ) ) [defaultItem] => SimpleXMLElement Object ( [@attributes] => Array ( [amount] => 1 [name] => iron ) ) [finishedReward] => iron [image] => Array ( [0] => SimpleXMLElement Object ( [@attributes] => Array ( [loadClass] => mc [name] => construct_0 [url] => /buildings/eiffel_tower.swf ) ) [1] => SimpleXMLElement Object ( [@attributes] => Array ( [loadClass] => mc [name] => construct_1 [url] => /buildings/eiffel_tower.swf ) ) [2] => SimpleXMLElement Object ( [@attributes] => Array ( [loadClass] => mc [name] => built_0 [url] => /buildings/eiffel_tower.swf ) ) [3] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => icon [url] => buildings/eiffel_tower.png ) ) [4] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => startIcon [url] => /buildings/eiffel_tower.png ) ) [5] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => halfIcon [url] => /buildings/eiffel_tower.png ) ) [6] => SimpleXMLElement Object ( [@attributes] => Array ( [name] => completeIcon [url] => /buildings/eiffel_tower.png ) ) ) [constructionUI] => /buildings/Construct_eiffel_tower.swf [countryCard] => france )


My XML:


<element>
<item code="lM" name="snowman2010" type="building">
<requiredLevel>5</requiredLevel>
<cost>5000</cost>
<built>03/31/1889</built>
<storageType itemClass="EiffelTower_construct"/>
<defaultItem amount="1" name="iron"/>
<finishedReward>iron</finishedReward>
<image loadClass="mc" name="construct_0" url="/buildings/eiffel_tower.swf"/>
<image loadClass="mc" name="construct_1" url="/buildings/eiffel_tower.swf"/>
<image loadClass="mc" name="built_0" url="/buildings/eiffel_tower.swf"/>
<image name="icon" url="/buildings/eiffel_tower.png"/>
<image name="startIcon" url="/buildings/eiffel_tower.png"/>
<image name="halfIcon" url="/buildings/eiffel_tower.png"/>
<image name="completeIcon" url="/buildings/eiffel_tower.png"/>
<constructionUI>/buildings/eiffel_tower.swf</constructionUI>
<countryCard>france</countryCard>
</item>


Using the established code pattern in my parser.php how can I print out requiredLevel?

The output of my array is mighty confusing! [/code]