如何解决此问题不正确的整数值:''对于第1行的列'qual_deg_state_id' [英] How to fix this problem incorrect integer value: '' for column 'qual_deg_state_id' at row 1
问题描述
我有一个表格,我正在填写第10,第12,文凭,ug和pg详细信息。我正在使用dynfields array插入数据。我的问题是,如果我提供所有细节数据插入成功。但是如果我只填写单一资格,则表示
不正确的整数值:''对于第1行的'qual_deg_state_id'列
error.i尝试使用print_r funciton .it显示打印数据数据我正在传递给我们的前端剩余值显示为空,为什么会发生这种情况请提前帮助我如何解决这个问题。
什么我试过了:
这是我输入数据的代码
< pre > if($ _POST [ 'dynfields']){
foreach($ _POST ['dynfields'] as $ key => $ fieldArray){
$ boo = $ _ POST ['dynfields'];
print_r($ boo);
$ keys = array_keys($ fieldArray);
$ values = array_map(mysql_real_escape_string,$ fieldArray);
$ query = mysql_query(INSERT INTO sk_c_qualification(。implode(',',$ keys)。,qual_cand_id)VALUES('.implode('\',\''' ,$ values)。','$ cand_id'))或死(mysql_error());
}
}
//这是我的HTML代码
< pre > < div class = row >
< div class = col-md-6 >
< div class =跨度> form-group >
< label > 董事会/大学< font 颜色 = red > * < / font > < / label >
< 输入 名称 = dyn fields ['+ 1 +'] [qual_deg_university] value = <?php echo $ cand_10_uni?> class = 表格控制 < span class =code-attribute> title = 最小4,最多150个字符 type = text 占位符 = 大学/理事会 必填/ >
< / div >
< / div >
< span class =code-keyword>< div class = col-md-6 >
< div class = form-group >
< label > College < font 颜色 = red > * < / font > < / label >
< input 名称 = dynfields ['+ 1 +'] [qual_deg_college] value = <?php echo $ cand_10_uni?> class = form-control 模式 = ^ [a -zA-Z,\]] {4,150} $ title = 最小4,最多150个字符 < span class =code-attribute> type = text 占位符 = 学院 required / >
< / div >
< / div >
< / div >
< div class = row >
< div class = col-md-4 >
< div class = form-group >
< label < span class =code-keyword>> 传递年份< font < span class =code-attribute> color = red > * < / font > < / label >
< 输入 id = qual_deg_ug_yop name = dynfields ['+ 1 +'] [qual_deg_year] class = form-control >
< / div >
< / div >
< div class = col-md-4 >
< div class = form-group >
< 标签 > 状态< font color = red > * < / font > < / label >
<? php
// 包含数据库配置文件
include(' dbConfig.php');
// 获取所有国家/地区数据
$ query = $ db-> query( SELECT * FROM sk_m_states state ORDER BY州ASC);
// 计算总行数
$ rowCount = $ query-> num_rows;
?>
< 选择 class = 表格控制 名称 = dynfields ['+ 1 +'] [qual_deg_state_id] id = qual_deg_ug_state / >
< 选项 value = > 选择州< / option >
<? php
if($ rowCount> 0){
while($ row = $ query-> fetch_assoc()){
echo ' < option value ='。$ row [' state_id']。' >'。$ row [' state']。' < span class =code-string>< / option>';
}
}其他{
echo ' < option value =>状态不可用< / option>';
}
?>
< / select >
< / div >
< / div >
_POST ['dynfields']){
foreach(
_POST ['dynfields'] as
key =>
i have a form in that i am filling the details of cand 10th,12th,diploma,ug and pg details.i am inserting the data using dynfields array.my problem is if i provide all the details data inserting successfully.but if i fill only single qualification it is giving
Incorrect integer value: '' for column 'qual_deg_state_id' at row 1
error.i tried to print the data using print_r funciton .it showing data what i am passing usinf front-end remaing values are showing empty,why this is happening please help me how to fix this thanks in advance.
What I have tried:
this is my code for inserting the data
<pre> if ($_POST['dynfields']) {
foreach ( $_POST['dynfields'] as $key=>$fieldArray ) {
$boo=$_POST['dynfields'];
print_r($boo);
$keys = array_keys($fieldArray);
$values = array_map("mysql_real_escape_string",$fieldArray);
$query = mysql_query("INSERT INTO sk_c_qualification (".implode(',',$keys).",qual_cand_id) VALUES ('".implode('\',\'',$values)."','$cand_id')") or die(mysql_error());
}
}
//this is my html code
<pre> <div class="row">
<div class="col-md-6">
<div class="form-group">
<label>Board/University<font color="red">*</font></label>
<input name="dynfields['+1+'][qual_deg_university]" value="<?php echo $cand_10_uni ?>"class="form-control" title="Min 4 , Max 150 Only Characters" type="text" placeholder="University/Board" required/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label>College<font color="red">*</font></label>
<input name="dynfields['+1+'][qual_deg_college]" value="<?php echo $cand_10_uni ?>" class="form-control" pattern="^[a-zA-Z,\s]{4,150}$" title="Min 4 , Max 150 Only Characters" type="text" placeholder="College" required/>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Year of Passing<font color="red">*</font></label>
<input id="qual_deg_ug_yop" name="dynfields['+1+'][qual_deg_year]" class="form-control">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>State<font color="red">*</font></label>
<?php
//Include database configuration file
include('dbConfig.php');
//Get all country data
$query = $db->query("SELECT * FROM sk_m_states state ORDER BY state ASC");
//Count total number of rows
$rowCount = $query->num_rows;
?>
<select class="form-control" name="dynfields['+1+'][qual_deg_state_id]" id="qual_deg_ug_state"/>
<option value="">Select State</option>
<?php
if($rowCount > 0){
while($row = $query->fetch_assoc()){
echo '<option value="'.$row['state_id'].'">'.$row['state'].'</option>';
}
}else{
echo '<option value="">State not available</option>';
}
?>
</select>
</div>
</div>
_POST['dynfields']) { foreach (
_POST['dynfields'] as
key=>
这篇关于如何解决此问题不正确的整数值:''对于第1行的列'qual_deg_state_id'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!