jaxdevil Posted September 19, 2008 Share Posted September 19, 2008 I want to change the die function of my sql query, if the sql query fails I want to have the following piece of code executed: <body onload="parent.main.location.href='http://<?=$_SERVER[HTTP_HOST]?>/pages/mpl_error.php'"> My current statement is: $sql = "INSERT INTO `products` ( $table_products ) VALUES ( $insert_products_str )"; mysql_query($sql) or die('SQL ERROR:'.mysql_error()); So instead I want to do something like: $sql = "INSERT INTO `products` ( $table_products ) VALUES ( $insert_products_str )"; mysql_query($sql) or print "<body onload=\"parent.main.location.href='http://<?=$_SERVER[HTTP_HOST]?>/pages/mpl_error.php\'">" die('SQL ERROR:'.mysql_error()); Would that work? If not any ideas? Thanks in advance, SK Link to comment https://forums.phpfreaks.com/topic/124948-sql-query-die-customized/ Share on other sites More sharing options...
.josh Posted September 19, 2008 Share Posted September 19, 2008 Most immediate fix: mysql_query($sql) or die("<body onload=\"parent.main.location.href='http://<?=$_SERVER[HTTP_HOST]?>/pages/mpl_error.php'\">"); But you should know that die() stops the script, so anything after that won't be executed. If that's a problem for you, look into using trigger_error() instead. Link to comment https://forums.phpfreaks.com/topic/124948-sql-query-die-customized/#findComment-645620 Share on other sites More sharing options...
discomatt Posted September 19, 2008 Share Posted September 19, 2008 Your best bet is to use something like this <pre><?php function someFunc() { return FALSE; } someFunc() or die(" <script type=\"text/javascript\"> <!-- window.location.href='http://{$_SERVER[HTTP_HOST]}/pages/mpl_error.php' // --> </script> "); ?></pre> You may want to add a <noscript> in there with a meta redirect incase JS is turned off. Link to comment https://forums.phpfreaks.com/topic/124948-sql-query-die-customized/#findComment-645633 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.