Create a Product Grid using Json

09:30:00 0 Comments

Here is the Part 1
 

Here is the Part 2
 

Here is the Part 3
 

Here I have posted all the three Videos to Create the product Grid.
Download the project from here
http://joethemes.com/?ddownload=7455

Dear Guys in this video I show you how to populate the product grid with JSON data.Note that this JSON data was created using PHP language.Comment your doubts below in the comment section.
Share this Video with your friends if you found this helpful!

View my Blog
http://www.joelwebsites.com

View my Website
http://www.joethemes.com


Subscribe to my channel http://www.youtube.com/subscription_center?add_user=joeljfernandes

Recommended BlueHost Webhosting
https://www.bluehost.com/track/easyregistration/

0 comments:

Remove background noise from videos using Adobe Premier Pro cc

09:20:00 0 Comments





View my Blog

http://www.joelwebsites.com



Subscribe to my channel http://www.youtube.com/subscription_center?add_user=joeljfernandes



RELATED VIDEOS



fade volume

https://youtu.be/gBxbp0fy30I



Improve audio

https://youtu.be/loz4nP_KZkU



Dear Guys,

In this Video I show you how to remove noise from audio using denoiser it is an easy tutorial and should be easy to follow.

I hope you enjoy watching the video thank you.

0 comments:

#Angular & JavaScript Series - On Ready function & Asynchronous code

09:18:00 0 Comments



Dear Guys This is the third Video in the Series I show you about the On Ready function and some small explanation for Asynchronous Javascript Code..

View My Blog
http://www.joelwebsites.com

Subscribe to my channel for More Videos :)
http://www.youtube.com/subscription_center?add_user=joeljfernandes

0 comments:

Cheap lighting for videos | Create Good Videos | Importance of lighting ...

09:17:00 0 Comments



Dear Guys,
I have tried to improve the lighting in my house to so thought I will show you what difference it made...
I how cost effective it is to improve video quality by just improving the lighting!
I hope that you enjoy watching this Video.Take Care Guys!


View my Blog
http://www.joelwebsites.com

Subscribe to my channel http://www.youtube.com/subscription_center?add_user=joeljfernandes

0 comments:

Moon Timelapse Video | Magic Lantern | Canon 700d T5i 55-250 mm kit lens...

09:16:00 0 Comments





Dear Guys,

I thought of Creating this video to show you how to Video Record the moon.

I used the zoom kit lens lens 55-250 mm to record the video.I used the magic crop in magic lantern to obtain the zoom,

I hope that this Video was useful to help you know the settings that I have used.

I hope you enjoyed watching the Video!



Song in this video

DEAF KEV - Invincible



View my Blog

http://www.joelwebsites.com



Subscribe to my channel http://www.youtube.com/subscription_center?add_user=joeljfernandes

0 comments:

Create your Website in Minutes free | Create a Website Easy Tutorial

09:15:00 0 Comments





Visit Wix Using this link

http://wixstats.com/?a=7163&c=124&s1=



View the Website here

http://joeljfernandes.wix.com/joelwebsites



Dear Guys in this Video I show you how I Create a Very simple yet powerful website.This website can be used for your business purposes too since it its Very Elegant and Professional.



Many people think that Website Creation is a very complicated task and difficult but in this Video I have proved you wrong.

I hope you have enjoyed watching this Tutorial.



View my Blog

http://www.joelwebsites.com



Subscribe to my channel http://www.youtube.com/subscription_center?add_user=joeljfernandes

0 comments:

#DoNotLitter KEEP THE PLACE YOU LIVE CLEAN | Joel Vlog at Bhuigauv beach...

09:06:00 0 Comments



Dear Guys in this Video I show you the beach in Vasai.This beach is called bhuigao beach.This Beach is a really beautiful beach but few days ago I visited the beach I found the surrounding littered with a lot of plastic bags and many funny things I urge you to share this page with others so that people are always aware to keep their surrounding clean.Take care guys.Stay updated for more Videos.

0 comments:

sqllite Easy Tutorial

07:38:00 0 Comments



Here is the Video


Dear Guys,
In this Video I show you how to set up a simple Sqlite database using js.This database will be very useful for you Cordova or phone gap app database.I hope you enjoy watching this Video.
Share your thoughts and questions below.Take care Guys!

View my Blog
http://www.joelwebsites.com

Subscribe to my channel http://www.youtube.com/subscription_center?add_user=joeljfernandes

Below is the code to help you understand the basic Note that the same code was used in the Video.


function DBHelper() {
    var database = window.openDatabase("DoctorChat", "1.0", "DoctorChat", 200000);
    return database;
}

