A class written by beginners to operate MYSQL databases has many errors. Please correct or ask for similar code & lt ;? Php & nbsp; class & nbsp; TDbOpr {& nbsp; public & nbsp; var & nbsp; $ cn & nbsp; new & nbsp; mysqli (& #39; a class written by localho beginners to operate MYSQL databases, with many errors. Please correct or request similar code
Class TDbOpr
{
Public var $ cn = new mysqli ('localhost', 'root', 'sa ', 'test ');
// Connect to the database
Function Connected ()
{
Return $ cn-> mysqli_connect_errno = 0;
}
// Execute the SQL statement
Function Execute ($ S)
{
$ Cn-> query ($ S );
Return $ cn-> errno = 0;
}
// Read data
Function ReadData ($ S, & $ ResultData)
{
$ ResultData = $ cn-> query ($ S );
Return $ cn-> errno = 0;
}
// Close the connection
Function Close ()
{
$ Cn-> close ();
}
// Call an instance
Var $ db = new TDbOpr ();
If ($ db-> Connected ())
{
Echo "the database is connected successfully. ";
}
Else
{
Echo "database connection failed. ";
}
?>
------ Solution --------------------
Class TDbOpr
{
Public var $ cn = new mysqli ('localhost', 'root', 'sa ', test );
// Connect to the database
Function Connected ()
{
Return $ cn-> connect_errno <> 0;
}
// Execute the SQL statement
Function Execute ($ S)
{
$ Cn-> query ($ S );
Return $ cn-> errno <> 0;
}
// Read data
// Execute the SQL statement
Function ReadData ($ S, & $ ResultData)
{
ResultData = $ cn-> query ($ S );
Print_r ($ ResultData );
Echo'
';
Echo $ cn-> errno;
Return $ cn-> errno <> 0;
}
// Close the connection
Function Close ()
{
$ Cn-> close ();
}
}
?>
