I want to check with PHP whether a query will execute properly without any error.
Say I want to check if inserting a particular record into a table is valid without actually inserting it.
I use the deadly combo PHP + MySQL :)
-
5You cannot ask PHP something that only MySQL can tell you.BoltClock– BoltClock2011-01-14 20:20:36 +00:00Commented Jan 14, 2011 at 20:20
-
Im just asking what I feel should be :) Sometimes its not what people wanna answer :D BTW yes I will take care of thattheReverseFlick– theReverseFlick2011-01-14 20:27:45 +00:00Commented Jan 14, 2011 at 20:27
Add a comment
|
3 Answers
Open new transaction and roll it back after test query execution. Use mysql_error() to check if test query was successful.
1 Comment
Valera Leontyev
In case of MyISAM I see only one way: use of test (may be temporary) table instead of real one. But that way requires additional SQL-query preprocessing.
1: Open up a mysqli connection $conn
$conn->autocommit(false);
$conn->query("INSERT x into y");
echo $conn->error;
$conn->rollback();
$conn->close(); //Without committing changes
start your set of queries with the MySql statement "start transaction", then wrap you following statements in try/catch blocks and then either send a "commit" or a "rollback"
see here on transactions in mysql
