php - Do not update with empty vars on UPDATE statement -

-

i trying run sql update dont want update when post vars empty.

code run :

require '../includes/db.php'; $settings_owner = ( isset($_post[wb_owner_field]) ? $_post[wb_owner_field] : false ); $settings_title = ( isset($_post[wb_title_field]) ? $_post[wb_title_field] : false ); $settings_description = ( isset($_post[wb_descr_field]) ? $_post[wb_descr_field] : false ); $settings_keywords = ( isset($_post[wb_keywd_field]) ? $_post[wb_keywd_field] : false ); $settings_id = ( isset($_post[wb_id]) ? $_post[wb_id] : false );  try {     $sql = "update website  set  website_owner = '$settings_owner', website_title = '$settings_title', website_description = '$settings_description', website_keywords = '$settings_keywords'  _id = '$settings_id'  ";      // prepare statement     $stmt = $conn->prepare($sql);      // execute query     $stmt->execute();      // echo message update succeeded     echo $stmt->rowcount() . " records updated successfully"; } catch (pdoexception $e) {     echo $sql . "<br>" . $e->getmessage(); }  $conn = null;

one way test value in update statement:

$sql = "update website       set  website_owner = if('$settings_owner' = '', website_owner, '$settings_owner'),          website_title = if('$settings_title' = '', website_title, '$settings_title'),          website_description = if('$settings_description' = '', website_description, '$settings_description'),          website_keywords = if('$settings_keywords' = '',  website_keywords, '$settings_keywords')      _id = '$settings_id'  ";

another way build update statement dynamically.

$sets = array(); if ($settings_owner != '') {     $sets[] = "website_owner = '$settings_owner'"; } if ($settings_title != '') {     $sets[] = "website_title = '$settings_title'"; } ... if (!empty($sets)) {     $sql = "update website set " . implode(', ', $sets) . " _id = '$settings_id'";     $stmt = $conn->prepare($sql);     $stmt->execute(); }

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