MySql to text with PHP

本文关键字：PHP with text to MySql | 更新日期: 2023-09-27

>我有一个问题。我用谷歌搜索了一下，但我找不到答案。所以，我有一个网站，用户可以在其中添加他们的创作。这些创作将放在 MySql 表中。现在，我想从此表中获取数据并将其发送到.txt文件，但是，我想将其保存在具有表中标题的文本文件中。我的 mysql 表有 4 列：

creations, title, user and categories.

我想将表中的每一行保存在一个单独的文本文件中，标题来自标题列。或者，当用户单击发布创建时，不将其发送到数据库，而是将其直接发送到带有他们添加的标题的文本文件。

这是后期创作.php

if ($_POST['posteaza']) {
   $con=mysqli_connect("localhost", $uname, $password,$database) or die (" nu ma pot conecta");
    mysqli_query($con,"CREATE TABLE IF NOT EXISTS postest (id int(255) NOT NULL auto_increment primary key,
    continut varchar(10000000),
    titlul varchar(200),
    categorie varchar(200),
    user varchar(30))") or die (" nu pot crea");
    $text = mysqli_real_escape_string($con,(stripslashes($_POST['continut']))); 
    $titlul = mysqli_real_escape_string($con,(stripslashes($_POST['titlul']))); 
    $categorie=mysqli_real_escape_string($con,(stripslashes($_POST['categorii'])));
    $user=$_POST['username'];
    if($text!=NULL && $titlul!=NULL)
   mysqli_query($con,"INSERT INTO postest(continut,titlul,categorie,user)  VALUES ('$text','$titlul','$categorie','$username')") or die ('Error updating database');

这就是我把所有东西都拿出来的方式：

$con=mysqli_connect("localhost",$name,$password,$database) or die("Nu se poate deschide baza de date");
$query = "SELECT * FROM postest1"; 
$result = mysqli_query($con,$query);
 while($row = mysqli_fetch_array($result)){   //Creates a loop to loop through results

 echo "<table><tr><td>" . $row['titlul'].", de ".$row['user']."</td><td></table>";  //$row['index'] the index here is a field name

你们来了

 <?php 
       //Connect to database then insert following
        $result = mysqli_query($CONN, "SELECT creations, title, user, categories FROM people WHERE id = '42'");
        if (!$result) {
                  echo 'Could not run query: ' . mysqli_error();
                  exit;
        }
        while($row=mysqli_fetch_array($result)) {
              $fp = fopen($row["title"].'.txt', 'w');
              fwrite($fp, "creation:".$row["creations"].",title:".$row["title"].",user:".$row["user"].",catagories:".$row["catagories"]);
              fclose($fp);
        }