PHP MySQL Transactions -
Is there a way to move a SQL transaction into a command? Like
mysql_query ("Include Start Transactions, Table 1 ... etc ... Include in Table 2 ...; Commit;");
Or do you always have to use different commands? Like
mysql_query ("Start Transaction;"); Mysql_query ("INS etc etc etc.
thanks
By using PDFs instead of pure mysql statements,
$ connection = new PDO ('mysql: host = localhost; dbname = test', 'user', 'password') ; $ Connection- $ Connection-> exec ('Insert in Table 1' ...); $ connection- & gt; exec ('Insert in Table 2 ...'); $ connection- & gt; commit ( );
Of course, this is just a quick example, instead you should use prepared statements and bind to user input Must use Riabls so you do not have to worry much about SQL injection.
Comments
Post a Comment