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 Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/124948-sql-query-die-customized/#findComment-645633 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.