sqlite - How to upload database using Dropbox? -


i've created barcode scanner app , have database of barcode. want upload/sync database company's server programmer can , build website ui. unfortunately, our server not public (but can connect internet through proxy), want use dropbox that. please give me useful sample code or tell me best way upload/sync database in case? extremely grateful help!

alright, assuming database mysql db host environment lets run cron jobs, access ftp, etc... here's possible code snippet you, had myself dropbox api, can read full post here walk-thru (dropbox api , mysql db dump/upload

<?php # include dropbox sdk libraries require_once __dir__."/dropbox-sdk/lib/dropbox/autoload.php"; use \dropbox dbx; //your access token dropbox app panel $accesstoken = 'not-a-real-token-replace-this-qm8js0z1w1t-replace-this-token';  //run mysql dump , zip;  // location of temp directory $tmpdir = "your_temp_dir"; // username mysql $user = "db_user"; // password mysql $password = "db_password"; // database name backup $dbname = "db_name"; // hostname or ip database resides $dbhost = "your_hostname"; // zip file have prefix $prefix = "sql_db_";  // create database backup file $sqlfile = $tmpdir.$prefix.date('y_m_d_h:i:s').".sql"; $backupfilename = $prefix.date('y_m_d_h:i:s').".tgz"; $backupfile = $tmpdir.$backupfilename;  $createbackup = "mysqldump -h ".$dbhost." -u ".$user." --password='".$password."' ".$dbname." --> ".$sqlfile; //echo $createbackup; $createzip = "tar cvzf $backupfile $sqlfile"; //echo $createzip; exec($createbackup); exec($createzip);  //now run dbox app info , set client; naming app folder sql_backup change actual app folder name;  $appinfo = dbx\appinfo::loadfromjsonfile(__dir__."/config.json"); $dbxclient = new dbx\client($accesstoken, "sql_backup");   //now main handling of zipped file upload;  //this message send in system e-mail cron job (assuming set cron email you); echo("uploading $backupfilename dropbox\n");  //this actual dropbox upload method; $f = fopen($backupfile, "rb"); $result = $dbxclient->uploadfile('/sql_backup/'.$backupfilename, dbx\writemode::force(), $f); fclose($f);  // delete temporary files unlink($sqlfile); unlink($backupfile);  ?>

you need make config.json file so:

{ "key": "your_key_from_dropbox_app_panel", "secret": "your_secret_from_dropbox_app_panel" }

you need create new dropbox app under dropbox account key , secret, , generate auth code username, here when logged in: https://www.dropbox.com/developers/apps

you need download dropbox php sdk library put on server in same folder php code above, find here: https://www.dropbox.com/developers/core/sdks/php

hope helps; if need more step-by-step or developer does, go link @ top full walk through.


Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more