PHP forum, your PHP coding community

Hi there. Thank you for replying to this. I'm sorry, I was at work (doint this "from work") and didn't realize I'd gotten a notification of reply on this. I solved the problem. It was due to the database field was not accepting alphanum, but the data being sent was alphanum. so i changed t...

Hello all. Hope you are well. Please have a look at this screenshot. I'm trying to fix this error, but the error doesn't make sense to me. At first, I thought I had it-- as the database field was Int, and the app is passing an alphnum string. I changed the field from int, text which didn't work, the...

Hi. I'm seeking guidance for learning how to create an OAuth2 secured API for WordPress. One resource, among others I've referenced: https://developer.wordpress.com/docs/oauth2/ It's a test project to demonstrate coding skill. The project instructions start by creating two WP instances in Docker con...

I just thought of something! I'm was able to do step-debugging from an IDE on Win w/ folders on local drive H:\Apache2\htdocs , "LAMP" on -> WSL -> Apache2 DOCUMENT_ROOT /mnt/h/Apache2/htdocs , and pointed the Windows -> some IDE location executable to E.g. H:\PHP\php.exe ...and it worked....

i don't know how to make the screenshot link work. feel free to delete it. Xdebug v3 - https://imgur.com/asJ6ZTE https://imgur.com/asJ6ZTE I figured as much about the debugging. I use VS Code, and tried various permutations of configurations. (there's a lot of settings i'm sure you're aware, options...

[ Xdebug ] I find it difficult to get any of the IDE's to cooperate with a step-debugging setup in my LAN LAMP dev environment. I've never tried debugging "remotely" like this before, and I'm afraid I've hit a roadblock. What do you recommend? I am doing LAMP dev work on my private LAN wit...

Sorry, this is only slightly relevant to your question, but I've not heard enough talk about Laragon. Is there a current release? I tried using it recently, but everything was pretty out of date. Pretty sure I got it from Github or a repo which i expected to be current.

Eureka! I was testing that query on 2 different databases. Turns out, I didn’t update the credentials for one of the two, so doh! $wpdb was working all along.

Thank you for reading, and the reply nevertheless.

(there's a weekend i'll never get back...)

This SQL query is is for a WordPress (WP) plugin ideally, whereby WP has it's own database abstraction, the global $wpdb . I would prefer to use $wpdb for extensibility / forward compatibility, but I can't get my SQL to work with it. Not super WP savvy yet, I regret. I couldn't get my query to work ...

Thank you! PDO is definitely what I needed here. Much appreciated.

I'm cool w/ that, and I am familiar w/ PDO.

Thank you. I was going to ask why it's necessary to use the module, but...

I appreciate your advice, and I'll do the research. Thank you very much!

​ the following SQL returns the data I need, but I don't know how to access it as I need with PHP. I can demo that the data can be used as I want as evidenced by output in a free PHP code generator by SQL Maestro, but it produces files dependent upon much more library code than I need.  I simply wan...