Hello friends;
Firstly; connect to our database with the following code :
<?php
$db_host = "localhost";
$db_name = "my_database_name";
$db_username = "my_database_username";
$db_password = "my_database_username_password";
$connect = new PDO("mysql:host=$db_host;dbname=$db_name", $db_username, $db_password);
$connect->exec("SET NAMES 'utf8'; SET CHARSET 'utf8'");
?>
$db_host = "localhost";
$db_name = "my_database_name";
$db_username = "my_database_username";
$db_password = "my_database_username_password";
$connect = new PDO("mysql:host=$db_host;dbname=$db_name", $db_username, $db_password);
$connect->exec("SET NAMES 'utf8'; SET CHARSET 'utf8'");
?>
Now let's find the number of records.
<?php
echo $connect->query("Select Count(*) From my_table")->fetchColumn();
?>
echo $connect->query("Select Count(*) From my_table")->fetchColumn();
?>
Its very simple. I want to know the number of records my table, name is my_table.
I hope it has been useful.
İlk Yorumu Sen Yap