MySQL CRUD search not working.

All WYSIWYG Web Builder support issues that are not covered in the forums below.
Forum rules
IMPORTANT NOTE!!

DO YOU HAVE A QUESTION OR PROBLEM AND WANT QUICK HELP?
THEN PLEASE SHARE A "DEMO" PROJECT.



PLEASE READ THE FORUM RULES BEFORE YOU POST:
http://www.wysiwygwebbuilder.com/forum/viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/getting_started.html
WYSIWYG Web Builder FAQ
Post Reply
drosen001
 
 
Posts: 30
Joined: Thu Jul 24, 2014 12:02 pm

MySQL CRUD search not working.

Post by drosen001 »

Created a simple database of 3 fields and am trying access it using MySQL CRUD control Adding a record works, but searching doesn't, always returns no records found.

Geting this error (hostname removed).

AH01215: PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www//wb.mysql.crud.php on line 133: /var/www/cgi-bin/cgi_wrapper/cgi_wrapper, referer: http:..../unsubscribe.html

Also, one of the fields is a date. Is there any way to have it default to today's date?
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: MySQL CRUD search not working.

Post by Pablo »

It is difficult to say anything meaningful about this without knowing the context of the error.
To be able to help you, I need to know all settings, the URL of the page, the PHP code and the database structure.

It works for me, as you can see here:
https://www.wysiwygwebbuilder.com/support/mysqlcrud.php
drosen001
 
 
Posts: 30
Joined: Thu Jul 24, 2014 12:02 pm

Re: MySQL CRUD search not working.

Post by drosen001 »

1. What PHP code are you referring to?

2. I don't see any items listed when I go to my page?

3. I would prefer the URL not be posted in a public forum as this is live data with user's email addresses. Is there a way to send it to you privately?
alan_sh
 
 
Posts: 1681
Joined: Tue Jan 01, 2019 5:50 pm

Re: MySQL CRUD search not working.

Post by alan_sh »

drosen001 wrote: Tue Dec 07, 2021 7:00 pm 1. What PHP code are you referring to?

2. I don't see any items listed when I go to my page?

3. I would prefer the URL not be posted in a public forum as this is live data with user's email addresses. Is there a way to send it to you privately?
I would suggest that, while you are testing, you create a dummy page with dummy data. It's never good to work on live data for the very reason you suggest - it could go public if you are not careful - which would fall foul of GDPR and could end up with a large fine.
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: MySQL CRUD search not working.

Post by Pablo »

1. What PHP code are you referring to?
In the workspace go to Page -> Page HTML
I don't see any items listed when I go to my page?
Are you sure all settings are correct?
Did you set a primary key, as documented in the PDF?
I would prefer the URL not be posted in a public forum as this is live data with user's email addresses. Is there a way to send it to you privately?
The best way to test new functionality is creating a DEMO project with only the extension and nothing else. Then you can also rule out potential conflicts with other scripts.

Note that I can only help you, if I know exactly what you have done.
Post Reply