php - Adding column if not exists in sql Opencart -

-

i creating model in open cart. using vqmod writing code in model. want alter table adding coloumn if not exists in table. here code.

$field_name = 'geozoneid'; $col = $this->db->query("select ".$field_name." ".db_prefix."order");      if (!$col){             $this->db->query("alter table ".db_prefix."order add ".$field_name." int(11) first");             $zone_id=array();     $zone_id=$this->db->query("select zgz.geo_zone_id  `oc_zone_to_geo_zone` zgz   zone_id = (select shipping_zone_id oc_order order_id = '".$order_id."' ) ");     $zone_id=$zone_id->row['geo_zone_id'];     $query=$this->db->query("update  `oc_order` set geozoneid ='".$zone_id."' order_id ='".$order_id."'");                         }       else {     $zone_id=array();     $zone_id=$this->db->query("select zgz.geo_zone_id  `oc_zone_to_geo_zone` zgz   zone_id = (select shipping_zone_id oc_order order_id = '".$order_id."' ) ");     $zone_id=$zone_id->row['geo_zone_id'];     $query=$this->db->query("update  `oc_order` set geozoneid ='".$zone_id."' order_id ='".$order_id."'");                          }

i dont know why not executing not alter tabel.

i ended fixing problem this..

$hasmodelchoicefield = false; $result = $this->db->query( "describe `".db_prefix."order`;" ); foreach ($result->rows $row) { if ($row['field'] == 'geozoneid') { $hasmodelchoicefield = true; break;  }  }  if (!$hasmodelchoicefield) {  $sql = "alter table `".db_prefix."order` add geozoneid int( 11 ) character set utf8 collate utf8_general_ci  default ''";  $this->db->query( $sql );  $zone_id=array();  $zone_id=$this->db->query("select zgz.geo_zone_id `" . db_prefix . "oc_zone_to_geo_zone`  zgz zone_id = ( select shipping_zone_id `".db_prefix."order`where order_id = '".$order_id."' ) ");$zone_id=$zone_id>row['geo_zone_id'];$query=$this->db->query("update  `" . db_prefix . "order` set geozoneid ='".$zone_id."' order_id ='".$order_id."'");  } else{     $zone_id=array();     $zone_id=$this->db->query("select zgz.geo_zone_id from`oc_zone_to_geo_zone` zgzwhere zone_id = ( select shipping_zone_idfrom oc_orderwhere order_id = '".$order_id."' ) ");$zone_id=$zone_id->row['geo_zone_id'];$query=$this->db->query("update  `" . db_prefix . "order` set geozoneid ='".$zone_id."' order_id ='".$order_id."'");

}


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more