9lessons Programming Blog - Tutorials about Angular, ReactJS, PHP, MySQL and Web Development
Showing posts with label Mysql. Show all posts
Showing posts with label Mysql. Show all posts
Sunday, April 19, 2020

Create a RESTful API using Node and Express with MySQL Database

Node Express web framework is a best solution to create RESTful APIs in quick time. Previously we published some concepts with different technologies like PHP and Java. This article will explain to you a more simple way to use external plugins to enrich your project APIs. Here you will find to create GET and POST requests with request payload validations to protect the endpoints.

Node Express MySQL RESTful

Monday, September 25, 2017

PayPal Express Checkout with PHP and MySQL

Most of the people prefer to shop online which made eCommerce to grow rapidly. But, what makes an excellent eCommerce site for the customers? The answer is - an excellent checkout process. There are several different payment options available in the market today. Out of all, Paypal is the most popular and convenient way to get paid. Making it as easy as possible for your customers to pay is essential for increasing conversions and sales. This is why your checkout page is critical. I have already discussed 2 checkout options in my previous articles BrainTree PayPal using PHP and Payment System which were in most trend till day. Now, a new checkout option has been introduced by Paypal which is Paypal Express Checkout option.

PayPal Express Checkout with PHP and MySQL

Sunday, February 05, 2017

Create a RESTful API using NodeJS and MySQL Database

These days, there are no projects that do not have a REST API for creating professional web services. REST ( Representational State Transfer) consists set of guidelines to build a web service, which can be used to modify or view specific information on the web without performing any server side operations. Using RESTful APIs saves huge amount of time. Twitter, Facebook, Google and thousands of companies use REST APIs. This is because REST is the most efficient and widespread standard in the creation of APIs for Internet services.

Create RESTful API NodeJS Mysql

Tuesday, April 12, 2016

PHP Login System with PDO Connection.

Very long back, we had published a simple PHP login system using PHP, which works only with MySQL database. Today, we are providing you an easy registration and login process using PDO connection with better password encryption, which has an advantage of working on different database systems. PDO is a PHP extension that allow us to implement code which is portable across many databases and platforms. This registration process is used in our Wall Script 8. Here is the demo of this cool & simple login / registration process.

PHP Login System with PDO Connection.

Sunday, April 03, 2016

Facebook Like Reactions using PHP, MySQL and Jquery.

Just a few days before, Facebook has launched Reactions, an extension of Like button. I succeeded in implementing the same in my WallScript 8, Build Your Own Social Network. Here is a quick and easy way to implement the Reactions using PHP,Jquery and PDO MySQL. It’s a basic idea of implementing the Reactions. Hope you enjoy the new Reactions for Like button..! Take a quick look at the live demo.

Facebook Like Reactions using PHP, MySQL and Jquery.

Monday, February 16, 2015

Facebook Style Background Image Upload and Position Adjustment.

I received many tutorial requests from my readers that asked to me how to design Facebook style ajax background image upload and position adjustment using Jquery. I have been published many tutorials about ajax image upload, this one is very interesting and it is a combination of many features. I has implemented this in Wall Script, this post will explain you how to design timeline HTML frame, CSS techniques and database design for background image system.

Facebook Style Background Image Upload and Position Adjustment.

Thursday, October 11, 2012

MySQL Event Scheduler

If you are running a large public web applications like shopping and emails portals, you have handle lots of unwanted data rows for example spam emails and unused shopping cart data. Sure it will created problem in database overload. So that I want to explain a simple tip called how to use MySQL event scheduler for deleting unwanted data rows from database.

RESTful Web Services with input parameters
Sunday, September 16, 2012

RESTful Web Services API using Java and MySQL

Are you working with multiple devices like iPhone, Android and Web, then take a look at this post that explains you how to develop a RESTful API in Java. Representational state transfer (REST) is a software system for distributing the data to different kind of applications. The web service system produce status code response in JSON or XML format.

RESTful Web Services using Java and MySQL
Monday, August 27, 2012

Java MySQL JSON Display Records using Jquery.

