PHP - How Can I Show The Data Detail In Php From Mysql

Hi I am trying to select and order data/numbers from a colum in a mysql data base however i run the code and it returns no value just a blank page no errors or any thing so i think the code is working right but then it returns no result? Please help thanks

Here is the code:

<?php
$host= "XXXXXX";
$mysql_user = "XXXXXX";
$mysql_password = "XXXXXX";
$mysql_database = "XXXXXXX";

$connection = mysql_connect("$host","$mysql_user","$mysql_password") or die ("Unable to connect to MySQL server.");
mysql_select_db($mysql_database) or die ("Unable to select requested database.");

$row = mysql_fetch_assoc( mysql_query( "SELECT XP FROM Game ORDER BY number DESC LIMIT 1" ) );
$number = mysql_result(mysql_query("SELECT XP FROM Game ORDER BY number DESC LIMIT 1"), 0);

echo "The the highest XP is $number";

?>

i am doing a little project but I get stuck on a problem. How do I show the content of my SQL database in PHP or HTML. I want it to show the title at the top, the text in the middle and maybe a price at the bottom. How do I do that?  I can't seem to find a tutorial which covers only that, and I don't have the time to search each tutorial for some usefull information right now. And a second thing I want is that it will show the database in one list on a specific webpage. So people can look trough the list and find the thing they want and than click on it so they awill get directed to that item from the database.

I want to show data for logged in user, i am using sessions to login. This is the code i already have:
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");



//this selects everything for the current user, ready to be used in the script below

$result = mysql_query("SELECT id, points, ingame_points, ingame_money, ingame_items FROM members;
WHERE username = $_SESSION['myusername']");

//this function will take the above query and create an array
while($row = mysql_fetch_array($result))
  {

 //with the array created above, I can create variables (left) with the outputted array (right)
$points = $row['points'];
$id = $row['id'];
$ingame_points = $row['ingame_points'];
$ingame_money = $row['ingame_money'];
$ingame_items = $row['ingame_items'];
  }


Help  ?

Hi, I have this script that returns the entire table including column names and the row data. However I only want certain column names and the corresponding data to be returned.

Code: [Select]
<?php

include_once("data/mysql.php");

$mysqlPassword = (base64_decode($mysqlpword));

$db = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die ("Error connecting to database");

mysql_select_db("$dbname", $db) or die ("An error occured when connecting to database");


// sending query

$result = mysql_query("SELECT * FROM members");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<h1>Table: members</h1>";
echo "<table border='1'><tr>";
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}

mysql_query($result);

?>
Any help is always appreciated

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

php can detect "mac address", "ip address", "browser agent", "cookie" and "hostname". What else php can detect?

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;

?>

Hello,

I have a database with the following tables:

students       groups          exams           examDay      relation         master             detail
=======     =====          =====         =======     ======        ======          =====
idStudent    idGroup           idExam         idExDay        idRelation      idMaster          idDetail
idGroup       groupName     examName   exDate         idGroup          idGroup           idMaster
studName                                                                   idExDay          idRelation        idExam
                                                                                   idExam           idStudent
                                                                                   coursesAtt      idExDay

I am trying to make a report from the Master and Detail tables that will have the table header like this:

Group | Examination Date | Student Name | Exam1 | Exam2| .... | Exam n

in which Exam1, Exam2,... are the exams names and they had to take the values from coursesAtt column.

Is this possible? I could make a view (doing joins and group by) by the results will be displayed on row. That's why I ask for your help.

Thanks

I want to create a master-detail page using PHP. Rather than getting data from a MYSQL database, I want to get the data from an associative array. Is this possible? Please someone show me the way forward. Please help.

This is my code is display my database (member_details) after user sign up but when a user register first name = <script>window.location="google.com"</script>  This error occur=(The requested URL /yy2/html/google.com was not found on this server)

Code: [Select]
<?php
  session_start();
  include ('includes/database_connection.inc.php');
$conn = connectDatabase();

  if($_SESSION['uid'] == ''){
    // redirect unauthenticate user to login page.
  header('Location: login.php');
  }

  if($_GET['task'] == 'delete' && $_GET['id'] != ''){
      // delete function here
     $sql="DELETE FROM Newest Where ID='".mysql_real_escape_string($_GET['id'])."'";
     
     mysql_query($sql,$conn);
     header('Location: member_list.php');
  }

  if($_POST['Logout']){
     session_destroy();
   header('Location: login.php');
}

