Displaying Text On Same Page When MySQL Data Is Inserted!

m92g11

Hi,

I'm wanting to display a div with the text "Successfully Added" on the same page of the form. Basically instead of loading a new page, it simply reloads the page displaying the text above the form. I thought about using variables, but I'm stuck.

Any help would be greatly appreciated.
Thanks in Advance!
- Michael

johanafm

// your query here
$aff = mysql_affected_rows($link);

// ...

// Top of your page
if ($aff > 0)
	echo "Successfully added";

m92g11

Jonanafm;

I've added the code to my scripts but it doesn't seem to work. I guess I didn't explain it properly. Below is the code which needs to be edited.

add.php

<form method="post">
	<input name="Text1" type="text"><input name="example" type="submit" value="submit"></form>

add.php displays the form. It then loads update.php which injects the data from the form into the database. update.php is listed below:

update.php

<?php
include("../config.php");

mysql_connect("$database_host", "$database_username", "$database_password") or die(mysql_error());
$connect = mysql_select_db("$database_name") or die(mysql_error());

mysql_select_db("$database_name", $connect);

$sql="INSERT INTO table (example)
VALUES
('$_POST[example]')";

mysql_close($connect)
?>

Now I'm not sure where to put the data you provided. I've conducted a little trial and error but came up empty handed. Please help!

Thanks in Advance!
- Michael

djjjozsi

<?php
include( "../config.php" );

mysql_connect( "$database_host", "$database_username", "$database_password" ) or die( mysql_error() );
$connect = mysql_select_db( "$database_name" ) or die( mysql_error() );

mysql_select_db( "$database_name", $connect );

if ( isset( $_POST["example"] ) ) {
    $sql = "INSERT INTO table (example)
VALUES
('" . mysql_real_escape_string( $_POST["example"] ) . "')";
    mysql_query( $sql ) or die( mysql_error() );

if ( mysql_insert_id() )
    echo "New record inserted: #" . mysql_insert_id();
} 

mysql_close( $connect )
?>

m92g11

djjjozsi,

So what does this code do?

djjjozsi

in a nutshell:

if a posted $_POST["example"] variable has set, then az $sql query created,
an INSERT code.

If in your table structure you have a primary key, after a successfully insert a mysql_insert_id() function holds the inserted row's primary key number.

if this values exists , the program then print a message.

m92g11

Okay, but I want the script to display the successfully added message on the add.php page. Not on the update.php page.

johanafm

File and page is not the same thing. Both files can be part of the same web page, and each file could separately be parts of several other web pages, or none.

You control the code execution, so where you put one thing or the other is entirely up to you.

use require, include, require_once, include_once.

djjjozsi

as johanafm said use include(s) , but you can redirect the page on a success mysql insert with: header("Location: index.php?ok_sql=1");

means on a refreshed page in add.php you can test $_GET["ok_sql"]

if(isset($_GET["ok_sql"]))
{
echo "Succesfully inserted in XY table";
}

m92g11

I'm just going to use AJAX to accomplish this task. I think I remember how to do it.

Thanks anyways.