data assist page not inserting record
I've been trying to get this page to work and have tried everything except the right solution. It won't insert a record.
I've been trying to get this page to work and have tried everything except the right solution. It won't insert a record.
the page on the web is in the private message
It looks like you may have copied and pasted code and made a mistake:
This code:
$InsertQuery = new WA_MySQLi_Query($newconn);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "extraimages";
$UpdateQuery->bindColumn("ImgProdId", "d", "".((isset($_POST["ImgProdId"]))?$_POST["ImgProdId"]:"") ."", "WA_ZERO");
$UpdateQuery->bindColumn("Img1", "s", "".($WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_1"]["serverFileName"]) ."", "WA_BLANK");
$UpdateQuery->bindColumn("icon1", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_2"]["serverFileName"] ."", "WA_BLANK");
$UpdateQuery->bindColumn("newarrivalsthumb1", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_3"]["serverFileName"] ."", "WA_BLANK");
would need to be:
$InsertQuery = new WA_MySQLi_Query($newconn);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "extraimages";
$InsertQuery ->bindColumn("ImgProdId", "d", "".((isset($_POST["ImgProdId"]))?$_POST["ImgProdId"]:"") ."", "WA_ZERO");
$InsertQuery ->bindColumn("Img1", "s", "".($WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_1"]["serverFileName"]) ."", "WA_BLANK");
$InsertQuery ->bindColumn("icon1", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_2"]["serverFileName"] ."", "WA_BLANK");
$InsertQuery ->bindColumn("newarrivalsthumb1", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_3"]["serverFileName"] ."", "WA_BLANK");
Any references to "UpdateQuery" should be "InsertQuery"
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.