+ -
当前位置:首页 → 问答吧 → mysql_db_query不能成功插入记录

mysql_db_query不能成功插入记录

时间:2011-08-10

来源:互联网

遇到了一个相当无语的问题啊

我在php网站中向mysql数据库中插入数据不成功,但是同样的语句用mysql控制台插入就可以,急死我了,大家帮忙看看啊

php页面:
PHP code
<?php
set_time_limit(0);
require ("../include/config.inc.php");
function makedate() {
        // 获取当前系统时间
        $curtime = getdate();
        $curtime =$curtime['year'] . "-".$curtime['mon'] . "-".$curtime['mday'] ;

        Return $curtime;
    }
$typearray = array('image/jpeg','image/jpg','image/pjpeg','image/png','image/gif','image/x-png','image/jpeg','image/bmp');
 if(isset($_POST['submit']))
 {
        $date=makedate();
     $title=$_POST['title'];
         $des=$_POST['des'];
         $author=$_POST['author'];
    $source=$_POST['source'];
    $error = $_FILES['img']['error'];
    $name = $_FILES['img']['name'];
    $type = $_FILES['img']['type'];
    $size = $_FILES['img']['size'];
    $tmpname = $_FILES['img']['tmp_name'];
    $msg = "";
    $imgshow = "";    
    foreach($error as $key=>$err)
    {
        if($err>0)
        {
            if($err==4)
            {
                $msg = "没有选择文件";
                echo $msg;
                exit();
            }else
            {
                $msg = $name[$key]."---上传出错    ;";
                echo $msg;
                exit();
            }
        }else
        {
            if(!in_array($type[$key],$typearray))
            {
                $msg = $name[$key]."---不支持上传此类型的文件;";
                echo $msg;
                exit();
            }else if($size[0]>2097152)
            {
                $msg = $name[$key]."---文件超过2M;";
                echo $msg;
                exit();
            }else if(!is_uploaded_file($tmpname[$key]))
            {
                $msg = $name[$key]."---非法方式提交文件;";
                echo $msg;
                exit();

            }else
            {
                $ext = explode('.',$name[$key]);
                $fname = time().rand(101,999).'.'.end($ext);
                $path = "upimage/".$fname;
                $upflag = move_uploaded_file($tmpname[$key], $path);
                if(!$upflag)
                {
                    $msg = $name[$key]."---转移文件出错;";
                    echo $msg;
                exit();
                }else
                {
                    $url = "upimage/".$fname;

                    mysql_pconnect($dbhost,$dbuser,$dbpasswd);
        mysql_query("set names 'gb2312'");
                    $sql = "insert into imgs(title,laiyuan,des,date,author,url)values('$title','$source','$des','$date','$author','$url')";
                    echo $sql;    
                    try
                    {
                         if(mysql_db_query($dbname,$sql))
                           {
                              echo "aaaaaaaaaaaaaaaaaaaaaaaaaaa";
                              }    
                    }catch(Exception $e)
                    {
                        echo $e->getMessage(); 
                    }
            }
            }        
        }
    }        
 }    
?>


各位神牛帮帮忙啊

作者: jasonwanglianbin   发布时间: 2011-08-10

有错误提示么?看下是什么错误

不行的话用mysql_query()试试

作者: ohmygirl   发布时间: 2011-08-10

热门下载

更多