Mysqli insert doesn't work
Please advice... Have latest version installed.
Please advice... Have latest version installed.
It looks like it would work. Do you get any error messages? If you send me ftp information and a sample url where I can view the problem I can debug it.
Found the problem! This is an old database given by our customer. My guess is that is not supported by mysqli. Just created a new one and everything works fine. Strange though, that "insert" was the only behavior that was inoperative. Thanks for your assistance.
It would be helpful to know what difference there is in the older DB as I am seeing this same case today.
Prior Data Assist DB Inserts work fine, MySQLi insert fail without error and even process to the final redirect.
If you give me contact information in the private area of a reply I'll debug this with you. I'm interested to know the cause myself and we may be able to make an update to fix it.
Delete does not work either.
Passing the URL Query id no problem but nothing happens.
I tried to debug the query like we can do on the other MySQLi methods but this did not seem to work...
if ("" == "") {
$DeleteQuery = new WA_MySQLi_Query($wildwater_i);
$DeleteQuery->setQuery("DELETE FROM tblrentals WHERE rtlId = ?");
$DeleteQuery->bindParam("i","".($_GET['Id']) ."");
echo $DeleteQuery->debugSQL();
exit;
$DeleteQuery->execute();
$DeleteGoTo = "rentals_list.php";
if (function_exists("rel2abs")) $DeleteGoTo = $DeleteGoTo?rel2abs($DeleteGoTo,dirname(__FILE__)):"";
$DeleteQuery->redirect($DeleteGoTo);
}
We looked into this in a screen sharing session and there were no issues with the extensions. The insert page had action="post" instead of method="post" and the delete page was passing the parameter "id" but deleting the record with "Id", so no record was deleted.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.