Thursday, January 28 2021
In this post, we explained about How to start XAMPP automatically in Windows. If you want to auto start Apache and MySQL automatically in Windows 10, 8.1, and 7machines. Please do the below steps in your system. It might be helpful to launch the XAMPP in Windows.(more…)
Thursday, February 23 2017
In this post we have explained about how to create a RESTful API with HapiJS and NodeJS and MYSQL. Many web applications they provide API to access their data via RESTful. This process is called as web services. We have implemented RESTFUL API using NodeJS with MYSQL Database using Hapi JS web services.
Tuesday, May 24 2016
In this article we have explained about PHP Login and Registration System with PDO script. PDO connection is always secure and flexible support for all databases. PDO has an ease of code implementation. We were implement a sample PHP login and sign up system with PDO.
Thursday, May 05 2016
In this post we have explained about how to create multiple database connection in codeigniter. Please do the following changes in your files.
Change the below following things in your config.php
$active_group = 'default'; $active_record = TRUE;
Monday, April 25 2016
We had published after long time back article about SQL injection. First of all explain what is sql injection.To avoid the unwanted peoples are access your database without your knowledge i.e hacking.When the system (website) to ask the input from users in that time we won’t directly pass the input to the database we must validate the inputs.
Following things are to prevent the user input :
If you got the input from users, you have to validate using regular expressions for example.
Friday, April 22 2016
In MySql select query we can customize the order of display the result as our wish. The following query I hope it will give some clear ideas do more thoughts in your future queries.
SELECT * FROM users_ranking ORDER BY field(rank_position,'1','2','3','6','4','5'),email ASC
Friday, April 22 2016
Guys you are trying to insert data from one of your existing table to another existing table or same table in mysql you can use SQL Insert into Select Query. The following query will explain
INSERT INTO users (user_id,username,email,password) SELECT user_id,username,email,password FROM users;
You can add where clause too,
INSERT INTO users (user_id,username,email,password) SELECT user_id,username,email,password FROM users Where user_id <= 5;