我试了几个小时...我只是无法让最后一个 Echo 显示总 ID 计数。我尝试在选择中插入条件...不。。。请帮忙...
正如我在标题中所说,我是新手。只为"好玩"而做如果你能帮助新手,我将不胜感激。
<?php
$dt = new DateTime('');
$dt->setTimeZone(new DateTimeZone('Europe/Lisbon'));
echo $dt->format('d-m-Y | G:i:s');
// START CONECTION TO BD -->
if (isset($_POST['submitted'])) {
DEFINE ('DB_USER', 'YES_I_DID_THIS');
DEFINE ('DB_PSWD', 'THIS_TOO');
DEFINE ('DB_HOST', 'YEAP..I CAN USE THE TABLE FINE.. ITS NOT CONNECTION');
DEFINE ('DB_NAME', 'MYUSER');
$dbcon = mysql_connect(DB_HOST, DB_USER, DB_PSWD, DB_NAME);
$pnome = $_POST['pnome'];
$unome = $_POST['unome'];
$contacto = $_POST['contacto'];
$morada = $_POST['morada'];
$stamp = $_POST['stamp'];
$sqlinsert = "INSERT INTO Contactos (pnome, unome, contacto, morada, stamp) VALUES ('$pnome','$unome','$contacto','$morada','DATE: Auto CURDATE($stamp)')";
if (!mysql_query($dbcon, $sqlinsert)) {
die('');
}
$newrecord = "1 Record added to the Database";
// END INSERT DATA SCRIPT -->
}
// START COUNT TOTAL TABLE ID's
// As i said i am Noob... So i repeat this because i copied it... :)
DEFINE ('DB_USER', '-----------');
DEFINE ('DB_PSWD', '-----------');
DEFINE ('DB_HOST', '---------------');
DEFINE ('DB_NAME', '-----------');
$con = mysql_connect(DB_HOST, DB_USER, DB_PSWD, DB_NAME);
if (!$con) {
die("cant connect: " . mysql_error());
}
mysql_select_db("$con");
$sql = "SELECT id FROM Contactos";
count($t);
//help here please i can't show this '$t' to show at page. Thanks
echo $t ;
?>
您没有实例化$t
变量。您需要能够获取值并使用它。如果您打开错误报告,您将看到有关此的错误:
ini_set('display_errors', 1);
error_reporting(E_ALL);
现在你的问题。您甚至没有运行查询。你需要mysql_query()
那个$sql
.我建议你实际使用sql的COUNT()
函数。
$sql = "SELECT COUNT(id) AS count FROM Contactos";
$query = mysql_query($sql);
if(!$query) {
die(mysql_error());
} else {
$count = mysql_fetch_assoc($query);
echo $count['count']; // should have your count in there.
}
您应该停止使用mysql_*
函数。该库已弃用。
我知道您刚刚开始学习PHP和所有内容,但是最好从正确的库开始,因为一旦mysql_*
库不安全,它们就会被删除。
您应该考虑使用PDO
或MySQLi
因为它们是更现代的库,虽然您可能需要克服障碍才能学习它,但在这些图书馆中胜任将为您带来美好的世界!
资源:
- PDO地址
- MySQLi