php - Can not update photo into a database using PDO -


the code save photo inside folder in root, in database not save rute photo...can me this.

here form:

<form class='form-horizontal' method='post' action='' enctype='multipart/form-data'>             <fieldset>             <legend><i class='icon32 icon-wrench'></i>configuración general del sistema</legend>              <div class='control-group'>                 <label class='control-label' for='typeahead'>nombre de la clínica</label>                 <div class='controls'>                     <input type='text' class='span6 typeahead' name='nombre_clinica'                          value='<?php echo $nombre_clinica;  ?>' />                 </div>             </div>             <div class='control-group'>                 <label class='control-label' for='typeahead'>dirección</label>                 <div class='controls'>                     <input type='text' class='span6 typeahead' name='direccion'                          value='<?php echo $direccion;  ?>' />                 </div>             </div>             <div class='control-group'>                 <label class='control-label' for='typeahead'>número de teléfono</label>                 <div class='controls'>                     <input type='text' class='span6 typeahead' name='telefono_clinica'                          value='<?php echo $telefono_clinica; ?>' />                 </div>             </div>             <div class='control-group'>                 <label class='control-label' for='typeahead'>viñeta de página web</label>                 <div class='controls'>                     <input type='text' class='span6 typeahead' name='titulo_clinica'                          value='<?php echo $titulo_clinica; ?>' />                 </div>             </div>             <div class='control-group'>                 <label class='control-label' for='typeahead'>logo clínica</label>                 <div class='controls'>                     <input type="hidden" name="max_file_size" value="200000" /> <input data-clear-btn="true" class="input-file uniform_on" name="logo" id="fileinput" value="nopic.jpg" type="file" accept="image/png, image/jpeg"/>                      <br />                     <img style='max-height:80px;' src='../images/<?php echo $logo; ?>' />                 </div>             </div>             <div class='control-group'>                 <label class='control-label' for='typeahead'>meta tag del software clínico</label>                 <div class='controls'>                     <input type='text' class='span6 typeahead' name='page_meta_tag'                          value='<?php echo $page_meta_tag; ?>' />                 </div>             </div>             <div class='control-group'>                 <div class='controls'>             <input type='hidden' name='id' value='<?php echo $id ?>' /><input type='hidden' name='action' value='update' />             <input type='submit' class='btn btn-primary' value='actualizar configuracion' />                 </div>             </div>             </fieldset>          </form>

and here code:

    <?php include '../include/update_config.php';  $conn = new pdo("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);  $action = isset( $_post['action'] ) ? $_post['action'] : ""; if($action == "update"){         try{ move_uploaded_file($_files['logo']['tmp_name'], "../images/" . $_files['logo']['name']);              $query = 'update configuracion set id = :id, nombre_clinica = :nombre_clinica, direccion = :direccion, telefono_clinica = :telefono_clinica, titulo_clinica = :titulo_clinica, logo = :logo, page_meta_tag = :page_meta_tag id = 0';                 $stmt = $conn->prepare($query);                  $stmt->bindparam(':nombre_clinica', $_post['nombre_clinica']);                 $stmt->bindparam(':direccion', $_post['direccion']);                 $stmt->bindparam(':telefono_clinica', $_post['telefono_clinica']);                 $stmt->bindparam(':titulo_clinica', $_post['titulo_clinica']);                 $stmt->bindparam(':logo', $_post['logo']);                 $stmt->bindparam(':page_meta_tag', $_post['page_meta_tag']);                 $stmt->bindparam(':id', $_post['id']);                  // execute query                 $stmt->execute();                  echo "registro actualizado correctamente.";          }catch(pdoexception $exception){                  echo "error: " . $exception->getmessage();         } }  try {          $query = "select nombre_clinica, direccion, telefono_clinica, titulo_clinica, logo, page_meta_tag configuracion id = 0";         $stmt = $conn->prepare( $query );          $stmt->bindparam(1, $_request['id']);          $stmt->execute();          $row = $stmt->fetch(pdo::fetch_assoc);          $id = $row['id'];         $nombre_clinica = $row['nombre_clinica'];         $direccion = $row['direccion'];         $telefono_clinica = $row['telefono_clinica'];         $titulo_clinica = $row['titulo_clinica'];         $logo = $row['logo'];         $page_meta_tag = $row['page_meta_tag'];   }catch(pdoexception $exception){          echo "error: " . $exception->getmessage(); }   ?>

the photo save succesfully in folder ../images/

$path = "images/" . $_files['logo']['name']; move_uploaded_file($_files['logo']['tmp_name'], "../".$path); ... $stmt->bindparam(':logo', $path);

Comments

Post a Comment

Popular posts from this blog

user interface - Python attempting to create a simple gui, getting "AttributeError: 'MainMenu' object has no attribute 'intro_screen'" -

complete newbie here python started learning language few days ago (with no programming experience beforehand). i'm bashing skull against desk here, trying create 1 menu button lead menu, supposed replace/hide/destroy previous menu (either works, long process can reversed). what i've come far: import wx class mainframe(wx.frame): def __init__(self): wx.frame.__init__(self, none) self.centre() self.main_menu = mainmenu(self) self.intro_screen = introscreen(self) self.intro_screen.hide() class mainmenu(wx.frame): def __init__(self, parent): wx.frame.__init__(self, parent=parent) self.main_menu = mainmenu panel = wx.panel(self) sizer = wx.boxsizer(wx.vertical) nextscreen = wx.button(panel, label='next screen', size=(150,30)) nextscreen.bind(wx.evt_button, self.nextscreen) sizer.add(nextscreen, 0, wx.center|wx.all, 5) self.show() self.c...
Read more

jquery - Common JavaScript snippet to share files on Google Drive, Dropbox, Box.net or SkyDrive -

this first assignment of file sharing. need share files our website above mentioned locations. currently, have been exploring each service’s api file sharing. question 1 : there javascript code snippet available (like addthis.com ) share files? question 2 : should use server side coding file sharing or javascript advisable? thanks viewers. found useful plug-in named "ink file picker". saves given http file resource directly users online storage engine. url: https://developers.inkfilepicker.com/docs/web/ live example: http://ctrlq.org/save/
Read more

Android Gson.fromJson error -

i've completed tutorial how connect json url , parse content using gson library. code works fine url specified in tutorial, tryed modify work this url . tryed display 1 field second ulr, base field, can't work. here code, please help: public class jsonparsingactivity extends activity { string url = "http://api.openweathermap.org/data/2.5/weather?q=london,uk"; @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.main); inputstream source = retrievestream(url); gson gson = new gson();// main gson class reader reader = new inputstreamreader(source); searchresponse response = gson.fromjson(reader, searchresponse.class); //gson.fromjson(string, class) toast.maketext(this, response.base, toast.length_short).show(); } private inputstream retrievestream(string url) { defaulthttpclient client = new defaulthttpclient(); httpget getrequest = new httpget(url);...
Read more