PHP - Display Database Information Into A Box

Hi, Webapp noob here.   I have an application that is going to be data-heavy, so I would like to avoid saving things to the database whenever possible. The application in a nutshell is an android application wired up to a php web app(with MySQL) where you can send requests to the phone and the phone will respond with text or image data with POST.   The normal way to do this would be for the phone to post the data to the database, then have the webapp display it. However, what im wondering is if it is possible for a user on the webapp to request information from the phone, and then when the phone replies using a POST to display the information temporarily in maybe a popup window instead of having to save it to the database.     Thanks!

Hi,

So I am currently making a real estate site for my class at school but I am having a tiny issue with the listing display page.

So what I want to do is show a bunch of listing that the agent owns on their dashboard which I have already done. Now I have two links one to update the listing and one to view the listing. Now what I am trying to do is when the view listing link is clicked it will take the user to the listing-display page and then I want it to display all the information for the listing that the link was clicked under. But i cannot for the life of me figure out how to do that!

 

This is currently the code for the dashboard where you only view the listing headline

<?php

// If the session was never set with a user id
$output = '';
$conn = db_connect();
if($_SESSION['userType'] != AGENT)
{
    $_SESSION['RedirectError'] = "You were not logged in as an Agent<br/>";
    header("Location:login.php");
}
if (isset($_GET["page"])) {
    $page  = $_GET["page"];
    $index = ($page -1) * IMAGE_LIMIT;
}
else {
    $page=1;
    $index = 0;
 }


?>
  <!-- start of main page content -->
  <div class="container" style="margin-top: 2em;">
    <h2>Dashboard</h2>

      <p>Welcome back <?php echo $_SESSION['userId']; ?> you last logged in on <?php echo $_SESSION['last_access']; ?></p>
      <h4>Your Listings</h4>
      <?php
          $sql = "SELECT listing_id FROM listings WHERE user_id = '".$_SESSION['userId']."' AND status = 'o' ORDER BY listing_id";
          $result = pg_query($conn, $sql);
          $listings = pg_fetch_all($result);
          for($index; $index < pg_num_rows($result); $index++)
          {
              $sql = "SELECT * FROM listings WHERE listing_id = '".$listings[$index]['listing_id']."'";
              $listing_result = pg_query($conn, $sql);
              $arrayRow = pg_fetch_assoc($listing_result);
              echo (build_listing_card($arrayRow));
              if($index !=0 && ($index +1) % IMAGE_LIMIT ==0){
                  break;
              }
          }
      ?>
          </div>
          <br/>
          <?php
          $total_pages = ceil(count($listings) / IMAGE_LIMIT);
          $pageLink = "<div class='pagination'>";
          for ($i=1; $i<=$total_pages; $i++) {
                       if($i == $page)
                       {
                          $pageLink .= "<a class='active' href='dashboard.php?page=".$i."'>".$i."</a>";
                       }
                       else {
                           $pageLink .= "<a href='dashboard.php?page=".$i."'>".$i."</a>";
                       }
          };
           ?>
       </div>
       <br/>

and this is the code for the listing-display page where I want all the listing information to be displayed
 

<?php

if (isset($_GET['listing_id']))
    {
        $_SESSION['listing_id'] = $_GET['listing_id'];
    }
    else
    {
        $_SESSION['listing_id'] = 0;
        echo "ERROR: listing information was not find";
    }

    $sql = 'SELECT * FROM listings WHERE listing_id = ' . $_SESSION['listing_id'];
    echo "<BR>".$sql;
    $result = pg_query(db_connect(), $sql);
    $records = pg_num_rows($result);

    echo "<BR>".pg_fetch_result($result, 0, "listing_id");
    echo "<BR>".pg_fetch_result($result, 0, "user_id");
    echo "<BR>".pg_fetch_result($result, 0, "status");
    echo "<BR>".pg_fetch_result($result, 0, "price");
    echo "<BR>".pg_fetch_result($result, 0, "headline");
    echo "<BR>".pg_fetch_result($result, 0, "description");
    echo "<BR>".pg_fetch_result($result, 0, "postal_code");
    echo "<BR>".pg_fetch_result($result, 0, "images");
    echo "<BR>".pg_fetch_result($result, 0, "city");
    echo "<BR>".pg_fetch_result($result, 0, "property_options");
    echo "<BR>".pg_fetch_result($result, 0, "bedrooms");
    echo "<BR>".pg_fetch_result($result, 0, "bathrooms");
    echo "<BR>".pg_fetch_result($result, 0, "garage");
    echo "<BR>".pg_fetch_result($result, 0, "purchase_type");
    echo "<BR>".pg_fetch_result($result, 0, "property_type");
    echo "<BR>".pg_fetch_result($result, 0, "finished_basement");
    echo "<BR>".pg_fetch_result($result, 0, "open_house");
    echo "<BR>".pg_fetch_result($result, 0, "schools");
