[SOLVED] Displaying data from a database

taz321 · January 17, 2008

Hi i have a simple problem here, and was hoping for a quick resolution.

I have a helpdesk system, where a user would log in and fill in a form.

When the submit button has been clicked, it'l go through to a confirmation page giving the user a reference number.

Now this reference number is the formID of the form, so im wanting to know how i would display the ID of the form thats just been filled in and submitted and displayed on the confirmation page.

Any help would be grateful.

Thanks

revraz · January 17, 2008

How do you generate the ID? Is it the autoincrement ID of the record or something you generate?

taz321 · January 17, 2008

Yeah thats right, its an autoincrement ID of the record.

revraz · January 17, 2008

mysql_insert_id

http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html

taz321 · January 17, 2008

Abit bamboozled.

would i declare this statement at the top of the screen.

mysql> SELECT LAST_formID()

Then echo it where i want it.

e.g - <?php echo $row['formID'];?>

revraz · January 17, 2008

Run this after your mysql_query command

$insert_id = mysql_insert_id();

echo $insert_id;

revraz · January 17, 2008

http://www.phpfreaks.com/quickcode/Get_the_ID_of_Last_MySQL_Entry/20.php

taz321 · January 17, 2008

This is my code so far, which isnt quite working.

<?php mysql> SELECT LAST_formID()?>

$formID = mysql_formID();

<?php echo $formID;?>

On this example code here, it shows me an insert.

$sql = mysql_query("INSERT INTO table (column) VALUES ('$myvalue')") or die (mysql_error());

$insert_id = mysql_insert_id();

But i only want to display the last autocremented ID and not store it anywhere.

I think im getting abit confused, am i along the right lines ?

revraz · January 17, 2008

Show the code after you hit the submit button.

I'm not sure what you are doing with this

<?php mysql> SELECT LAST_formID()?>

$formID = mysql_formID();

<?php echo $formID;?>

taz321 · January 17, 2008

Not sure what code your implying here, but this is the code for the form.

<?php

session_start();

if (isset($_SESSION['username']) == false){

header("Location:ClientLogin.php");

exit();

}

require "connect.php";

$query = "select * from employee order by surname";

$result = @mysql_query($query, $connection)

or die ("Unable to perform query<br>$query");

require "connect.php";

$query1 = "select * from form";

$result1 = mysql_query($query1, $connection)

or die ("MySQL Error: ".mysql_error());

?>

<head>

<title>Jupiter Development Support</title>

<!--

#Layer2 {position:absolute;

width:200px;

height:52px;

z-index:2;

left: 16px;

top: 143px;

}

#Layer1 {position:absolute;

width:200px;

height:80px;

z-index:1;

left: 254px;

top: 84px;

}

.style1 {font-family: "Copperplate Gothic Bold"}

#Layer3 {

position:absolute;

width:200px;

height:115px;

z-index:3;

left: 306px;

top: 255px;

}

#Layer4 {

position:absolute;

width:200px;

height:115px;

z-index:3;

left: 842px;

top: 200px;

}

.style3 {font-family: "Copperplate Gothic Bold"; font-size: x-large; }

#Layer5 {

position:absolute;

width:400px;

height:36px;

z-index:3;

left: 390px;

top: 207px;

}

.style5 {font-family: "Copperplate Gothic Bold"; font-size: small; }

.style6 {

font-family: "Comic Sans MS";

font-size: xx-small;

}

.style7 { font-family: "Copperplate Gothic Bold";

font-size: medium;

font-weight: bold;

}

#Layer6 {

position:absolute;

width:137px;

height:130px;

z-index:4;

left: 906px;

top: 199px;

}

#Layer7 {

position:absolute;

width:82px;

height:28px;

z-index:5;

left: 91px;

top: 565px;

}

#Layer8 {

position:absolute;

width:157px;

height:43px;

z-index:5;

left: 48px;

top: 321px;

}

#Layer9 {

position:absolute;

width:163px;

height:44px;

z-index:6;

left: 47px;

top: 379px;

}

#Layer10 {

position:absolute;

width:155px;

height:44px;

z-index:7;

left: 49px;

top: 592px;

}

-->

</style>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

<div id="Layer5"><span class="style3">Client Enquiry Form</span></div>

<tr>

<td height="20"><span class="style1">Issue Title</span></td>

</tr>

<tr>

</tr>

<tr>

<td>

<td height="20"><span class="style1">Date of Submission </span></td>

<td height="20"><div align="left"><span class="style1">Issue Number </span></div></td>

<tr>

</tr>

<tr>

</tr>

<tr>

<td height="20"><span class="style1">Client Name </span></td>

</tr>

<tr>

</div></td>

</tr>

<tr>

</tr>

<tr>

</div></td>

<td><span class="style6">Please select Appropriate System </span></td>

<td><span class="style6">Please be accurate as this would hold up buisness Operations </span></td>

</tr>

<tr>

</tr>

<tr>

<td><span class="style1">System Affected </span></td>

<td>

<label>

</select>

</label>

<td><span class="style1">Priority Level </span></td>

<td>

<label>

<option>Medium</option>

</select>

</label>

<tr>

</tr>

<tr>

<td><span class="style1">Issue Details </span></td>

<td>

<label>

</label>

<td><span class="style1">Assigned To </span></td>

<td>

<label>

<?php

while($row= mysql_fetch_array($result)){?>

<?php } ?>

</select>

</label> </td>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</body>

After it has been submitted it'l go through to another php page called confirmation.

And in a text box in that page display the last generated ID.

revraz · January 17, 2008

Need to see the code where you actually INSERT into the database. You can only get the ID after you do the INSERT and create the row.

taz321 · January 17, 2008

Oh okay sorry, here it is -

<?php

require "connect.php";

$issuetitle = $_GET['issuetitle'];

$datesubmitted = $_GET['datesubmitted'];

$timesubmitted = $_GET['timesubmitted'];

$systemaffected = $_GET['systemaffected'];

$prioritylevel = $_GET['prioritylevel'];

$issuedetails = $_GET['issuedetails'];

$clientFname = $_GET['clientFname'];

$clientSurname = $_GET['clientSurname'];

$teamname = $_GET['teamname'];

$empName = $_GET['empName'];

$clientID = $_GET['clientID'];

$employeeID = $_GET['employeeID'];

$query = "insert into form values ('','".$issuetitle."','".$datesubmitted."','".$timesubmitted."','".$systemaffected."','".$prioritylevel."','".$issuedetails."','','".$clientFname."','".$clientSurname."','".$teamname."','".$empName."','".$clientID."','".$employeeID."')";

$result = mysql_query($query, $connection) or die ("Unable to perform query<br>$query");

header("Location: confirmation.php");

exit();

?>

revraz · January 17, 2008

Are you using sessions on all your pages? If so, you can store it in a session variable if you want to show it on a different page.

$query = "insert into form values ('','".$issuetitle."','".$datesubmitted."','".$timesubmitted."','".$systemaffected."','".$prioritylevel."','".$issuedetails."','','".$clientFname."','".$clientSurname."','".$teamname."','".$empName."','".$clientID."','".$employeeID."')";
    $result = mysql_query($query, $connection) or die ("Unable to perform query
$query");

$_SESSION['insert_id'] = mysql_insert_id(); 


   header("Location: confirmation.php");
   exit();

Then on confirmation.php

echo $_SESSION['insert_id'];

taz321 · January 17, 2008

Excellent

Thank you very much, this has worked now.

Sign In

[SOLVED] Displaying data from a database

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information