?>

<html><head><title>Member Details</title>
</head>
<body>
<div style=" margin: 350px ">
<?php 


      $sql="SELECT * FROM Newest";
      $rs = mysql_query($sql,$conn)
        or die( mysql_error() );

   
   $list = "<table border=\"1\" cellpadding= \"2\">";
   $list .= "<tr><th>First Name</th>";
   $list .="<th>Last Name</th>";
   $list .= "<th>User Name</th>";
   $list .= "<th>Email</th>";
   $list .= "<th>Edit User</th>";
   $list .= "<th>Delete User</th>";
    $list .= "<th>Change Password</th>";
   

While( $row = mysql_fetch_array($rs) ) {
   
    $list .= "<tr>";
    $list .= "<td>".$row["name"]."</td>";
     $list .= "<td>".$row["last"]."</td>";
    $list .= "<td>".$row["user"]."</td>";
    $list .= "<td>".$row["email"]."</td>";
    $list .= "<td><a href='member_details.php?id=".$row['ID']."'>Edit</a></td>";
    $list .= "<td><a onclick='return confirm(\"Are you sure to delete ".$row["name"]." \")' href='member_list.php?id=".$row["ID"]."&task=delete'>Delete</a></td>";
     $list .= "<td><a  href='Password.php?id=".$row['ID']."'>Click Here</a></td>
     </tr>";
   
} 
   $list .= "</table>";
   echo ( $list );
   
?>
   <form method="post" action="member_list.php"><br>
   <div style="margin : 0px 600px">
   <style type="text/css">
body {background:#F5F5F5 url('http://images.apple.com/downloads/dashboard/travel/images/traveltodolist_20070724165034.jpg') no-repeat top;;
     
       }</style>
   
         
         <input type="submit" name="Logout" value="logout" />
         
      </form>
</body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi guys, I have page where it echos out the image url from mysql in a MAMP Server,

however when i echo the image url out it seems to be fine but as soon as i put in a img scr it wont show the image  but it shows the container.

I have the code here
Code: [Select]
<div id="maincontentholderbottom">

<div id="maincontentholderbottom-index-left">
<div id="news-container"><ul>

<?php
$select=mysql_query("SELECT * FROM news");
while($get_news=mysql_fetch_array($select)){
$newsid=$get_news['id'];
$title=$get_news['title'];
$text=$get_news['text'];
$newsdate=$get_news['date'];
$newstime=$get_news['time'];
$imagelink=$get_news['newsimagelink'];

$newstext=substr($text, 0, 420);



echo"<li><div id='title'>$title</div><div id='newsblock'>$newstext... <a href='http://localhost/mycomputer/create/news/index.php?id=$newsid'>Read More</a></div>
<div id='newsimage'><img src='$imagelink' width='150' height='70'/></div>

</li>";

}

?>
</ul>

</div>
</div>
</div>


Do u know why is it like this? I appreciate your help in advance.

Thanks!

Hi all

I have created a mySQL query and assigned it to a string:

Code: [Select]
$getjobs = mysql_query (" SELECT * FROM jobs WHERE from_date >= '".substr($newdate, 0, 10)."' $keyword_search $sector_search $salary_search $location_search $type_search ORDER BY job_refno DESC ") or die (mysql_error());

Is there any way to output the actual query to the browser to check it?

I have a product page which populates all my products in one page. I have also a detail page which gives details on a product which i wanted to know. My problem is when I am going to click on the product that I want the detail page shows incorrect product details. I just want one detail product page so that it will be easy to edit the page in the future.

I am asking an Idea on how to make one detail page in all of my products.. thanks...

Hi all,

I am trying to make a members details section that can be updated.

I want to be able to "SELECT * FROM users WHERE email='$email'" and then show the values that can be changed in a html drop down box with the selection that was made when the user registered already selected="selected";

You will be able to see what I am attempting to do below.


<?php

$sql = "SELECT manufacturer FROM table1 WHERE email=$'email'";
$result = mysqli_query($cxn,$sql);
$row = mysqli_fetch_assoc($result);

foreach manufacturer in table1 { 
      if table1.manufacturer = table2.manufacturer {
               echo '<option name="manufacturer" selected="selected" value"$row['manufacturer']"</option>';
     }
     else {
              echo '<option name="manufacturer" value"$row['manufacturer']"</option>';
     }
}
?>