close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQLi server behaviours

Thread began 8/28/2020 7:06 am by Greg | Last modified 9/10/2020 7:23 pm by anonymous | 875 views | 6 replies |

Greg

MySQLi server behaviours

Hi Guys,

I'm afraid I'm struggling a bit trying to get the delete record function working. On one php page I have a recordset set up and I am using a link to send an id to a php page with the delete code in there. The link is on line 201 of manageContacts2.php

<p><a href="deleteContact2.php?id=<?php echo($getContacts->getColumnVal("id")); ?>">Delete these details</a></p>

But it won't delete. I'm pretty sure the id is getting passed as I use the same code elsewhere and it works.
I have attached both pages if you could possibly help me.

Cheers
Greg

Attached Files
deleteContact2.php
manageContacts2.php
Sign in to reply to this post

Ray BorduinWebAssist

Your delete server behavior trigger is "Any form post" but there is no form posted to the page.

Try changing the trigger from:

if ($_SERVER["REQUEST_METHOD"] === "POST") {

to:

if (isset($_GET["id"])) {

Sign in to reply to this post
Did this help? Tips are appreciated...

Greg

Hi Ray,

Cheers but it didn't work and gave me two errors.

Sign in to reply to this post

Ray BorduinWebAssist

What were the errors? Please attach the updated page.

Sign in to reply to this post
Did this help? Tips are appreciated...

Greg

Hi Ray,

Attached, is the original php in MySQL which I need in MySQLi but I'm not really a coder, that's why I bought this plugin. Your way appears correct it's just I'm getting undeclared variable errors now.

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

Ray BorduinWebAssist

Seeing the original page won't help me debug what is wrong with the current one. Please attach the current page and the error message you see and I should be able to debug it.

Sign in to reply to this post
Did this help? Tips are appreciated...

anonymous

i also have problem like you describe about SQL behavior.

This post has been deleted.

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...