|
PHP - Need Drop Down Menu To Display Information Based On Username
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.
Similar Tutorials
Using Inline Php; <h1><font Color="000088">the Username <?php '.$username.' ?> Already Exists";</h1>
I am having a lot of trouble with this code, and I have no clue how to fix it. Right now, I have a GUI for a fictitious car dealership that has 5 populated drop down menus called Make, Model, Year, Color, and Mileage. What I want the code to do is read the selections made by the user with the drop down menus once the user hits the submit button and then filter the tables that I have in a mysql database to meets the choice requirements of the user. The code will bring up the GUI, but once I hit the submit button, I get the following errors Please if anyone can help me that would be fantastic. I really have no clue I am having issues with my page. I am trying to send a email to a different address based on the entry that my user submits. Here is my form on my test page. Code: [Select] <form method=POST action=formdata.php> <table width="640" border=0 align="center"> <tr> <td align=right><b>Test</b></td> <td><input type=text name=test size=25></td> <td> </td> <td> </td> </tr> </table> </dl> <div align="center"> <p> <input type=hidden name=FA value=SendMail> </p> <input type=submit value="Submit Form"> </p> </div> </form> here is the php code for my formdata page Code: [Select] <?php $con = mysql_connect("localhost","test","test"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("test", $con); $sql="INSERT INTO formdata (test) VALUES ('$_POST[test]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "Your Information Was Successfully Posted"; mysql_close($con); if ($_POST['test'] =="A"){ $to = "email@sample.com"; $subject = "Custom Form"; $message = $_POST['test'] ; $headers = "From: email@sample.com"; $sent = mail($to, $subject, $message, $headers) ; } else if ($_POST['test'] =="B"){ $to = "email2@sample.com"; $subject = "Custom Form"; $message = $_POST['test'] ; $headers = "From: email@sample.com"; $sent = mail($to, $subject, $message, $headers) ; } if($sent) {print "<p>Your mail was sent successfully"; } else {print "<p>We encountered an error sending your mail"; } ?> As a complete newbie to php and webdesigning i have a following problem.I would like to retrieve the data from database and display it in a drop down menu.Then i should allow the user to select the values from drop down list along with other details,in other words i have to embed the drop down output as the form input for the user and store the form data in another table.I am running a xampp server and i am using php 5.4 version.Please help.My code is as follows.In this case project_name is displayed as the drop down output.but how do i use the same drop down output as a input in the form. <html> <head></head> <body> <?php error_reporting(E_ALL ^ E_DEPRECATED); include 'connect.php' ; $tbl_name="projects"; $sql="SELECT project_name FROM $tbl_name "; $result=mysql_query($sql); if($result === FALSE) { die(mysql_error()); } ?> <form name="resources" action="hourssubmit.php" method="post" > <?php echo "<select name='project_name'>"; while ($row = mysql_fetch_array($result)) { echo "<option value='" . $row['project_name'] ."'>" . $row['project_name'] ."</option>"; } echo "</select>"; ?> </form> </body> </html> Alright, I've been assigned a project at work. I did not develop the application and the individual who did used CodeIgnited framework and mysql as the db.
Here's the problem, I'm not given much OT to do this and in our meeting the best way to proceed was to replicate the database for different parts of the organization. Basically we are a subsidiary and have been using an application that other groups within the organization want to use. Usually I would reconfigure the db schema and add org ids and in the user table add the appropriate organization to go to. However, they are not giving me enough time to do that.
So what I'm thinking is to just create a copy of the database we use (just the structure) and create a new database.
What I want to know is how to use mysql to check to see if a user exists in one database and if they don't then to go on to the next database. I understand this is a very sloppy way to do it, but it's the way we are moving forward.
I found the code to connect to the db in CodeIgnitor... how can I connect to a database, check to see if the user exists, then close that db connection and try the next database?
/**
* Select the database
*
* @access private called by the base class
* @return resource
*/
function db_select()
{
return @mysql_select_db($this->database, $this->conn_id);
}
Thanks in advance.
Hi, I want to update user information in the database but it doesn't do anything. No data entered upon form submission. Please anyone if you can help would be great. Thank you. Code: [Select] <?php ini_set ("display_errors", "1"); error_reporting(E_ALL); $host = "";//edited out $database = ""; $username = ""; $password = ""; $tbl_name = "users"; $link = mysqli_connect($host, $username, $password); $conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error()); mysql_select_db($database); session_start(); IF (isset($_SESSION['userid'])){ $userid=$_SESSION['userid']; echo $userid; } //$currentUser = $_SESSION['myusername']; //do some cleanup// IF (isset($_POST['submit'])){ $first = $_POST['first']; $last = $_POST['last']; $dob = $_POST['dob']; $gender = $_POST['gender']; $country = $_POST['country']; $state = $_POST['state']; $town = $_POST['town']; $zip = $_POST['zip']; $email = $_POST['email']; $first = mysql_real_escape_string( '$first'); $last = mysql_real_escape_string( '$last'); $dob = mysql_real_escape_string( '$dob'); $gender = mysql_real_escape_string( '$gender'); $country = mysql_real_escape_string( '$country'); $state = mysql_real_escape_string( '$state'); $town = mysql_real_escape_string( '$town'); $zip = mysql_real_escape_string( '$zip'); $email = mysql_real_escape_string( '$email'); }; IF (isset($_SESSION['userid'])){ $userid=$_SESSION['userid']; } ELSE{ $getuserid=mysql_query ("SELECT id FROM users ORDER BY id DESC limit 1") or die(mysql_error()); WHILE ($gtuserid = mysql_fetch_array($getuserid)) { $theuserid=$gtuserid['id']; $userid=$theuserid; $_SESSION['userid']=$theuserid; $userid=$_SESSION['userid']; }//$getuserid }// IF ELSE (isset($_SESSION['userid'])) /////UPDATE SECTION///// IF (isset($_POST['submit'])){ mysql_query ( "UPDATE users SET firstname='$first', lastname='$last', dob = '$dob', gender='$gender', country='$country', state='$state', town='$town', zip='$zip', email='$email' WHERE id=$userid") or die(mysql_error()); }//IF ($_POST['update']=="Update") ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Connection</title> <style type="text/css"> body { font-family:Calibri; font-size:1em; } .title { font-size:1.6em; font-weight:strong; } .links a{ font-size::1.2em; text-decoration:none; } .links a:hover{ font-size::1.2em; color:#0066FF; text-decoration:none; } </style> </head> <body> <p><span class="title">Add your personal information/span></p> <form action="thebeast.php" method="post"> <p> <input type="text" name="first" size="20" id="first" /> First name<br /> <input type="text" name="last" size="20" id="name" /> Last name<br /> <input name="dob" type="text" size="20" id="dob" ; } ?> Date of Birth<br /> <input type="text" name="gender" size="20" id="gender" /> Gender <br /> <input type="text" name="country" size="20" id="country" /> Country<br /> <input type="text" name="state" size="20" id="state" /> State<br /> <input type="text" name="town" size="20" id="town" /> Town<br /> <input type="text" name="zip" size="20" id="zip" /> Zip Code<br /> <input type="text" name="email" size="40" id="email" /> Email<br /> <br /> <input type="submit" name="submit" value="Add your information" /> </form> </body> </html> Hi, iam pretty new and have made a forum style page for intern project display. ATM i use a standard php loginscript, just so i can add the author of the text. But as you can imagine thats pretty inconvinient. Is their a way to get the username from my roaming profil or from the current AD user (dont need to auth, just so i can add my nameunder post, like i login on windows with username "Heinz", and write a post on my side, so he can take the username "Heinz" and display it beneth the post? iam pretty clueless where to start looking, would you be so nice and provide me some topic/hints to give me a push in the right direction.
Sry if my english is..... a bit rubbish. i greatfull for all your time sincerly Nasten Example: i have an array of names array{ => john [1] = ted [2] = jeff } and i display them like this: john, ted, jeff but jeff is currently logged in so i want his name to display first(i have my reasons lol) how would i go about this? i got as far as: if(in_array($user->user_name, $likes)) { $user_key = array_search($user->user_name, $likes); } then hit a brain freeze. Thanks This topic has been moved to Ajax Help. http://www.phpfreaks.com/forums/index.php?topic=349871.0 I have created a drop down list and it does retrieve information from mysql but now I want to use what is been selected to retrieve information. How Do I do this? <?php MYSQL_CONNECT(localhost,'root','') OR DIE("Unable to connect to database"); @mysql_select_db(Examination) or die( "Unable to select database"); $query=("SELECT * FROM subject"); $result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() ); echo "<select name=myselect>"; while($row=mysql_fetch_array($result)){ echo "<OPTION VALUE=".$row['Sub_ID'].">".$row['Sub_Name']."</OPTION>"; } echo "</select>"; ?> 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; ?> 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 Apologies for this because it's probably very simple, but I've never worked with JavaScript or PHP or anything before.
So the website I am producing is to sell tickets for something. To purchase these tickets the user is required to click on the seats they want and it will pop up in a box on the left hand side confirming their seat selection and how much the ticket is.
The website has to feature a "Reset Database" button which totally resets everything. No tickets are selected anymore, the user is logged out etc. I have this working fine.
It also has to feature a "Cancel" button, which simply removes the seats the user has selected, but still keeps them logged in. How do I code this?
This is what the "Cancel" button looks like on the Index page:
<div id="theButtons"> <input type="button" value="Cancel Choices" title="Cancel Choices" onclick="cancel()" /> </div> And this is my code on the JavaScript page: function cancel(){ var s = document.getElementsByTagName('space'); window.location="index.php"; } How do I get this working? Edited by DavidD95, 08 November 2014 - 10:36 AM. 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!
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 ISSUE. A User enters information into a form. If the 'username' is already taken, a 'message' in Red and with larger font-size will be returned, for example, "The username $username already exists." If the username is 'mattd' then the message should say, "The username mattd already exists." Within my php application, I have included 'inline html'. Here is part of the code: .... if (mysql_num_rows($query_run)==1) { // it will never = more than one because only //one user will or will not exist ?> <html> </body> <h1><font color="#FF0066">The username <?php echo $username; ?>already exists.</h1> </body> </html> <?php }else{ //start the registration process $query = "INSERT INTO `Names` VALUES .... 1. At one point I did get this: "The username mattd already exists." 2. But now I only get "The username already exists." I am not retrieving the $username variable. This screenshot is found he http://imgur.com/lIwLZ1G thanks. While we're on the subject, is there a way to ensure that the first letter of a name is captalized, and the rest lowercase? Or is this best handled later on, when the name is being used and called from the DB. PS: some of us comment are code as to WHAT we are doing because we're just not that good yet, and we need to explain it to ourselves. Hello, i want to reproduce a content switcher based on drop-down menu (example: http://www.infocercetare.ro/index.php) anyone can help me with the logic of the function the rest i think i can handle. best regards |
|||||||