|
PHP - Display Detail Information
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; ?> Similar Tutorialsphp can detect "mac address", "ip address", "browser agent", "cookie" and "hostname". What else php can detect? 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. Hello, I recently came upon this website and I want to implement something similar. The 'remove' box is what I would like to do with PHP. I have no idea where to start. I would like to be able to search through my database, select one of its components and add it to that window. Within that window I would also like to be able to remove it. Does anyone know where I should go from there? here is the site: http://www.sealandserpent.org/schedgen/schedulegenerator.php 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've been trying to get this to work for a few days now and can't seem to get anywhere with it! Any help is very much appreciated. I am creating a number generator where the user is required to insert the maximum number and generate rate. Maximum number is the highest number that the script will go to, and generate rate is how many numbers should be created. When the script runs, the numbers are stored into a MySQL database. The MySQL database creates a unique ID number so it can be recalled at a later date. The user then needs to go to Sorting.php and selects the record they wish to use. The numbers from this record are then counted and then stored into an array. If the numbers 2,5,5,0,2,2,1,3,5,1 where generated, the output of this new array will be: [5] => 3 [3] => 1 [2] => 3 [1] => 2 => 1 (These arrays can be of any length) I now need to extract this data and show it on screen. I don't know how to approach it. Format example: Number 5 appears 3 times Number 3 appears 1 times Number 2 appears 3 times Number 0 appears 1 times Sorting.php <?php $db1 = new Number_Information(); $db1->openDB(); $sql = "select * from GeneratedNumber"; $result = $db1->getResult($sql); if (!$_POST) { //page loads for the first time ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> Select the ID (If you have just generated a number, it will be the last one): <!--This is the drop down menu--> <select name="ID"> <?php while ($row = mysql_fetch_assoc($result)) { echo "<option value='{$row['ID']}'> {$row['ID']} </option>"; } ?> </select> <br /> <input type="submit" value="Continue" /> </form> <?php } else { $ID = $_POST['ID']; //This will contain the value that was selected in the drop down menu above. $result = mysql_query("SELECT NUMBERS2 FROM GeneratedNumber WHERE ID='{$ID}'"); //This tells the script to select NUMBERS2 contents which is assosiated with the ID. while ($row = mysql_fetch_array($result)) $NUMBERS2 = $row['NUMBERS2']; echo "$NUMBERS2"; //Testing reasons - remove it later. echo "<br />"; //same as above echo "$ID"; // as above. echo "<br />"; //as above //Convert NUMBERS2 back into an array when inserted into table from Generator.php $NUMBERS = explode(",", $NUMBERS2); // Counts how many times a number appears //******************************************************************************************************************* //IF ALL ELSE FAILS, REVERT BACK TO THIS. //print_r(array_count_values($NUMBERS)); //It will only print the statement, but gives you a good building block when things WILL go wrong. //******************************************************************************************************************* rsort($NUMBERS); print_r(array_count_values($NUMBERS)); (The questions when editing posts are hard. I've needed to Google both of them:() I have a website that lists courses. I want each tutor to be able to add a piece of code that will display upcoming courses on their website. I am unsure of the best, secure way to do this. Could I simply create a file with a function and allow the tutor to add this to their site something like: <? include "http://www.mysite.com/showCourses.php?user=peterPan; ?> This showCourses.php would connect and query my database, would this work? 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!
Hello my problem here is to have a drop down menu which gathers usernames from the database. Then with a click of a button the information for that specific user selected is shown. I'm close code wise but right now it's just showing me all users. I'm displaying the info in text box's to allow an admin to change the info.
<form action="edit.php" method="post">
<select name="username" id="username">
<?php
// Connects to your Database
$con=mysqli_connect('localhost', 'root', '');
/* check connection */
if (mysqli_connect_errno($con)) {
trigger_error('Database connection failed: ' . mysqli_connect_error(), E_USER_ERROR);
}
$query = "SELECT `username` FROM `bencobricks` . `users`";
$result = mysqli_query($con, $query) or trigger_error("Query Failed! SQL: $query - Error: ". mysqli_error($con), E_USER_ERROR);
if($result) {
while($row = mysqli_fetch_assoc($result)) {
//printf ("%s\n %s\n ",
echo "<label for='username'>Username: </label> <option value='$row[username]'>$row[username] </option><br/>";
echo "<br/><br/> ";
}
}
mysqli_close($con);
?>
</select>
<br />
<input name="send" id="send" type="submit" value="Edit User" />
</form>
Then in the edit.php file i have this code:
<?php
// Connects to your Database
$con=mysqli_connect('localhost', 'root', '');
/* check connection */
if (mysqli_connect_errno($con)) {
trigger_error('Database connection failed: ' . mysqli_connect_error(), E_USER_ERROR);
}
if (isset($_POST['send'])) {
$username = $_POST['username'];
$query = "SELECT * FROM `bencobricks` . `users` ";
$result = mysqli_query($con, $query) or trigger_error("Query Failed! SQL: $query - Error: ". mysqli_error($con), E_USER_ERROR);
// Print the result
if($result) {
while ($row = mysqli_fetch_assoc($result)) {
// $query = "SELECT * FROM `bencobricks` . `users` WHERE `username` = username = $row[username]";
printf ("%s\n %s\n %s\n %s\n %s\n %s\n %s\n %s\n %s\n %s\n %s\n",
"<label for='username'>Username: </label> <input type='text' name='username' value='$row[username]'>" . "</input><br/>",
"<label for='email'>Email: </label> <input type='text' name='email' value='$row[email]'>" . "</input><br/>",
"<label for='membership'>Membership: </label> <input type='text' name='membership' value='$row[membership]'>" . "</input><br/>",
"<label for='firstName'>First name: </label> <input type='text' name='firstName' value='$row[firstName]'>" . "</input><br/>",
"<label for='lastName'>Last name: </label> <input type='text' name='lastName' value='$row[lastName]'>" . "</input><br/>",
"<label for='gender'>Gender: </label> <input type='text' name='gender' value='$row[gender]'>" . "</input><br/>",
"<label for='dateOfBirth'>Birthdate: </label> <input type='text' name='dateOfBirth' value='$row[dateOfBirth]'>" . "</input><br/>",
"<label for='date'>Date: </label> <input type='text' name='date' value='$row[date]'>" . "</input><br/>",
"<label for='sets'>Sets: </label> <input type='text' name='sets' value='$row[sets]'>" . "</input><br/>",
"<label for='checkbox'>Checkbox: </label> <input type='text' name='checkbox' value='$row[checkbox]'>" . "</input><br/>",
"<label for='admin'>Admin? </label> <input type='text' name='admin' value='$row[adminFlag]'>" . "</input><BR>",
"<br/><br/> ");
}
}
}
mysqli_close($con);
?>
Any help is greatly appreciated.
Good afternoon,
I was wondering if you could help me out with a few things. I have created a registration page and it stores the information into my database. A success page then appears with some of the details they entered as a confirmation page. Unfortunately I cannot get the information to appear on the page. I have included some code, any help would be greatly appreciated.
<?php hi, i have made a website where people resgister their details of them and products. they have to enter the following details in form Name of company name of the product company address email id password mobile number contact and brief details about their company
user can then login with email id and pwd. now after login ..user will get a page where he can upload the photos of products images and their price, so now my question is that when he finishes uploading (|by clicking on upload button) the product images and price text box ..then on final uploaded webspage it should show all other things which he registerd before (company name , mobile number etc) along with images and price...hence the main question that user does not need to enter mobile and address while uploading images and filling proce ..but on the final page it should show mobile and address along with price and images..as user is not going to enter mobile and address again and again as he will have multiple products to upload.
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! 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. Hi all expert. I am a newbie in this PHP programming. I need your help or advise on the PHP. And question is, I have a list of data and the details are as below:
ID BILLNO DATE AMOUNT ITEM DESCRIPTION QTY UPRICE 1 IV001 01/01/2015 100.00 A1 Balloon 1 30.00 2 IV001 01/01/2015 100.00 A2 Bag 2 20.00 3 IV001 01/01/2015 100.00 A3 Pen 3 10.00 4 IV002 02/01/2015 20.00 A3 Pen 2 10.00 5 IV003 02/01/2015 50.00 A1 Balloon 1 30.00 6 IV003 02/01/2015 50.00 A2 Bag 1 20.00 How can I make the output in xml by using PHP to output as below: <RECORD> <HEADER BILLNO="IV001" DATE="01/01/2015" AMOUNT="100.00> <DETAIL ITEM="A1" DESCRIPTION="Balloon" QTY="1" UPRICE="30.00"> </DETAIL> <DETAIL ITEM="A2" DESCRIPTION="Bag" QTY="2" UPRICE="20.00"> </DETAIL> <DETAIL ITEM="A3" DESCRIPTION="Pen" QTY="3" UPRICE="10.00"> </DETAIL> </HEADER> <HEADER BILLNO="IV002" DATE="02/01/2015" AMOUNT="20.00> <DETAIL ITEM="A3" DESCRIPTION="Balloon" QTY="2" UPRICE="10.00"> </DETAIL> </HEADER> </RECORD> Your feedback is highly appreciated. Thank you. 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 Friends , We have the JSON Data coming in this format, $invoice_data = {
"CONTACT_ID": "1",
"INV_SERIAL_NO": "100",
"NAME": "baby",
"INV_DATE": "2018-06-27",
"DUE_DATE": "2018-06-27",
"CURRENCY": "KD",
"SUBTOTAL": "143",
"TAX_TOTAL": "13",
"shipment_data": [
{
"SHIP_SERIAL_NO": "44",
"MASTER_NO": "55",
"HOUSE_NO": "88",
"cost_revenue_items": [
{
"CHARGE_REF": "tt",
"CURRENCY": "INR",
"QUANTITY": "2",
"SELLING_RATE": "45",
"EXCHANGE_RATE": "987"
},{
"CHARGE_REF": "ii",
"CURRENCY": "INR",
"QUANTITY": "2",
"SELLING_RATE": "45",
"EXCHANGE_RATE": "456"
},{
"CHARGE_REF": "op",
"CURRENCY": "INR",
"QUANTITY": "2",
"SELLING_RATE": "45",
"EXCHANGE_RATE": "456"
}
]
}
]
}
How to write DELETE End-point for child data-set "cost_revenue_items". What I mean to say is how to handle the request to delete one of item from "cost_revenue_items".
When "cost_revenue_items" will be deleted ,master "invoice_data" will be updated. This update , we can handle by PUT, but how do we know under that PUT, we have to Will JSON request to delete "cost_revenue_items" looks like this ,if it want to delete last record : $invoice_data = {
"CONTACT_ID": "1",
"INV_SERIAL_NO": "100",
"NAME": "baby",
"INV_DATE": "2018-06-27",
"DUE_DATE": "2018-06-27",
"CURRENCY": "KD",
"SUBTOTAL": "143",
"TAX_TOTAL": "13",
"shipment_data": [
{
"SHIP_SERIAL_NO": "44",
"MASTER_NO": "55",
"HOUSE_NO": "88",
"cost_revenue_items": [
{
"CHARGE_REF": "tt",
"CURRENCY": "INR",
"QUANTITY": "2",
"SELLING_RATE": "45",
"EXCHANGE_RATE": "987"
},{
"CHARGE_REF": "ii",
"CURRENCY": "INR",
"QUANTITY": "2",
"SELLING_RATE": "45",
"EXCHANGE_RATE": "456"
}
]
}
]
}
Kindly help me to know , how JSON request will look like ?
Thanks a lot Hi, I have successfully implemented a master details page with the results aligned in columns linking to a details page. I wish to maintain the recordID passed from the master details page and make the dynamic text, which reads Shade A tree that is capable of..... in the attached screen shot a link to another details page referencing the same recordID. The detailspage2.php would look the same as the screenshot except the Shade text and description below will be highlighted, which I can do, there will be a new image and a new image description. All other dynmaic elements on the page will remain the same. I tried to simply save as my detailspage.php to detailspage2.php and create a link to detailspage2.php. It linked to detailspage2.php but none of the record info showed up in their respective table cells. I have all the names desc's, images, etc setup in a table in my database. Please let me know what code and other info you need to help me out with this procedure. Thanks. This is my school project "tv-info" that uses simple_html_dom.
My tv.php
// scrape a tag
$html = file_get_html("http://www.ampparit.com/tv-opas?g=peruskanavat-1");
foreach($html->find($tag) as $e)
$main = $e->plaintext . '<br />';
//plain
$html = file_get_html("http://www.ampparit.com/tv-opas?g=peruskanavat-1");
echo $html->find('[table class="fullwidth"]', 1)->innertext.'</table>';
So my problem is how I can remove some tags in this page? It shows too much things and what I want it is show only tv-table..
There is inside this this tv table like this:
<table class="content-layout">
<tr>
<td id="content" class="content"><div class="submenu-top-container">
<form action="haku" class="right" style="margin-top: 5px;">
<div class="input-wrapper">
<input type="text" name="q" placeholder="Kirjoita hakusana..." style="width: 165px;"><input type="hidden" name="t" value="tv"><button>Hae</button>
</div>
</form>
<div class="submenu-top-item selected">
<a href="/tv-opas" class="submenu-top-item-link">Ohjelmaopas</a>
</div>
<div class="submenu-top-item ">
<a href="/tv-opas?g=suosikkikanavat" class="submenu-top-item-link">Suosikkikanavat</a>
</div>
<div class="submenu-top-item ">
<a href="/tv-opas?g=peruskanavat-1&ss=movies" class="submenu-top-item-link">Elokuvat</a>
</div>
<div class="submenu-top-item ">
<a href="/tv-opas?g=peruskanavat-1&ss=sports" class="submenu-top-item-link">Urheilu</a>
</div>
<div class="submenu-top-item ">
<a href="/tv-opas?g=peruskanavat-1&ss=favorites" class="submenu-top-item-link">Suosikit</a>
</div>
</div>
Thank you if someone can help me! And if someone ask me to use tvrage, I don't because I'm from Finland and there is no support for Finnish tv-series etc..
Not so much of a programming problem as such but if I add the ability to recover accounts via IP address, is it possible to spoof an IP address? Is it a bad idea to automatically allow a user to reset a password if their IP (according to PHP) matches the IP that created the account? i have had a difficult time trying to work this out.I need to do some pattern matching for certain urls and retrieve information from it. For example, $url=http://www.test.com/showpic.php?do=showpic&u=89165&a=34933 if $url contains the value showpic.php,then i need to retrieve the following { $u=value of u(i.e. 89165 in this case) $a=value of a(i.e. 34933 in this case) } else do nothin.. the format of the url will always be the same as above if it contains showpic.php |
|||||||