i am trying to use one text box input to get from the user one value eachtime they press submit ,and insert them in my wordpress database to their respective rows . the columns ill be inserting values in are (q1,q2,q3...q50)
<?php
$i = '1';
$quest = str_replace("1",$i,'q1');
$current_user_id = get_current_user_id();
$answer = $_GET['answer'];
$address = get_user_meta($quest, $current_user_id );
if (!empty($address)) {$rows = $wpdb->update(
'wp_database_users',
array(
$quest => $answer),
array( 'ID' => $current_user_id ),
array(
'%s', // value1
'%d' // value2
),
array( '%d' )
);
} else {
$i = $i+1 ;
$quest = str_replace("1",$i,'q1');
$current_user_id = get_current_user_id();
$answer = $_GET['answer'];
$address = get_user_meta($quest, $current_user_id );
$rows = $wpdb->update(
'wp_1m4ya4r4gg_users',
array(
$quest => $answer),
array( 'ID' => $current_user_id ),
array(
'%s', // value1
'%d' // value2
),
array( '%d' )
);
}
?>
<center>
<iframe name="votar" style="display:none;"></iframe>
<form method="GET" action="" target="votar">
<input type="text" name="answer" type='hidden' ><br>
<input type="submit" value="Submit">
</form>
</center>