php - Fileupload.js + MySQL -

-

i'm kinda new in php javascript/jquery... i'm developing system must handle uploads. using fileupload.js works but... can't retrieve file info , store @ mysql name,extension,size,url ... when try got error message:

syntaxerror: unexpected token <

the code starts problems is:

<?php $options = array(     'delete_type' => 'post',     'db_host' => 'localhost:3306',     'db_user' => 'root',     'db_pass' => '123456',     'db_name' => 'house',     'db_table' => 'midias' );  error_reporting(e_all | e_strict); require('uploadhandler.php');  class customuploadhandler extends uploadhandler {      protected function initialize() {         $this->db = new mysqli(             $this->options['db_host'],             $this->options['db_user'],             $this->options['db_pass'],             $this->options['db_name']         );         parent::initialize();         $this->db->close();     }      protected function handle_form_data($file, $index) {         $file->title = @$_request['title'][$index];         $file->description = @$_request['description'][$index];     }      protected function handle_file_upload($uploaded_file, $name, $size, $type, $error,             $index = null, $content_range = null) {         $file = parent::handle_file_upload(             $uploaded_file, $name, $size, $type, $error, $index, $content_range         );          if (empty($file->error)) {             $sql = 'insert `'.$this->options['db_table']                 .'` (`name`, `size`, `type`, `title`, `description`)'                 .' values (?, ?, ?, ?, ?)';             $query = $this->db->prepare($sql);             $query->bind_param(                 $file->name,                 $file->size,                 $file->type,                 $file->title, // try change $_session[userid]                 $file->description // try change dateofupload             );             $query->execute();             $file->id = $this->db->insert_id;         }         return $file;     }      protected function set_additional_file_properties($file) {         parent::set_additional_file_properties($file);         if ($_server['request_method'] === 'get') {             $sql = 'select `id`, `type`, `title`, `description` `'                 .$this->options['db_table'].'` `name`=?';             $query = $this->db->prepare($sql);             $query->bind_param('s', $file->name);             $query->execute();             $query->bind_result(                 $id,                 $type,                 $title,                 $description             );             while ($query->fetch()) {                 $file->id = $id;                 $file->type = $type;                 $file->title = $title;                 $file->description = $description;             }         }     }      public function delete($print_response = true) {         $response = parent::delete(false);         foreach ($response $name => $deleted) {             if ($deleted) {                 $sql = 'delete `'                     .$this->options['db_table'].'` `name`=?';                 $query = $this->db->prepare($sql);                 $query->bind_param('s', $name);                 $query->execute();             }         }         return $this->generate_response($response, $print_response);     }  }  $upload_handler = new customuploadhandler($options);

i can't figure out whats happening, hope can give me light thank attention, , sorry huge code ;s

i experiencing same problem. couln't replace $file->anything specific value. tried 3, '3', "3" ... int or string. of returned same syntaxerror: unexpected token

my solution

$myvar = "hvhjvcvv"; $sql = 'insert `'.$this->options['db_table']             .'` (`randomfield`, `name`, `size`, `type`, `title`, `description`)'             .' values (?, ?, ?, ?, ?, ?)';  $query = $this->db->prepare($sql); $query->bind_param('ssisss', $myvar, $file->name, $file->size, $file->type, $file->title, $file->description); $query->execute(); $file->id = $this->db->insert_id;

hope help.

also note bad db connection return same error ;)


Comments

Post a Comment

Popular posts from this blog

c# - How Configure Devart dotConnect for SQLite Code First? -

-
can configure following sample code ? when run following code, error : no entity framework provider found ado.net provider invariant name 'devart.data.sqlite' setting in machine.config <system.data> <dbproviderfactories> <add name="dotconnect sqlite" invariant="devart.data.sqlite" description="devart dotconnect sqlite" type="devart.data.sqlite.sqliteproviderfactory, devart.data.sqlite, version=4.6.287.0, culture=neutral, publickeytoken=09af7300eec23701" /> </dbproviderfactories> </system.data> after add below block code in app.config <?xml version="1.0"?> <configuration>   <configsections> <!-- more information on entity framework configuration, visit http://go.microsoft.com/fwlink/?linkid=237468 --> <section name="entityframework" type="system.data.entity.internal.configfile.entityframeworksection, entit...
Read more

java - Copying object fields -

-
what best way of copying classes when need have 2 independent variables? have simple class: public class myclass { boolean = false; string b= "not empty"; } do need make method : assign(myclass data ) { a= data.a; b= data.b; } is there automatic method copy (duplicate) objects in java? do need make method : pretty close. instead of making method, should make constructor. such constructors called copy constructor , , create them this: myclass(myclass data) { = data.a; b = data.b; } and create copy of instance, use constructor this: myclass obj1 = new myclass(); myclass obj2 = new myclass(obj1); copy constructor can tedious : using copy constructor create deep-copy can tedious, when class has mutable fields. in case, assignment create copy of reference, , not object itself. have create copy of fields (if want deep copy). can go recursive. a better way create deep copy serialize , deserialize object. why not use clone()? ...
Read more

c++ - Clear the memory after returning a vector in a function -

-
i have function processes , stores lot of data in , returns results vector of class. amount of data stored in function tremendous , want clear storage memory of function after finished job. necessary (does function automatically clear memory) or should clear memory function? update: vector<customers> process(char* const *filename, vector<int> id) { vector<customers> list_of_customers; (perform actions) return list_of_customers; } variables defined locally within function automatically released @ end of function scope. destructors objects called, should free memory allocated objects (if objects coded correctly). example of such object std::vector . anything you've allocated new must have corresponding delete release storage. try avoid doing own allocation , use raii instead, i.e. containers or smart pointers.
Read more