Member Avatar for liphoso

I am new new to PHP and would like some help. I have read as much as i could but could not get any help hence why i donot even have code i had tried.

Assume a database names "sales" with fields" fieldOne" and "fieldtwo". using sql and PHP how can i get the data in the database to be displayed on a form.

I basically want a use to enter a phone number that is unique to each record then have the rest of the data called up from the database and returned to a form i have designed in HTML. i have been able to recall the data but is not displayed where i want it to be.
thnx

  • 3 Contributors
  • 13 Replies
  • 109 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by liphoso
Member Avatar for HITMANOF44th

post the code for your html form

Member Avatar for liphoso

post the code for your html form

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="en-za" http-equiv="Content-Language" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Untitled 1</title>
<style type="text/css">
.auto-style1 {
	text-align: center;
}
.auto-style3 {
	text-align: center;
	font-size: xx-large;
}
.auto-style4 {
	text-align: left;
}
.auto-style5 {
	text-align: left;
	margin-left: 40px;
}
.auto-style6 {
	margin-left: 40px;
}
</style>



<?PHP
//make connection to the database
$connect = mysql_connect("localhost", "root","");
if (!$connect)
    {
       die("database connection failed". mysql_error());
    }
//make sure we’re using the right database
$select_db = mysql_select_db("lero_med");
if (!select_db)
   {
     die("database selection failed " .mysql_error());
   }

//post the number
	$Number = trim($_POST['Number']);

//query to search for the specified number
$query = "SELECT Number,Name,Address FROM customers WHERE Number = '$Number' ORDER BY Name";
$results = mysql_query($query)
or die("Something went wrong");
/*
   this is where i get stuck, i can recall the other data from my database but i cant        place it as i would like. i donot even know if what i want is possible.
*/
while ($row = mysql_fetch_array($results))
 {
	extract($row);
	echo $Number;
	echo " - ";
	echo $Name;
	echo " - ";
	echo $Address;
	echo "<br>";
 }


?>

</head>

<body>
<p class="auto-style1">
<img alt="Lero Mad-Chem" src="../img6.jpg" height="213" width="262" /></p>
<hr />
<p class="auto-style3">Clerk Main Sales Page</p>
<hr />
<p class="auto-style1"><a href="check_stock.htm">Check Stock</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="check_sales.php">Check_Sales</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="Drawings.php">Drawings</a></p>
<p class="auto-style1">&nbsp;</p>
&nbsp;
<form method="post" action="main.php">
	<fieldset name="Customer_details">
		<legend style="width: 145px">Customer Details</legend>
	<br />
<p class="auto-style4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;





Customer's Phone Number:&nbsp;&nbsp;&nbsp;&nbsp;
		<input name="Number" type="text" value="" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          
		<input name="SearchNumber" type="submit" value="Search" /></p>
		
		
		
		
		
	<p class="auto-style4">&nbsp;</p>
	<p class="auto-style5">Customer's Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </label>
		<input name=" Name" type="text" /></p>
		

	<p class="auto-style5">Customer's Address:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<textarea cols="20" name="Address" rows="1" style="width: 195px; height: 64px"></textarea>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


		<input name="Button4" type="submit" value="Commit" />&nbsp;&nbsp; </p>
	<p class="auto-style6">&nbsp;</p>
	</fieldset></form>
</body>

</html>
Member Avatar for simplypixie

Not sure what the extract is for, it is as simple as

while ($row = mysql_fetch_array($results))
 {
	echo $row['Number'].' - '. $row['Name'].' - '. $row['Address'].'<br>';
 }

You also need to clean up your HTML (i.e. get rid of all those $nbsp;)

Member Avatar for HITMANOF44th

i see simply beat me too it

also if you want to put it into a table and style it

<?PHP
echo "<table id='table'><tr><td>NUMBER</td><td>NAME</td><td>ADDRESS</td></tr>";
    while ($row = mysql_fetch_array($results))
    {
 echo "<tr><td>".$row['Number']."</td><td>".$row['Name']."</td><td>".$row['Address']."</td></tr>";
    }
echo "</table>";
?>
Member Avatar for simplypixie

Sorry HITMANOF44th :)

Member Avatar for liphoso

we have input boxes to send data from the form to wherever, is there a reverse for that? how do i tell the browser specifically where to place the result from the query?

Member Avatar for HITMANOF44th

change this

<?PHP
    echo "<table id='table'><tr><td>NUMBER</td><td>NAME</td><td>ADDRESS</td></tr>";
    while ($row = mysql_fetch_array($results))
    {
    echo "<tr><td>".$row['Number']."</td><td>".$row['Name']."</td><td>".$row['Address']."</td></tr>";
    }
    echo "</table>";
    ?>

to this

<?PHP
    while ($row = mysql_fetch_array($results))
    {
$number[] = $row['Number'];
$name[] = $row['Name'];
$address[] = $row['Address'];
    ?>

then any where out side of it you can loop any of those arrays to display the code

// put this somewhere after to display the results
$counted = count($number)
for ( $counter = 0 ; $counter <= $counted; $counter += 1) {

echo $number[$counter]." ".$name[$counter]." ".$address[$counter];

}
Edited by HITMANOF44th because: n/a
Member Avatar for liphoso

thank you. on a completely unrelated question..
is it possible to send more that one query to the same database from the same form at
the same time?
assume i have one query that simply reads data form the database and prints it. can i also have one that changes that value on one table, the tables are in the same database but no relation.

Member Avatar for HITMANOF44th

mysql does not allow multi querys at once but you could do this

// i assume your already connected to the database
$query1 = "query 1";
$query2 = "query 1";

// Perform Query
$result1 = mysql_query($query1);
$result2 = mysql_query($query2);

// if you want data back from one of the querys
while ($row = mysql_fetch_assoc($result1)) {
   $fname[] =  $row['firstname'];
     $lname[] = $row['lastname'];
   $address[] = $row['address'];

}
Edited by HITMANOF44th because: n/a
Member Avatar for liphoso

i think this should solve my problem, please look at my thread titled "decrementing".
i am trying to read from my database. i would like to read from one table, then with the same submit button change a value in another table. if you spot the reason it does not work please tell me what was wrong so i can understand it better

Member Avatar for liphoso

this might solve my other problem. i have one database with two tables, i use one connecting statement. i then want to read from one table then change a value in the other database. this i want to do in the same form hence same submit button. please look at the thread i have posted titled "decrement".
p.s, please do not just give me the correct codding but also tell me why the one i had could not work.

Member Avatar for HITMANOF44th

not a problem do you still want help with the other post i looked at it is it giving you a error or not the desired result ?

also i would do all the adding outside of the query

do you still need help with the other one ?

Member Avatar for liphoso

yes please assist me where u can

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.