close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

followed auroral for insert,update, delete record can't get it to work

Thread began 10/12/2016 9:45 am by software.current355386 | Last modified 10/15/2016 2:52 pm by Ray Borduin | 734 views | 17 replies |

software.current355386

followed auroral for insert,update, delete record can't get it to work

unable to get records to inset or update corrects, I cannot see whats wrong please c an you help

i thought yh update would populate the form WITh the current data fo=rom the database initially

Attached Files
sIte_update.php
site_insert.php
Sign in to reply to this post

Ray BorduinWebAssist

What is the data type for the checkbox controlled columns?

One way to debug what is going on is to dump the query object after the insert takes place. Add this code below the insert code:

php:
<?php

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  
var_dump($InsertQuery);
  die();
|
?>



Then post that result here and I can diagnose what might be going wrong.

Sign in to reply to this post

software.current355386

nb working on localhost
the fields holding checkboxes are defined in db as one character tying to store y or n

Sign in to reply to this post

Ray BorduinWebAssist

It looks like that insert worked. There are no errors and everything seems to be in place.

What is the problem you are having?

Sign in to reply to this post

software.current355386

insert 3 y's regardless how many specified

update doesn't popular form wit current rect as i believe it should .... how do u know what changes to make
the u make change press submit it baks out the site the check boxes stay the same

Sign in to reply to this post

Ray BorduinWebAssist

Try replacing the queryobj.php file with the one I have attached.

Attached Files
queryobj.php
Sign in to reply to this post

software.current355386

status quo prevail ... results same, created front end so i donut chabg4 anything only the front end .

copied over file now see a message with the dum not seen b4, dump in pm

have i got my thought proved + logic wrong

to update a record first of all you need to see the original data, loaded into the form from database , then you make the chances the data base record is rewetted with all titre fieds again ... including the ons changed.

input - fill in form results in the record being written but all the check boxes set to y ... database default is null

update no original data presented in the form , make changes blind no change to db



can you please confirm my logic iS correct before i go mad

Attached Files
Untitled-4.php
sIte_update.php
site_insert.php
Sign in to reply to this post

Ray BorduinWebAssist

The logic looks correct to me. Can I get FTP access and a URL to reproduce? I'll be able to debug and find the solution that way. It must be an issue in the way the checkbox Y/N code is set up.

Sign in to reply to this post

software.current355386

see pm

Sign in to reply to this post

Ray BorduinWebAssist

The queryobj.php file wasn't updated on your live server. I updated it and it seems to have fixed this problem.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...