[RESOLVED] reload after insert

[Beatnik]

Im not exactly sure how to describe what I am trying to do but Ill give it a shot. I need to reload the page with some data that was just inserted.

This is the particular insert code as it is now:

function do_add_line_items() {
 global $dcdms_db;

 if( !isset($_GET['job_id']) || !isset($_GET['item_id']) || !isset($_GET['qty']))
  redirect("sales.php?error=1");

 $sql = new SQL;
 $sql->connect($dcdms_db['addr'], $dcdms_db['user'], $dcdms_db['pass'], $dcdms_db['name']);

 $job_id = $sql->quote_smart($_GET['job_id']);
 $item_id = $sql->quote_smart($_GET['item_id']);
 $qty = $sql->quote_smart($_GET['qty']);

 $sql->query("INSERT INTO line_items (job_id, item_id, item_qty)
	 VALUES ('$job_id','$item_id','$qty')");

 if ($sql->affected_rows()) {
	$sql->close();
	redirect("sales.php?error=3");  // This is where I need to reload / refresh the page
    } else {
		$sql->close();
		redirect("sales.php?error=5");
	}
}

Ive tried the following but none of it seems to work. Im guessing because of the $sql->close()

.....redirect("sales.php?action=add_line_items&id=$data[0]");

.....redirect("sales.php?action=add_line_items&id=$job_id");

.....redirect("sales.php?action=add_line_items&id=['job_id']");

I dont necessarily need the (?error=3) its just a confirmation the data was updated.

Any ideas on how I might accomplish something like this?

As always, thanks much for any assistance you may be able to provide.

[dagon]

redirect is not a php function, we would need to see its code.

[djjjozsi]

Hello,

And what is the error message in your program ?

[Beatnik]

dagon;10901909 wrote:

redirect is not a php function, we would need to see its code.

I believe this is what your looking for:

function redirect($url) {
 if ( strpos($_SERVER['SERVER_SOFTWARE'], 'Microsoft-IIS') === false ){
	header("Location: ".$url);
	exit();
	} else die('<meta http-equiv="refresh" content="0;URL='.$url.'" />');
}

I dont necessarily have to use the redirect function, I just need to find a way to get back to the same page with it displaying the newly inserted information.

I was just thinking perhaps I may be able to incorporate the "javascript:window.history.back()" idea but Im not sure yet how that would work. If it did work to get me to the correct page I dont think the newly inserted data would be there without somehow refreshing the page at the same time.

djjjozsi;10901916 wrote:

Hello,

And what is the error message in your program ?

This is what the errors=X is all about. As you can see case 3 is just a confirmation that the sale was updated and not entirely necessary as if I get back to the location Im trying to I will know the data was updated because if it was not I will get sent back to the main sale page with an error.

$err = (isset($_GET['error'])) ? $_GET['error'] : NULL;

$output .= "<div class=\"top\">";
switch ($err) {
case 1:
   $output .= "<h1><font class=\"error\">{$lang_global['empty_fields']}</font></h1>";
   break;
case 2:
   $output .= "<h1><font class=\"error\">{$lang_global['err_no_search_passed']}</font></h1>";
   break;
case 3:
	$output .= "<h1><font class=\"error\">{$lang_sales['sale_updated']}</font></h1>";
   break;
case 4:
   $output .= "<h1><font class=\"error\">{$lang_sales['search_results']}</font></h1>";
   break;
case 5:
	$output .= "<h1><font class=\"error\">{$lang_sales['error_updating']}</font></h1>";
   break;
default: //no error
    $output .= "<h1>{$lang_sales['sales_data']}</h1>";
}

and this is the function info for the error

function error($err){
	//$err = addslashes($err);
	redirect("error.php?err=$err");
}

Thanks again.

[djjjozsi]

lets see this one:

<?php

function back($url , $error ,$type)
{
	if($error==1) {
		$_SESSION["error"]=$error;
		header("Location: ". basename($_SERVER['HTTP_REFERER']));
	}
	elseif($error==2) {
	   	$_SESSION["error"]=$error;
	   	header("Location: " . $url );
	}
	elseif($error==3) {
	   	header("Location: " . $url  );
	}   

}

/*
for example:   */
back("errors.php","You have to log in!","2");  /*   send the error message via session*/

/*  or  */
back("","You have to fill all the required fields","1");  /*  previous page   */

/*  or  */
back("errors.php?errorcode=4","","3");

?>

[Beatnik]

Thanks for the tips / advise. I ended up accomplishing my objective using a couple of AJAX functions therefor there is no need to get (back) to the page as the page is never left.

Although it took me a few days of R&D I have this working even better than I had originally planned.

Marking this resolved, thanks once again.