I am trying to use this simple query on a website I am working on but it is not inserting any data into the database!
我试图在我正在处理的网站上使用这个简单的查询,但它没有将任何数据插入数据库!
<?php
// Include database configuration
include('../config.php');
// Include ezSQL core
include_once "ezSQL/ez_sql_core.php";
// Include ezSQL database mysql component
include_once "ezSQL/ez_sql_mysql.php";
// Initialise database object and establish a connection
$db = new ezSQL_mysql($db_user,$db_pass,$db_database,$db_host);
$the_file = "video.mp4";
$the_image = "image.jpg";
$the_title = "Title";
$the_description = "lokr dry ceyrc cetcn cebtyn cetbny rnyfb rybrnr rybynum nyr";
$the_anime = "Anime";
$the_genre = "Genre";
$the_slug = "anime";
$db->query("INSERT INTO video (file, image, title, description, anime, genre, slug) VALUES ($the_file, $the_image, $the_title, $the_description, $the_anime, $the_genre, $the_slug)");
$db->debug();
?>
Please help me a bit here!
请帮帮我一点!
2 个解决方案
#1
0
since the values that you want to insert are strings you should try something like this:
因为您要插入的值是字符串,您应该尝试这样的事情:
$db->query("INSERT INTO video (file, image, title, description, anime, genre, slug) VALUES ('$the_file', '$the_image', '$the_title', '$the_description', '$the_anime', '$the_genre', '$the_slug')");
$ db-> query(“INSERT INTO视频(文件,图像,标题,描述,动漫,流派,slu))VALUES('$ the_file','$ the_image','$ the_title','$ the_description','$ the_anime ','$ the_genre','$ the_slug')“);
#2
0
all non-numeric column requires quote
所有非数字列都需要引用
$db->query("INSERT INTO video (file, image, title, description, anime, genre, slug) VALUES ('$the_file', '$the_image', '$the_title', '$the_description', '$the_anime', '$the_genre', '$the_slug')");
$ db-> query(“INSERT INTO视频(文件,图像,标题,描述,动漫,流派,slu))VALUES('$ the_file','$ the_image','$ the_title','$ the_description','$ the_anime ','$ the_genre','$ the_slug')“);
#1
0
since the values that you want to insert are strings you should try something like this:
因为您要插入的值是字符串,您应该尝试这样的事情:
$db->query("INSERT INTO video (file, image, title, description, anime, genre, slug) VALUES ('$the_file', '$the_image', '$the_title', '$the_description', '$the_anime', '$the_genre', '$the_slug')");
$ db-> query(“INSERT INTO视频(文件,图像,标题,描述,动漫,流派,slu))VALUES('$ the_file','$ the_image','$ the_title','$ the_description','$ the_anime ','$ the_genre','$ the_slug')“);
#2
0
all non-numeric column requires quote
所有非数字列都需要引用
$db->query("INSERT INTO video (file, image, title, description, anime, genre, slug) VALUES ('$the_file', '$the_image', '$the_title', '$the_description', '$the_anime', '$the_genre', '$the_slug')");
$ db-> query(“INSERT INTO视频(文件,图像,标题,描述,动漫,流派,slu))VALUES('$ the_file','$ the_image','$ the_title','$ the_description','$ the_anime ','$ the_genre','$ the_slug')“);