Ray Paseur

This is an old question, but there is a straightforward solution You can fetch the rows from the query results set and write them to an intermediate file with PHP fputcvsv(). Almost all Excel installations automatically associate the .CSV file sufix with Excel. Just fire up Excel and open the …

I don't think I can add a lot to the technology discussion, but maybe this will help put the task in perspective. https://en.wikipedia.org/wiki/Vistaprint VistaPrint trades under the market symbol CMPR https://finance.yahoo.com/quote/CMPR/profile?p=CMPR It is a multi-billion dollar company with numerous subsidiaries and international reach. The key executives make more than $8,000,000 …

Your instincts are spot-on. Of course it's possible, and all eCommerce sites work this way. You might want to check out the educational offerings from SitePoint. They have some great "getting started" resources for apps like this.

It would be most helpful if you can help us isolate the error. Some of the tools that can help are PHP function var_dump(), and a current list of the documents without any qualifications. For example, your post says, "I added line 23" and since the post says "Undefined variable: …

What is your front-end (or better yet, what is the URL of the site, so we can see the front-end)? A couple of things worthy of a search are "debounce" and, if you have jQuery, "scrollstop" since these will fire much less frequently than window.onscroll.

First thing to test - did the query work or fail? Add **var_dump($result);** after line 10 in *fetch.php* and run that script standalone, using a known good value for *$nip*. Before you go much further into this application, you may want to review the OWASP Guidelines for PHP and MySQL …

This should help you get started. Be aware that this is a trick question - there may be ties at the highest frequency, and the function will only return one value, so an equally deserving value will be lost. You might want to try discerning that condition and returning a …

The general design for this sort of thing is called "data expiration" and "garbage collection." You put a DATETIME column into the database table that gives the expiration date of the row. After your initial connection to the database, you use a DELETE query something like this (pidgin code): DELETE …

It's the 21st century so you want to be using object-oriented MySQLi now. Here's a teaching example showing how to do the basics in MySQLi. It's always wise to test for success and visualize any error messages. HTH, Ray <?php // demo/mysqli_example.php /** * Demonstrate some of the basics of …

Sometimes cache can help - it reduces repetitive trips to the data base and image libraries. There are services like YSlow that can help reveal the issues. If you can give us a link to the site, we may be able to offer more specific suggestions. Also, Happy New Year …

Here is an example showing the essential moving parts, HTH <?php /** * Clickable Buttons to Adjust a Counting Value in the PHP session */ error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('log_errors', TRUE); /** * Always start the PHP session on every page. * * Since it is a required feature of this …

This sounds like the list for 2017, but not to worry - those topics will still be around in 2019. My personal list would include * APIs (both production and consumption), * Security of applications and data, * GDPR compliance if you haven't already done it, * The changed posture …

This is an old topic, and there are more modern solutions available today (2019). Consider using the Iterators. Good online documentation is available here: http://php.net/manual/en/class.directoryiterator.php

Change to *error_reporting(E_ALL)* and PHP will tell you what is wrong. The script relies on an undefined variable, *$qname* and so PHP silently substitutes a null string. The resulting query string has a LIKE clause that says *LIKE '%%'* thus it matches everything.