function SuccessDB(tx) {
    alert('Successfully Inserted.');
    
}

function SucessCreateTable(tx) {
    //alert('Successfully Table Created.');
  
}

function ErrorDB(error) {
    alert('Error : ' + error.message);
}

function ErrorInsertDB(error) {
    alert('Error when inserting : ' + error.message);
}

var Syncanswertable = function () {
alert('Syncanswertable');
//PRIMARY KEY (ID),
    
     var url = 'http://joethemes.com/chatadmin/webservices/getanswers.php?uid=1';
     $.post(url, function(data){
    DBHelper().transaction(function (tx) {
   tx.executeSql('CREATE TABLE IF NOT EXISTS app_getanswers(ID Text, question Text, answer Text, weight Text, synonyms Text, other Text)');
});

//DBHelper().transaction(function (tx) { tx.executeSql("DELETE FROM app_getanswers"); });

DBHelper().transaction(function (tx) {

        
       
        var length = localStorage.getItem('length');
        
        if(length == null){length = 0;}
        
        
        alert(length+'i am length');
        if(length < data.length){
            
        localStorage.setItem('length',data.length);
        alert(data.length+'i am getanswers');
        tx.executeSql("DELETE FROM app_getanswers");
   for (var cnt = 0; cnt < data.length; cnt++) {

       var ID = data[cnt].CashRegisterID;
       var question = data[cnt].question;
       var answer = data[cnt].answer;
       var weight = data[cnt].weight;
       var synonyms = data[cnt].synonyms;
       var other = data[cnt].other;

       tx.executeSql("INSERT INTO app_getanswers(ID, question, answer, weight, synonyms, other) values('" + ID + "', '" + question + "', '" + answer + "', '" + weight + "', '" + synonyms + "', '" + other + "' " + ");");
   }
}
 
}, ErrorDB, SucessCreateTable);
           /* DBHelper().transaction(function (tx) {
       // NOT NULL AUTO_INCREMENT
       tx.executeSql('CREATE TABLE IF NOT EXISTS app_getanswers(ID Text, question Text, answer Text, weight Text, synonyms Text, other Text,UNIQUE (question))');
   
    }, ErrorDB, SucessCreateTable);

    var url = 'http://joethemes.com/chatadmin/webservices/getanswers.php?uid=1';
     $.post(url, function(data){
   //alert(JSON.stringify(data)+'i am getanswers');
         //var getanswers = data; " + "
         
         
         for (var i = 0; i < data.length; i++) {
             
             //alert(data[i].question);
             var queryss = "INSERT OR REPLACE INTO app_getanswers(ID, question, answer, weight, synonyms , other) values( '" + data[i].ID + "'  , '" + data[i].question + "'  , '" + data[i].answer + "'  , '" + data[i].weight + "' , '" + data[i].synonyms + "' , '" + data[i].other + "' ); ";
                 alert(queryss);
             
             
             
             DBHelper().transaction(function (tx) {
       // NOT NULL AUTO_INCREMENT
                 
                 
       tx.executeSql(queryss);
   
    }, ErrorInsertDB, SuccessDB);
             
         }
         
         //var strQuery="INSERT INTO app_getanswers(ID, question, answer, weight, synonyms, other) Values(?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE subs_name     = VALUES("+subs_name+"),subs_birthday = VALUES("+subs_name+")";
            
         /*   $.each(data.d, function (index, store) {
            alert(store.StoreID);
            DBHelper().transaction(function (tx) {
            tx.executeSql(strQuery,[store.StoreID, store.Name, store.Address, store.State, store.City, store.CountryName]);
            }, ErrorDB, SuccessDB);
            
            });  
         
         
         */
         
        
    }).fail( function(jqXHR, textStatus, errorThrown) {
  alert('error occured');
});
    }
Syncanswertable();

function GetAnswers(question)
{
    // WHERE question LIKE %"+question+"%
    //alert('hi i amget answers');
    
    return new Promise(function(resolve, reject) {
    var question = 'hi';
var sqlData = "SELECT * FROM app_getanswers WHERE question LIKE '%"+question+"%'";
    alert(sqlData);
    DBHelper().transaction(function (tx) {
        tx.executeSql(sqlData, [], function (tx, results) {

            for (var i = 0; i < results.rows.length; i++) {
                //alert(results.rows.item(i).answer+'i am the answer');
                
                var answer = results.rows.item(i).answer;
                alert(answer);
                resolve(answer);
            }
            
        });
    },ErrorDB, function (data) {
        alert('success');
    });
    
     });       
   //return 5; 
}



0 comments: