How to Check if a Record Exists in SQL Database Table with PHP


Have you been in a situation where you need to check if either a phone number or a user, for example, exists in your database? When I didn’t know how to do that, I looked through several articles looking for the best and most efficient way of doing it until I found this one.

1. Let’s say we have a table called ‘users’ and it has two columns: id, name. This is our table: Learn More

Tags: , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

nopCommerce Tips: Review of the nopEssentials Facebook Plugin for nopCommerce

Integrating your social media into your e-commerce solution is a terrific way to keep your customers engaged, and encourage your Facebook followers to cross over into your e-commerce site for their shopping. For e-commerce shops that leverage nopCommerce, this required a manual process to paste site links into their Facebook page. Today, we’ll review another alternative – the nopEssentials Facebook Plugin for nopCommerce.

Keesjan Van Roeden was kind enough to allow me to review a copy of the plugin. As of this time, versions 2.6, 2.65 and 2.7 are supported, and provided in the download. Also included is a .pdf file with step-by-step instructions on how to create your Facebook app, a prerequisite step for allowing your nopCommerce site to publish to your Facebook page using this plugin. The .pdf document is well-written, and the screenshots make it easy to follow along with the directions. Learn More

Tags: , , , , | Posted under nopCommerce | Leave a comment