?>
<h1> Listing Display </h1>
<hr/>
<table style="width:50%" border="1px solid black">
    <tr>
        <th>Listing Image</th>
        <th>Listing Description</th>
    </tr>
    <tr>
        <th rowspan="2">
            <img src="" alt="Oshawa House" width="300px" height="200px"/>
        </th>

        <td align="left" valign="top">
        <h3><?php echo pg_fetch_result($result, 0, "headline")  ?></h3>
        <ul>
        <li>Open house?: <?php echo get_property('open_house', pg_fetch_result($result, 0, "open_house"))?> </li>
        <li>Finished Basement?: <?php echo get_property('finished_basement', pg_fetch_result($result, 0, "finished_basement"))?></li>
        <li><?php echo get_property('purchase_type', pg_fetch_result($result, 0, "purchase_type"))?></li>
        <li>Garage Type: <?php echo get_property('garage_type', pg_fetch_result($result, 0, "garage"))?></li>
        <li>Near school?: <?php echo get_property('schools', pg_fetch_result($result, 0, "schools"))?></li>
        <li>Status: <?php echo get_property('listing_status', strtolower(pg_fetch_result($result, 0, "status"))) ?></li>
        <li>Washrooms: <?php echo get_property('washrooms',pg_fetch_result($result, 0, "bathrooms"))  ?></li>
        <li>Bedrooms: <?php echo get_property('bedrooms',pg_fetch_result($result, 0, "bedrooms"))  ?></li>
        <li>Description: <?php echo pg_fetch_result($result, 0, "description")  ?></li>
        </ul>
        </td>

    </tr>
    <tr>
        <td align="left" valign="top"><ul>
            <li>Location: <?php echo get_property('cities',pg_fetch_result($result, 0, "city"))  ?></li>
            <li>Postal Code: <?php echo pg_fetch_result($result, 0, "postal_code") ?></li>
            <li>Price: <?php echo pg_fetch_result($result, 0, "price") ?></li>
            </ul>
        </td>
    </tr>

</table>
<form action="listing-matches.php">
<p>
<input type="submit" name="submit" value="Back"/></p>
</form>

 

 

I am an extremly novice at this php stuff. I have a file that displays a vehicle listing based on a xml feed. I am trying to add a link to another detail page by clicking on the words Full Detail (bolded below in the code) and send me to another page (index.php?option=com_content&view=article&id=6 (joomla)), the item detail page is based on the vehicle id and has the vehicle details show up. the detail page is also a xml file with the item info. I assume I have to use the <a href.... but how do I add the Id of the vehicle. Do I use a .($_Get['vehicleid']).

Follow me?

Partial Listing of Vehciles

