retreiving information from database using php

carebear23

Hi I am trying to get information from my database to automatically generate a CustomerID for my add customer form on my website but not sure exactly how to write the php code for it. my customer add form is as follows in my website, I have made the writing red where I will be bringing in the customer id to the page, would be grateful of any help please?

<?php
include('functions.php');
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<TITLE>Layout 1</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">

</style>
<script type="text/javascript" src="JSFunctions.js"/>
</script>

</HEAD>
<body>
<div id="container">
<div id="top">

<div id="logo">
<h1> </h1>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<h1> </h1>
<h1>Small Business Database </h1>
</div>

</div>
<div id="navigation">
<div id="nav">
<table>
<td>
<tr><a href="index.php"><em></em> Homepage</a></tr>
<tr><a href="Products.php"><em></em>Products</a></tr>
<tr><a href="Orders.php"><em></em>Orders</a></tr>
<tr><a href="Invoices.php"><em></em>Invoices</a></tr>
<tr><a href="Suppliers.php"><em></em>Suppliers</a></tr>
</td>
</table>
</div>
<div id="subnav">
<ul class="dropdown">
<li>
<a href="Customer.php">Customers</a>
<ul class="sub_menu">
<li><a href="Customer_add.php">Add</a></li>
<li><a href="Customer_edit.php">Edit</a></li>
<li><a href="Customer_delete.php">Delete</a></li>
<li><a href="Customer_lookup.php">Lookup</a></li>

</ul>
</li>
<li>
<a href="Products.php">Products</a>
<ul class="sub_menu">
<li><a href="Products_add.php">Add</a></li>
<li><a href="Products_edit.php">Edit</a></li>
<li><a href="Products_delete.php">Delete</a></li>
<li><a href="Products_lookup.php">Lookup</a></li>
</ul>
</li>
<li>
<a href="Invoice.php">Invoices</a>
<ul class="sub_menu">
<li><a href="Invoice_add.php">Add</a></li>
<li><a href="Invoice_edit.php">Edit</a></li>
<li><a href="Invoice_delete.php">Delete</a></li>
<li><a href="Invoice_lookup.php">Lookup</a></li>

</ul>
</li>
</ul>
</div>
</div>
</div>

<div id="main">
<p> Add Customer</p>

<form name ="theForm" onSubmit="return validateFormOnSubmit(this)" method="POST" action="insertCustomer.php" >
<table width="500">
<tr>
<td width="250">Customer ID: </td>
<td width="200"><select name="CustomerID"id="CustomerID"><?php CustomerID(); ?></select></td>
</tr>
<tr>
<td width="250">Name: </td>
<td width="200"><input name="name" size ="30" type="text" /></td>
</tr>
<tr>
<td> Address: </td>
<td><input name="address" size ="30" type="text" /></td>
</tr>
<tr>
<td> Address Line 1: </td>
<td><input name="address1" size ="30" type="text" /></td>
</tr>
<tr>
<tr>
<td> Address Line 2: </td>
<td><input name="address2" size ="30" type="text" /></td>
</tr>
<tr>
<tr>
<td> County: </td>
<td><select name="County"id="CountyList">
<option>Antrim</option>
<option>Armagh</option>
<option>Carlow</option>
<option>Cavan</option>
<option>Clare</option>
<option>Cork</option>
<option>Derry</option>
<option>Donegal</option>
<option>Down</option>
<option>Dublin</option>
<option>Fermanagh</option>
<option>Galway</option>
<option>Kerry</option>
<option>Kildare</option>
<option>Kilkenny</option>
<option>Laois</option>
<option>Leitrim</option>
<option>Limerick</option>
<option>Longford</option>
<option>Louth</option>
<option>Mayo</option>
<option>Meath</option>
<option>Monaghan</option>
<option>Offaly</option>
<option>Roscommon</option>
<option>Sligo</option>
<option>Tipperary</option>
<option>Tyrone</option>
<option>Waterford</option>
<option>Westmeath</option>
<option>Wexford</option>
<option>Wicklow</option>
</select></td>
</tr>
<tr>
<td> Postcode: </td>
<td><input name="postcode" size ="30" type="text" /></td>
</tr>
<tr>
<td> Telephone: </td>
<td><input name="telephone" size ="30" type="text" /></td>
</tr>
<tr>
<td> E-Mail: </td>
<td><input name="email" size ="30"type="text" /></td>
</tr>
<tr>
<td> Confirm E-Mail: </td>
<td><input name="email2" size ="30"type="text" /></td>
</tr>
<tr>
<td></td>
</tr>
</table>
<input type="submit" value="Submit" /> <input type = "reset" value= "Reset" ><br>
</form>

</div>
</div>

</main>
</body>
</html>

vicodin

Your not gonna find someone to write your entire script for you here... If you want to pay someone then you can probably find someone. This is a help forum, not a do it for me forum. You need to try it on your own and if you get stuck in a spot, then post your question on here. Someone would gladly help you in that case. Start googleing "PHP retrieve data from mysql Tutorial".

carebear23

Vicodin,

I wasn't looking for someone to write the code for me I was just looking for help in how to go about it as I would like to be able to write the code myself.

johanafm

Are you just wondering how to create new customer ids? If so and you are using a database, then when you create your customer table

CREATE TABLE customer (
 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 other,
 fields
)

And to generate new ids, just leave the id field out of any insert query

INSERT INTO customer(other, fields) VALUES (some, values)

And then use something like mysqli::$insert_id (or something similar depending on what DB you use and what you use to talk to it: mysqli, PDO, ...)

zyntrax

Like this?

In insertcustomer.php add:

<?
$CustomerID=$POST['CustomerID'];
$name=$POST['name'];
$address=$POST['address'];
$address1=$POST['address1'];
$address2=$POST['address2'];
$County=$POST['County'];
$postcode=$POST['postcode'];
$telephone=$POST['telephone'];
$email=$POST['email'];
$email2=$POST['email2'];
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
mysql_query("INSERT INTO customer VALUES ('$CustomerID', '$name', '$address', '$address1', '$address2', '$County', '$postcode', '$telephone', '$email', '$email2')");
Print "Your information has been successfully added to the database.";
?>

zyntrax

Oh i think i know what you mean now 🙂

ids.php

mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()); 
 mysql_select_db("Database_Name") or die(mysql_error()); 
 $data = mysql_query("SELECT something FROM somewhere WHERE somethingelse = somethingelse2") 
 or die(mysql_error()); 
 ?>

In you file:

<tr>
<td width="250">Customer ID: </td>
<td width="200"><select name="CustomerID"id="CustomerID"><?php print $data; ?></select></td>
</tr>
<tr>

also add:
include 'ids.php';

bradgrafelman

You should never use a SELECT query to determine the AUTO_INCREMENT value of a previous INSERT query. Doing so will leave you vulnerable to race conditions.