Posts
 
Reputation
Joined
Last Seen
Ranked #539
Strength to Increase Rep
+1
Strength to Decrease Rep
-0
84% Quality Score
Upvotes Received
18
Posts with Upvotes
14
Upvoting Members
5
Downvotes Received
2
Posts with Downvotes
2
Downvoting Members
2
4 Commented Posts
2 Endorsements
Ranked #621
Ranked #13.1K
Ranked #4K
~30.0K People Reached
Favorite Forums
Favorite Tags
Member Avatar for Bile

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 …

Member Avatar for juniperoites
1
4K
Member Avatar for tun712

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 …

Member Avatar for Mara_2
1
4K
Member Avatar for Michael_93

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.

Member Avatar for NettSite
1
2K
Member Avatar for ChrisJ

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: …

Member Avatar for coreyavis
0
309
Member Avatar for FarrisFahad

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.

Member Avatar for Ray Paseur
0
3K
Member Avatar for ariowishnu

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 …

Member Avatar for Ray Paseur
0
457
Member Avatar for abdallah mohamad

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 …

Member Avatar for abdoosh
0
4K
Member Avatar for praise23

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 …

Member Avatar for Ray Paseur
-1
235
Member Avatar for keaikitse

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 …

Member Avatar for Ray Paseur
0
3K
Member Avatar for begazed

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 …

Member Avatar for Trasser
0
641
Member Avatar for Michael_93

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 …

Member Avatar for Ray Paseur
0
4K
Member Avatar for youngg69

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 …

Member Avatar for Ray Paseur
-1
575
Member Avatar for jej1216

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

Member Avatar for Ray Paseur
0
3K
Member Avatar for Michael_93

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.

Member Avatar for Ray Paseur
0
483