SQL查询不更新数据库

罗伯托·罗德里格斯

我的数据库没有更新,没有显示任何错误,有人吗?我已经设置了$ id和所有变量,但是如果我在查询中做错了什么,可以吗?先感谢您

PHP代码

                <?php  

                    //get values from Database for user
                    if (isset($_GET['id']) ) { 
                        $id = (int) $_GET['id']; 
                        $result = mysql_query("SELECT * FROM Credentials, Company WHERE Credentials.ID = $id AND Company.CompanyID = $id") or trigger_error(mysql_error());
                        $row = mysql_fetch_array($result);
                    }

                    if (isset($_POST['submitted'])) { 


                        //define index for variables 
                        if(isset($_POST['email'])){
                            $email = $_POST['email'];
                        }
                        if(isset($_POST['password'])){
                            $password = $_POST['password'];
                        }
                        if(isset($_POST['permission'])){
                            $permission = $_POST['permission'];
                        }
                        if(isset($_POST['status'])){
                            $status = $_POST['status'];
                        }


                            //safe input for all fields 
                            $email = safe_input($email);
                            $password = safe_input($password); 
                            $permission = safe_input($permission);
                            $status = safe_input($status); 






                            //double checking inputs
                            foreach($_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); } 

                            //SQL queries
                            $sql = mysql_query("UPDATE Credentials SET  `Email` =  '".$email."' ,  `Password` =  '".$password."' ,  `Permission` =  '".$permission."',  `Status` =  '".$status."'  WHERE `ID` = $id ")  or die(mysql_error());

                                echo "<div id='add-success'><i class='fa fa-check'></i>&nbsp;<b>Updated Successfuly!</b></div><br/>";
                            } 

                ?>

的HTML

                <form action='edit.php?id=<?php echo safe_input($id); ?>' method='POST' id="add-merchant" enctype="multipart/form-data"> 

                    <p><br />
                    <h6>Email</h6>
                    <input type='text' name='email' value="<?php echo nl2br($row['Email']); ?>" 
                            onfocus="if (this.value==this.defaultValue) this.value = ''" 
                            onblur="if (this.value=='') this.value = this.defaultValue"/> 
                    <p><br />
                    <h6>Enter New Password</h6>
                    <input type='text' name='password' value='Password'  
                            onfocus="if (this.value==this.defaultValue) this.value = ''" 
                            onblur="if (this.value=='') this.value = this.defaultValue"/> 
                    <p><br />
                    <h6>Permission</h6>
                    <select name="permission">
                        <option value="0" selected>Unverified</option>
                        <option value="1">Verified</option>
                    </select>
                    <p><br />
                    <h6>Status</h6>
                    <select name="status">
                        <option value="1" selected>Activated</option>
                        <option value="0">Deactivated</option>
                    </select>


                    <p><input type='submit' value='Update' /><input type='hidden' value='1' name='submitted' /> 

                </form> 
Abhijeet yadav

id字段数字,如果是,则您的sql查询应该是这样的。

$sql = mysql_query("UPDATE Credentials SET  `Email` =  '".$email."',  `Password` =  '".$password."',  `Permission` =  '".$permission."', `Status` =  '".$status."'  WHERE `ID` = $id ") // id = $id without quotes because it is numeric

如果以上查询不起作用,请尝试此操作

mysql_query("UPDATE Credentials SET  `Email` =  '{$email}',  `Password` =  '{password}',  `Permission` =  '{$permission}', `Status` =  '{$status}'  WHERE `ID` = $id")

如果仍然无法将查询粘贴到phpmyadmin或您的数据库中,请尝试在线运行查询(如果可能)。还要设置error_reporting(E_ALL)以使浏览器显示错误;

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章