PHP - Multipule Drop Down Menus On An Update Page - How To Omit Unselected Fields

HI All,

I am writing a prepared statement to update some user information.

Included in this table are the username and password fields. 

In this particular form, i dont want the user to have access to this information and have built a form that only shows what i want them to be able to change.

The bit that i am not sure about is the prepared statement that i am writing.

I am getting a boolean error suggesting that my prepare failed and i think this may be because i have not named every field in the table.

To give an idea of the table fields i have pulled this from php my_admin (this is not the sql i am running)

UPDATE `ssm_user` SET `user_id`=[value-1],`user_email`=[value-2],`user_password`=[value-3],
`user_firstname`=[value-4],`user_lastname`=[value-5],`user_accountlevel`=[value-6],
`user_mobile`=[value-7],`user_role`=[value-8],`user_lastlogondate`=[value-9] WHERE 1

my prepared statement is

$stmt = $conn->prepare("
			UPDATE ssm_user 
			SET 
			user_email=?,
			user_firstname=?,
			user_lastname=?,
			user_accountlevel=?,
			user_mobile=?,
			WHERE user_id = ?
			");

		$stmt->bind_param('sssssi', $email, $fname, $lname, $accountlevel, $mobile, $uid);
    	$stmt->execute();
    	return $stmt->affected_rows;

Do i have to declare every field in the table or is there something that i am missing here.

$register_ep_data = array(
			'show' => $name,
			'season' => $srNum,
			'ep' => $epNum,
			'app_name' => $epName,
			'tag' => $tag,
			'app_about' => $desc,
			'app_website' => $imdb,
			'app_release' => $release,
			'type' => $type,
			'app_code' => $Frame 
			);

array_walk($register_ep_data, 'array_fu');

$fields = '`' . implode('`, `', array_keys($register_ep_data)) . '`';
$data = '\'' . implode('\', \'', $register_ep_data) . '\'';

$epFound = false;
$id = 0;
	 
while ($ep_list_data = mysql_fetch_array($turtle)) {

     $id = $ep_list_data['app_id'];

     $currentNAME = $ep_list_data['app_name'];
     $SERIES = $ep_list_data['show'];

     if ($SERIES == $name) {

        if ($currentNAME == $epName) {
              $epFound = true;
              break;
	}

      }

   }

   if ($epFound) {
      mysql_query("UPDATE `games` SET ($fields) VALUES ($data) WHERE `app_id` = '$id'");
   } else {
      mysql_query("INSERT INTO `games` ($fields) VALUES ($data)");
   }

HI,

I have a user form on a modal.

The user can be updated from this modal but on the second tab is where the users password can be updated.

The update button commits all changes including the password update.

If the New Password field is blank i do not want it to be updated.

I am using a prepared statement and am not sure how to ommit a field if it is blank.

In actual fact there is a new password and a confirm password field which must be the same before the password field is updated.

if ($_SERVER['REQUEST_METHOD']=='POST'){
	$uid = $_POST['UM-uid'];
	$fname = $_POST['UM-firstName'];
	$lname = $_POST['UM-lastName'];
	$email = $_POST['UM-emailAddress'];
	$accountlevel = $_POST['UM-accountLevelId'];
	$mobile = $_POST['UM-mobileNumber'];
	$roleid = $_POST['UM-roleId'];
	$newpass = password_hash($_POST['UM-pass'], PASSWORD_DEFAULT);


	if(!empty($_POST['UM-firstName'])){
		// prepare stmt
		$stmt = $conn->prepare("
			UPDATE ssm_user 
			SET 
			user_password=?,
			user_email=?,
			user_firstname=?,
			user_lastname=?,
			user_account_level_id=?,
			user_mobile=?,
			user_role_id=?
			WHERE user_id = ?
			");

		$stmt->bind_param('sssssssi', $newpass, $email, $fname, $lname, $accountlevel, $mobile, $roleid, $uid);
    	$stmt->execute();
    	$_SESSION['user']=$fname." ".$lname;
    	$_SESSION['updateUser']="has been successfully updated";
    	$_SESSION['actionstatus']="success";

I am sure i will be able to work out the password confirmation part, its just the omitting password from being part of the update if blank.

Hello I have an issue with a form that has been built by someone else on Wordpress. 

using contact form 7 plugin there's a for to fill out and it emails a PDF copy to the customer.

however on the pdf any information from dropdown selections shows "Array" instead of what was selected, everything looks fine to me (with my very minimal knowledge of PHP) the title & Preferred Payment Method:  doesn't show on the pdf 

here is the contact form 7 code.


 

<div class="steps">
    <div class="step gap-large step-1">
        <h2 class="step-title"><span class="gold">Step 1.</span> Calculate the value of your <span class="gold">gold</span></h2>
        [gold_calculator your-items]    
    </div>
    <div class="step gap-large step-2">
        <h2 class="step-title"><span class="gold">Step 2.</span> Submit your details</h2>
        <div class="row">
            <div class="column col-xs-12 col-sm-2 col-lg-4">
                <label class="required" for="sell-title">Title</label>
                [select* your-title id:sell-title class:form-control "Mr" "Mrs" "Miss" "Ms"]
            </div>
            <div class="column col-first-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-first-name">First Name</label>
                [text* your-first-name id:sell-first-name class:form-control placeholder "Enter your first name"]
            </div>
            <div class="column col-last-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-last-name">Last Name</label>
                [text* your-last-name id:sell-last-name class:form-control placeholder "Enter your last name"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-email">Email Address</label>
                [email* your-email id:sell-email class:form-control placeholder "Enter your email address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-daytime-phone">Daytime Telephone</label>
                [tel* your-daytime-phone id:sell-daytime-phone class:form-control placeholder "Enter your telephone number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="" for="sell-mobile-phone">Mobile Telephone</label>
                [tel your-mobile-phone id:sell-mobile-phone class:form-control placeholder "Enter your mobile number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="required" for="sell-address-1">Address Line 1</label>
                [text* your-address-1 id:sell-address-1 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="" for="sell-address-2">Address Line 2</label>
                [text your-address-2 id:sell-address-2 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-city">Town/City</label>
                [text* your-city id:sell-city class:form-control placeholder "Enter your town/city"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-county">County</label>
                [text* your-county id:sell-county class:form-control placeholder "Enter your county"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-postcode">Postcode</label>
                [text* your-postcode id:sell-postcode class:form-control placeholder "Enter your postcode"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-6">
                <label class="required" for="sell-method">Choose your method of payment</label>
                [select* your-method id:sell-method class:form-control "Instant Bank Transfer" "Cash" "Cheque"]
            </div>
            <div class="column col-xs-12 ccol-sm-12 col-lg-6">
                <div class="input-label required">Terms &amp; Conditions</div>
                [acceptance your-price-acceptance id:sell-price-acceptance]I accept the price offered above for my gold.[/acceptance]
                [acceptance your-terms-acceptance id:sell-terms-acceptance]I accept the <a href="/terms-conditions/" target="_blank">terms &amp; conditions</a>.[/acceptance]
                [acceptance your-acknowledgement id:sell-acknowledgement]I declare and acknowledge that: 1. I confirm the property enclosed is mine to sell, 2. I believe the items(s) to be genuine gold or platinum 3. You will contact me if the value calculated upon receipt differs in weight or carat 4. I accept payment will only be made to the person named on the submission form.[/acceptance]
            </div>
            <div class="column col-submit col-xs-12 col-sm-12">
                <div class="alert alert-info">After clicking the ‘Submit’ button below, we'll email you a form to print off and include with the package you send to us. If you wish to be paid by bank transfer, please write your bank details on the form once printed.</div>
                <div class="submit">[submit class:btn class:btn-gold "Submit"]</div>
            </div>
        </div>
    </div>
</div>

here is the pdf php form code. 

 

<?php /** @var \Strive\Sections\Pdf_Form $this */ ?>
<head>
    <style>
        h1, h2 {
            margin-top: 0;
        }

        th, td {
            text-align: left;
            vertical-align: top;
        }

        .section {
            padding: 20px 0;
        }

        .border-top {
            border-top: solid 1px #E7E7E7;
        }

        .cut-top {
            border-top: dashed 1px #E7E7E7;
        }

        .text-placeholder {
            background-color: #F7F7F7;
        }

        .cut-note {
            text-align: center;
            font-size: 80%;
            margin-bottom: 5px;
        }
    </style>
</head>
<body>
<h1>Step 3. Print &amp; post this form with your gold</h1>
<div class="section quote border-top">
    <h2 class="section-title">Customer Quote:</h2>
    <div>
        <?php if ( $this->calculator['empty'] 😞 ?>
            <p>You didn't weigh your gold - don't worry, we'll do it for you and call you with an offer. </p>
        <?php else: ?>
            <ol>
                <?php foreach ( $this->calculator['items'] as $item 😞 ?>
                    <li><?php echo $item['weight']; ?>g of <?php echo $item['name']; ?> -
                        &pound;<?php echo $item['price']; ?></li>
                <?php endforeach; ?>
            </ol>
            <p>Total: &pound;<?php echo $this->calculator['total']; ?></p>
        <?php endif; ?>
    </div>
</div>
<div class="section details border-top">
    <h2 class="section-title">Customer Details:</h2>
    <table width="100%">
        <tr>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Reference:</th>
                        <td><?php echo $this->reference; ?></td>
                    </tr>
                    <tr>
                        <th>Name:</th>
                        <td></td><?php echo empty( $this->title ) ? '' : $this->title; ?>
                            <?php echo empty( $this->first_name ) ? '' : $this->first_name; ?>
                            <?php echo empty( $this->last_name ) ? '' : $this->last_name; ?></td>
                    </tr>
                    <tr>
                        <th>Email:</th>
                        <td><?php echo empty( $this->email ) ? '-' : $this->email; ?></td>
                    </tr>
                    <tr>
                        <th>Telephone:</th>
                        <td><?php echo empty( $this->daytime_phone ) ? '-' : $this->daytime_phone; ?></td>
                    </tr>
                    <tr>
                        <th>Mobile:</th>
                        <td><?php echo empty( $this->mobile_phone ) ? '-' : $this->mobile_phone; ?></td>
                    </tr>
                </table>
            </td>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Address 1:</th>
                        <td><?php echo empty( $this->address_1 ) ? '' : $this->address_1; ?></td>
                    </tr>
                    <tr>
                        <th>Address 2:</th>
                        <td><?php echo empty( $this->address_2 ) ? '' : $this->address_2; ?></td>
                    </tr>
                    <tr>
                        <th>Town/City:</th>
                        <td><?php echo empty( $this->city ) ? '' : $this->city; ?></td>
                    </tr>
                    <tr>
                        <th>County:</th>
                        <td><?php echo empty( $this->county ) ? '' : $this->county; ?></td>
                    </tr>
                    <tr>
                        <th>Postcode:</th>
                        <td><?php echo empty( $this->postcode ) ? '' : $this->postcode; ?></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
<div class="section payment border-top">
    <p>Preferred Payment Method: <?php echo empty( $this->method ) ? '' : $this->method; ?></p>
    <?php if ( $this->method === 'Instant Bank Transfer' 😞 ?>
        <p>Write down your bank details below for the account in which you wish funds to be deposited.</p>
        <table width="100%">
            <tr>
                <th width="25%">Bank:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Name on Account:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Sort Code:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Account No:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
        </table>
    <?php endif; ?>
</div>
<div class="cut-note">Print this form, include the above part in your package and post to the address below.</div>
<div class="section address cut-top">
    <p>
        SMG<br><br>
        <?php echo empty( $this->send_address ) ? '' : $this->send_address ?>
    </p>
</div>
</body>

any help would be appreciated.