This is the continuation of my previous Java tutorial Insert Records into MySQL database using Jquery, now I want to explain how to convert records data into JSON data format and display JSON data feed using Jquery. It's simple just follow few steps with Eclipse IDE, hope you understand the Model View Controller pattern Thanks!

Java JSON Jquery Display Records
Sunday, August 12, 2012

Facebook Wall Script 5.0

Very Long days back I released a commercial script called Wall Script 4.0, It is a rich Jquery, PHP, MySQL application and collaboration of 9lessons blog tutorials. After many requests I’m releasing Wall Script 5.0 with extra features like friend relations, user authentication, news feed with existing Wall Script 4.0 features and implemented latest Jquery plugins Don't miss the video demo. Thanks

Facebook Wall Script
Wednesday, July 25, 2012

Java MySQL Insert Record using Jquery.

If you know Java concepts, you can easily understand any kind of language very quickly. If you want to became a good programmer, I strongly suggest start with J2EE programming. I heard that many people feels that it's though After long time I decided to write about J2EE programming with Jquery in a simple and better understanding way, hope you like it. Thanks!

Menu Design with JSON Data.
Wednesday, June 06, 2012

Facebook Style Dynamic Timeline for Wall Script.

Few months back I had posted any article about Facebook New Timeline Design HTML version using CSS and Jquery, after that I received many requests from wall script users and readers that asked to me how to convert this into dynamic with PHP and MySQL. This is an update for Wall Script 4.0 users to convert the user updates into timeline data visualization just take a look at the this live demo with multiple actions like scrolling results, commenting, updating, expanding and delete.

Facebook Style Dynamic Timeline for Wall Script.
Monday, August 29, 2011

Working with Foreign Languages using MySQL and PHP.

I received many tutorial requests from my readers that asked to me how to display and store foreign/regional language UTF-8 data into MySQL database using PHP code. This post explains you to solve Unicode data problems, just there steps you should follow take a quick look at this post.

UTF-8 using MySQL and PHP.
Wednesday, August 03, 2011

Wall Database Design

Writing a update on friend wall, this is the most important part in social networking sites. Famous networking sites are like Facebook and Orkut but people calling different like wall and scrap. Now Twitter testing this feature. I have enable this option in labs.9lessons.info. This post explains you how to design database and table relationships for posting a update on friend wall..

Wall Database Design
Friday, August 06, 2010

Dynamic Dependent Select Box using Jquery and Ajax

How to do dynamic dependent select box using Jquery, Ajax, PHP and Mysql. Dependent select box when a selection is made in a "Parent" box it allow to refresh a "child" box list data. In this post I had given a database relationship example betweent "catergory" and "subcategory". It's very simple jquery code hope you like this.
Dynamic Dependent select box
Thursday, July 15, 2010

Database Searching Techniques with SQL

Search box most important element on web pages specially contented management sites. In this post I want to explain very basic searching techniques and Unicode data searching using SQL LIKE statement. I hope you like this. Thanks

Search box techniques
Thursday, July 01, 2010

Stored Procedure Lesson

Are you writing Stored Procedures if not please take a look at this post. Stored procedures can help to improve web application performance and reduce database access traffic. In this post I want to explain how to create and call the stored procedures from database server.

Stored Procedure
Thursday, May 13, 2010

Join Tables Relationships with SQL

My previous post Database Design Create Tables and Relationships with SQL. This post is sequel how to join these tables and displaying proper data. I had used these SQL statements at labs.9lessons.info.

database design
Wednesday, April 21, 2010

Database Design Create Tables and Relationships with SQL

This post explains how to design typical relationaships database for socialmedia web application. Today I'm presenting my labs.9lessons application database relations design and SQL with diagrams. I hope you like this post.

9lessons Labs Database Design.
Sunday, February 14, 2010

Live Availability Checking with Java.

Some days I had posted an article about User name live availability checking with PHP and jquery. In this post my brother Ravi Tamada explained the same with Java technologies like JSP and servelts using MySQL database.

Live Availability Checking with Java.

mailxengine Youtueb channel
Make in India
X