How to insert data using Ajax Jquery?


Most Popular

Database backup using ssh linux

Here we are creating gz backup files using shell programming step1 . create backup file backup.sh step2. set cron job in control panel. #!/bin/bash ### MySQL Server Login Info ### MUSER="user" MPASS="Password" MHOST="localhost" MYSQL="$(which mysql)" MYSQLDUMP="$(which mysqldump)" BAK="backup/mysql" GZIP="$(which gzip)" NOW=$(date +"%d-%m-%Y") [ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/* FILE=$BAK/"databasename".gz $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS "databasename" | $GZIP -9 > $FILE
Keep reading

Tutorials Programme

Image
Loops Tutorials     Example While Loop #include <stdio.h> int main() { int count; count = 0; while (count < 4) { printf("The value of count is %d\n", count); count += 1; } return 0; } /* Result The value of count is 0 The value of count is 1 The value of count is 2 The value of count is 3 */
Keep reading

Import CSV to Database using PHP

Import csv database using PHP. Follow the following code and you will done with CSV import script using PHP. If you have any questions you can feel free comment we will reply you ASAP. PHP Code <?php if(isset($_POST["Import"])) { $filename=$_FILES["file"]["tmp_name"]; if($_FILES["file"]["size"] > 0) { $file = fopen($filename, "r"); mysql_query('truncate table table'); while (($data = fgetcsv($file, 10000, ",")) !== FALSE) { $sql = "INSERT into table(name,email,avg,sr,runs,wickets,hs,sixes,fours,longsixes,created) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]', now())"; mysql_query($sql); } fclose($file); echo ...
Keep reading