Code: [Select]
$doc = new DOMDocument();
$doc->loadXML($output);
$vehicles = $doc->getElementsByTagName("vehicle");
//print_r($xmlarray);
$results = print_r($xmlarray, true);
echo $results;
foreach ($vehicles as $vehicle) {

    $vehicleIDs = $vehicle->getElementsByTagName("vehicleID");
    $vehicleID = $vehicleIDs->item(0)->nodeValue;
    $years = $vehicle->getElementsByTagName("year");
    $year = $years->item(0)->nodeValue;
    $makes = $vehicle->getElementsByTagName("make");
    $make = $makes->item(0)->nodeValue;
    $models = $vehicle->getElementsByTagName("model");
    $model = $models->item(0)->nodeValue;
    $prices = $vehicle->getElementsByTagName("price");
    $price = $prices->item(0)->nodeValue;
    $modelExts = $vehicle->getElementsByTagName("modelExt");
    $modelExt = $modelExts->item(0)->nodeValue;
    $conditions = $vehicle->getElementsByTagName("condition");
    $condition = $conditions->item(0)->nodeValue;
    $auxPhotoss = $vehicle->getElementsByTagName("auxPhotos");
    $auxPhotos = $auxPhotoss->item(0)->nodeValue;
    $transmissions = $vehicle->getElementsByTagName("transmission");
    $transmission = $transmissions->item(0)->nodeValue;
    $cylinderss = $vehicle->getElementsByTagName("cylinders");
    $cylinders = $cylinderss->item(0)->nodeValue;
    $fueltypes = $vehicle->getElementsByTagName("fueltype");
    $fueltype = $fueltypes->item(0)->nodeValue;
    $doorss = $vehicle->getElementsByTagName("doors");
    $doors = $doorss->item(0)->nodeValue;
    $financings = $vehicle->getElementsByTagName("financing");
    $financing = $financings->item(0)->nodeValue;
    $paymentFrequencys = $vehicle->getElementsByTagName("paymentFrequency");
    $paymentFrequency = $paymentFrequencys->item(0)->nodeValue;
    $kilometerss = $vehicle->getElementsByTagName("kilometers");
    $kilometers = $kilometerss->item(0)->nodeValue;
    $imgSrcs = $vehicle->getElementsByTagName("imgSrc");
    $imgSrc = $imgSrcs->item(0)->nodeValue;
    $formattedprice = sprintf("%01.2f", $price);
    $price_currency = number_format($price, 2, ".", ",");
    if ($price_currency == 0) {
        $price_currency = "CONTACT DEALER";
    }

    $featuress = $vehicle->getElementsByTagName("features");
    $features = $featuress->item(0)->childNodes;
    $featureCount = $features->length;
    $i = 0;
    $featurestring = "";
    while ($i < $featureCount) {
        $i++;
        $featureA[$i] = $features->item($i - 1)->nodeValue;
        $featurestring .= ($i % 2 == 0 ? $featureA[$i] . ", " : "");
    }
   
echo "<table style=background-color: rgb(246, 246, 246)text-align: left width: 900px height: 100px\n";
echo "    border=0 cellpadding=2 cellspacing=2>\n";
echo "    <tbody>\n";
echo "    <tr>\n";
echo "    <td\n";
echo "    style=background-color: black font-family: Helvetica,Arial,sans-serif><small><span\n";
echo "    style=color: yellow><span style=font-weight: bold>Vehicle ID:</span>\n";
echo "    $vehicleID</span></small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 147px><small>Year:\n";
echo "    $year</small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 109px><small>Make:\n";
echo "    $make</small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 141px><small>Model:\n";
echo "    $model</small></td>\n";
echo "    <td\n";
echo "    style=background-color: black font-family: Helvetica,Arial,sans-serif width: 147px><small><span\n";
echo "    style=color: rgb(255, 204, 0) font-weight: bold>Price: $\n";
echo "    $price_currency</span></small></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "    <td colspan=1 rowspan=3><small><span\n";
echo "    style=font-family: Helvetica,Arial,sans-serif><img src=$imgSrc></span></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Condition:\n";
echo "    $condition</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small></small></td>\n";
echo "    </tr>\n";
echo "    <tr width=147\n";
echo "    style=font-family: Helvetica,Arial,sans-serif>\n";
echo "    <small></small><td\n";
echo "    style=background-color: black width: 147px colspan=4 \n";
echo "    rowspan=1><span style=color: rgb(255, 204, 0)><a href=\"http://heavyequipmentwantedads.com/icardemo/inventory/getitems.php?&$vehicleID\" title=\"Full Details (View)\" target=\"_new\">Full Details (View)</a></span></td>\n";
echo "  <small></small></tr>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Transmission\n";
echo "    : $transmission</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small>Doors:\n";
echo "    $doors</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small>FuelType: $fueltype</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>KM:\n";
echo "    $kilometers</small></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "    <td style=background-color: rgb(204, 204, 204)><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Cylinders:\n";
echo "    $cylinders</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small>Features: $featurestring</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small></small></td>\n";
echo "    </tr>\n";
echo "    </tbody>\n";
echo "    </table>\n";

Partial listing of items:

Code: [Select]
<?php
$xmldata ='<dealerAccount>
<accountNum>xxxxxx</accountNum>
<dealerPwd>xxxxxxxxx</dealerPwd>
<data>item</data>
<vehicleID>'.$vehicleID.'</vehicleID>
</dealerAccount>';
$URL = "http://www.wheelsonline.ca/api/";
 
$ch = curl_init($URL);
//curl_setopt($ch, CURLOPT_MUTE, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
curl_setopt($ch, CURLOPT_POSTFIELDS, "$xmldata");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
curl_close($ch);

$doc=new DOMDocument();
$doc->loadXML($output);
$items=$doc->getElementsByTagName("item");
$results = print_r($xmlarray, true);
echo $results;

?>

I have these two files and I need to solve the problem that I need the user data in the role column to be taken when logging in. I have written it so that the data can be extracted from the database, but it does not work for me that it is “forwarded” from process.php to admin.php . Please don’t know what the error is that the admin.php file doesn’t want to load $ _SESSION['Role'] from process.php ? Thanks to everyone for helping and here is the code:

process.php

<?php 
require_once('connect.php');
session_start();
    if(isset($_POST['Login']))
    {
       if(empty($_POST['Username']) || empty($_POST['Password']))
       {
            header("location:index.php?Empty= Please Fill in the Blanks");
       }
       else
       {
            $query="select * from role_test where Username='".$_POST['Username']."' and Password='".md5($_POST['Password'])."'";
            $result=mysqli_query($con,$query);

            if(mysqli_fetch_assoc($result))
            {
                $_SESSION['User']=$_POST['Username'];

                while($row = mysqli_fetch_array($result) ){
                $_SESSION['Role']=$row['role'];
                }

                header("location:admin.php");
            }
            else
            {
                header("location:index.php?Invalid= Please Enter Correct User Name and Password ");
            }
       }
    }
    else
    {
        echo 'Not Working Now Guys';
    }

?>

 

admin.php

<?php
    session_start();

    if(!(isset($_SESSION['User'])))
    {
        header("Location: index.php");
        exit(0);
    }	  

?>
<!DOCTYPE html>
<html>
<head>
<title>Role</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<?php
$_SESSION['Role']=$role;

echo $role;

?>

</body>
</html>