查找数据库中数据表。。。

最新推荐文章于 2022-08-24 11:59:50 发布

lvlang1993

最新推荐文章于 2022-08-24 11:59:50 发布

阅读量503

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/lvlang1993/article/details/22149771

版权

php 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

查找数据库中某数据表是否存在。。。

<!DOCTYPE html>
<html>
	<head>
		<meta http-equiv="Content-type" content="text/html; charset=utf-8">
		<title>意见与建议。。。|ComeSome社区</title>
		<style>
		
		</style>
		<script>
		
		</script>
	</head>
	<body>
		<?php
			$svr = "localhost";
			$usr = "root";
			$pwd = "";
			$con = mysql_connect("localhost","root","");//连接数据库
			$dbname = "suggest";
			$tbname = "msg";
			$create_table = "
				CREATE TABLE $tbname(
					usrname varchar(15),
					email varchar(20),
					message longtext
			)";
			
			if(mysql_select_db($dbname, $con)){//exists
//				$result = mysql_list_tables($dbname);
//				$row = mysql_fetch_row($result);
//				for()
				$result = mysql_query("show tables like 'msg'", $con);
				$row = mysql_fetch_row($result);
				if($tbname == $row[0]){
					echo $tbname." found!!!";
				}
				else{
					echo $tbname." not found!!!";
				}
			}
			else{
				echo $dbname." doesn't exist";
			}
		?>
	</body>
</html>

msg found!!!

lvlang1993

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
查找数据库中数据表。。。

查找数据库中某数据表是否存在。。。意见与建议。。。|ComeSome社区 <?php $svr = "localhost"; $usr = "root"; $pwd = ""; $con = mysql_connect("localhost","root","");//连接数据库 $dbname = "
复制链接

扫一扫