PHP -通过两个php文件以字符串形式发送sql命令

Question

编辑:这是一个原始代码，工作正常。很抱歉造成了这样的影响。

<?php

$target = "images/"; 
    if(!is_dir($target)) mkdir($target); $target = $target . basename( $_FILES['photo']['name']); 

$uvod = $_POST['uvod']; $text = $_POST['text']; $nadpis = $_POST['nadpis']; $datum = date("Y-m-d");

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

    $zobrazeno = 1; }  else  {

   $zobrazeno = 0; }

$fname=($_FILES['photo']['name']); $funiquename = uniqid() . $fname; $tmpName  = $_FILES['photo']['tmp_name']; $fileSize = $_FILES['photo']['size']; $fileType = $_FILES['photo']['type'];



$fp      = fopen($tmpName, 'r'); $content = fread($fp, filesize($tmpName)); $content = addslashes($content); fclose($fp);

if(!get_magic_quotes_gpc()){ $fname = addslashes($fname);}

require_once 'db_config.php'; $db_server=mysql_connect($db_hostname,$db_username,$db_password);

if(!$db_server) die("Unable to connect to MySQL" .mysql_error());

mysql_select_db($db_database,$db_server) or die("Unable to connect to database" .mysql_error()); 


$sql = "INSERT INTO `aktuality` (`nadpis`, `uvod`, `text`, `datum`, `zobrazeno`, `obr_nazev`, `obr_pripona`, `obr_velikost`, `obr_data`) VALUES ('$nadpis', '$uvod', '$text', '$datum', '$zobrazeno', '$funiquename','$fileType','$fileSize','$content')"; 
    mysql_query($sql);


 if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) { 

echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory"; 
       }    else { 

 echo "Sorry, there was a problem uploading your file."; 
    } 
     ?>

我是一个php初学者。我有一个问题，发送sql命令作为字符串通过两个php文件。

这个php文件应该调用sql.php中的函数sql_string()，但是什么也没有发生。

<?php
    ------some code here-------
    include 'sql.php';
    mysql_query(sql_string1());
    ------some code here------
 ?> 

sql.php

<?php
  function sql_string1()
  {
    $sql ="INSERT INTO `aktuality` (`nadpis`, `uvod`, `text`, `datum`, `zobrazeno`, `obr_nazev`, `obr_pripona`, `obr_velikost`, `obr_data`) VALUES ('$nadpis', '$uvod', '$text', '$datum', '$zobrazeno', '$funiquename','$fileType','$fileSize','$content')";
    return $sql;
  }
?>

谢谢你的帮忙!

Answer 1

尝试执行以下操作以使查询正常工作：

<?php
------some code here-------
include 'sql.php';
$sql = sql_string1()  ;
mysql_query($sql) or die(mysql_error());
------some code here------
?> 

如果查询失败，您还应该能够看到错误是什么。