Forum: mysqli_num_rows

<?php
/* The information needed to connect to the databse */
$host = "127.0.0.1";
$user = "root";
$password = "";
$database = "test";
$cxn = mysqli_connect($host,$user,$password,$database);
 
/* Gets todays date.
Difference between upper and lowercase */
$date = date("Y-m-d");
 
/* This part gets the filename without the file extension and file extension of the file.
Lets say we have a file called abc.torrent. The code splits the name into two parts.
file_basename that is abc and
file_ext that is .torrent */
$filename = $_FILES[Path][name];
##$file_basename = substr($filename, 0, strripos($filename, '.'));##
$file_ext = substr($filename, strripos($filename, '.'));
 
/* If the filename is empty, the torrent won't be uploaded */
if($_POST[Name] == "")
{
echo "Du har glömt att ange ett namn!n";
}
/* If a file haven't been chosen, the torrent won't be uploaded */
elseif($_FILES[Path][name] == "")
{
echo "Du har glömt att lägga till en fil!n";
}
/* If not the file extension is .torrent, the torrent won't be uploaded */
elseif($file_ext != ".torrent")
{
echo "Du kan endast ladda upp torrentfiler!n";
}
/* If the filesize is bigger than 1mb, the torrent won't be uploaded */
elseif($_POST[MAX_FILE_SIZE] > 1000000)
{
echo "Filen är för stor!n";
}
/* If everything is fine, the torrent will be uploaded */
else
{
echo "<p>Torrent filen har laddats upp</p>";
 
/* The connection is established */
 
/* This checks if the torrentname allready excists */
$query = "SELECT COUNT(*) FROM test";
$result = mysqli_query($cxn,$query);
$nrows = mysqli_num_rows($result);
 
 
/* 
$query = "INSERT INTO test (torType,torName,torDate) VALUES ($_POST[Type],$_POST[Name],$date)";
mysqli_query($cxn,$query);
*/
}
?>