PHP-通过两个PHP文件以字符串形式发送sql命令 - PHP - Sending sql command as a string thru two php files

PHP - Sending sql command as a string thru two php files

EDIT：这是一个原始代码，运行正常。很抱歉格式化。

<?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初学者。我在通过两个php文件将sql命令作为字符串发送时遇到了问题。

这个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;
  }
?>

谢谢你的帮助！

尝试这样做以使查询工作：

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

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