How to change the background, text or a div color on real time with php, mysql, ajax and jQuery ?

Description:- Hello! In this lesson I’ll show you guys the logic with little example to how to change the background, text or a div color on real time with php, mysql, ajax and jQuery.
Maybe you guys have better logics to shorten my code. If you have then please comment below.

So for this lesson make the following files step by step:-
1. create database and name it “color”
2. create row in database(color) and name it colorname
3. Create 2 columns 
    (i) id
    (ii) colorcode
4. Download jQuery file
5. Create changebg.php
6. Create config.php
7. Create insertcolor.php

1. config.php

pdf of config file

2. changebg.php

pdf of changebg file

3. insertcolor.php

pdf of insertcolor file

*NOTE :- I’m providing you pdf files as my wordpress text editor is not working well copy and paste code and make the php files with the same name of files and then goto your browser after making database and then run the changebg.php file.
Live demo is available here

How to create dynamic, responsive image slider with PHP, mysqli, bootstrap and jQuery ?

Description :- In this lesson I’m gonna provide the code from which you guys can easily make fully Dynamic Carousel  Silder from which you’ll fetch image name from database and images from your img folder.

Establishing Database:-
Now, I know that you all guys know how to create new database and name it slider after this create new table and name it images and make 2 rows
(i) id
(ii) img 
And then insert your image name with extension into the img row .

Now follow some simple steps for setting up everything which we need for this lesson:-
1. Download the bootstrap
2. Download jquery file from jquery.com
2. Create a new folder and rename it as img and put some images in it.
3. Create a new folder and rename it as css and make app.css in the css folder
4. Create an index.php file
5. Create config.php file (the connection file to our database)

1. config.php   (the connection file)

<?php
$con = mysqli_connect("localhost","root","","slider");
if(mysqli_errno($con))
{
 echo mysqli_error(); 
}
?>

2. index.php  (the file where your silder code lives with some jquery lines)

There are some problems with wordpress text editor so I’m providing pdf of index.php copy from pdf and make index.php
Copy code from this link

3. app.css   (lives in css folder)

.

a.carousel-control {
 opacity: 1;
 height: inherit;
 width: inherit;
 background: none;
 text-shadow: none;

}
.prevSlide
{
 color: #f5f5f5;
 font-size: 2em;
 position: absolute;
 top: 50%;
 left: 0;
 background-color:rgba(0,0,0,0.5);
 transform: translate(0,-50%);
 padding: 0 10px;
}
.prevSlide:hover
{
 color:rgba(247,148,30,1);
 background-color:rgba(0,0,0,0.8);
}
.nextSlide
{
 color: #f5f5f5;
 font-size: 2em;
 position: absolute;
 top: 50%;
 right: 0;
 background-color:rgba(0,0,0,0.5);
 transform: translate(0,-50%);
 padding: 0 10px;
}
.nextSlide:hover
{
 color:rgba(247,148,30,1);
 background-color:rgba(0,0,0,0.8);
}

*Note:- My final product screenshot is this except the images in the slider you will get the same result.

Thanks 🙂

slider

index

How to get image from url and insert into database and store image in your local root folder through PHP and mysql?

Description:- Hi ! In this tutorial I’m going to provide you code to get the image from url and then to store in the database as well in your local root directory or in a folder.
You can also include this type of image search thing in your website so that user will get limitless option to upload a picture.
I use rand() function to rename the image name and it will be helpful for you when you make a large website. 

This chapter will complete in 3 different steps:-
1. Make index.php
2. Make a new folder in which your image will store and rename that folder as ‘image’
3. Make a new database and give it a name mukulexp

1. index.php

<?php
// connection to database
$con = mysql_connect("localhost","root","");
mysql_select_db('mukulexp',$con) or die("could not connect");
?>
<?php
if(isset($_REQUEST['subimg']))
{
 // Your file
 $file = $_REQUEST['url'];
 
// Open the file to get existing content
$data = file_get_contents($file);
$newimage=rand()."abc.jpg";
// New file
$new = 'image/'.$newimage;
// Write the contents back to a new file
file_put_contents($new, $data);
mysql_query("Insert into image set name = '$newimage' ");
 echo "<img src='image/$newimage' width='300px' height='250px'/>";
}
?>
<form action="" method="post" enctype="multipart/form-data">
<input type="url" name="url"/><br/><br/>
<input type="submit" name="subimg" value="submit"/> 
</form>

2. Make a new folder and rename it as image

3. Make a new database and give it a name of mukulexp and then enter in your mukulexp and click on SQL and paste the below code or make the table by yourself and name it image and then make 2 columns in it first id and second name

CREATE TABLE IF NOT EXISTS `image` (
 `id` int(90) NOT NULL AUTO_INCREMENT,
 `name` varchar(4000) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `image`
--
INSERT INTO `image` (`id`, `name`)

NOTE : – Do all the above point as they are mentioned. Watch video for help
Happy Coding 🙂