Replace mysql query table prefix in php -

-

i writing database query manager class.in class table prefixes characterized #__. want replace them table prefix function.

the function wrote works slow. want optimized function (maybe regex or solution).

notice: please remember #__ should not replaced in quotes.

examples :

select p.*, m.member_name, m.member_alias #__posts p left join #__members m on m.member_id=p.post_author p.post_approve = '1' , p.post_date <= '1438252218'

or

insert `#__posts` (`post_title`, `post_text`)  values ('post title (maybe include #__ )'  , 'post text. can include #__')

my function: 

protected function replace_prefix($sql, $prefix = '#__')  {     $done = null;     $single = false;     $double = false;     $found = false;     $i = 0;     while (strlen($sql) > 0)     {         if ($sql[$i] == null)         {             return $done.$sql;         }         if (($sql[$i] == "'") && $sql[$i-1] !='\\')         {             $single = !$single;         }         if (($sql[$i] == '"') && $sql[$i-1] !='\\')         {             $double = !$double;         }          if ($sql[$i] == $prefix[0] && !$single && !$double)         {             $found = true;             ($j=0; $j < strlen($prefix); $j++)             {                 if ($sql[$i+$j] != $prefix[$j])                 {                     $found = false;                     break;                 }             }         }         if ($found)         {             $done .= substr($sql, 0, $i).$this->prefix;             $sql = substr($sql, $i+$j);             $found = false;             $i = 0;         }         else         {             $i++;         }          if ($i >= strlen($sql))         {             return $done.$sql;         }     }     return $done; }

finally found way! function 30 times faster old: 

protected function replace_prefix($sql, $prefix = '#__')  {     $array = array();     if($number = preg_match_all( '#((?<![\\\])[\'"])((?:.(?!(?<![\\\])\1))*.?)\1#i', $sql, $matches))     {         ($i = 0; $i < $number; $i++)         {             if (!empty($matches[0][$i]))             {                 $array[$i] = trim($matches[0][$i]);                 $sql = str_replace($matches[0][$i], '<#encode:'.$i.':code#>', $sql);             }         }     }      $sql = str_replace($prefix, $this->prefix , $sql);      foreach ($array $key => $js)     {         $sql = str_replace('<#encode:'.$key.':code#>', $js, $sql);     }      return $sql; }

Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more