What's new

Help Patulong sa php codes plsss

C

choiniglory03

Honorary Poster
Established
Joined
Jun 1, 2018
Posts
157
Reaction
454
Points
203
Age
30
patulong po bakit nag error.

eto codes ko po

<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "grading_system";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
?>

Eto nmn po yung error

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\SCESGS\mysql_connection.php:6 Stack trace: #0 C:\xampp\htdocs\SCESGS\login.php(7): require_once() #1 {main} thrown in C:\xampp\htdocs\SCESGS\mysql_connection.php on line 6

:cry::cry::cry:
 
Ang error na iyong nakikita ay nagmumula sa paggamit mo ng function na mysql_connect(), na hindi na supported sa mga latest na bersyon ng PHP. Ang function na ito ay deprecated na at hindi na rekomendado gamitin. Upang maayos ang error na ito, kailangan mong gamitin ang bagong function na mysqli_connect().

Narito ang naayos na code na ginagamit ang mysqli_connect() function:

PHP: 
<?php
    $mysql_hostname = "localhost";
    $mysql_user = "root";
    $mysql_password = "";
    $mysql_database = "grading_system";
    $conn = mysqli_connect($mysql_hostname, $mysql_user, $mysql_password, $mysql_database) or die("Could not connect database");
?>

Ang mysqli_connect() function ay nagbibigay-daan sa iyo na mag-ugnay sa database gamit ang MySQLi extension, na angkop para sa mga bagong bersyon ng PHP.

Sinasadya rin ng code na ito ang paggamit ng variable na $conn upang i-store ang koneksyon sa database. Maaari mong gamitin ang variable na ito para sa mga query at iba pang database operations.

Tandaan na kailangan mong i-update ang iba pang bahagi ng iyong code na gumagamit ng mysql_ functions upang gamitin ang tamang mysqli_ functions.
 
🤖 said:
Ang error na iyong nakikita ay nagmumula sa paggamit mo ng function na mysql_connect(), na hindi na supported sa mga latest na bersyon ng PHP. Ang function na ito ay deprecated na at hindi na rekomendado gamitin. Upang maayos ang error na ito, kailangan mong gamitin ang bagong function na mysqli_connect().

Narito ang naayos na code na ginagamit ang mysqli_connect() function:

PHP: 
<?php
    $mysql_hostname = "localhost";
    $mysql_user = "root";
    $mysql_password = "";
    $mysql_database = "grading_system";
    $conn = mysqli_connect($mysql_hostname, $mysql_user, $mysql_password, $mysql_database) or die("Could not connect database");
?>

Ang mysqli_connect() function ay nagbibigay-daan sa iyo na mag-ugnay sa database gamit ang MySQLi extension, na angkop para sa mga bagong bersyon ng PHP.

Sinasadya rin ng code na ito ang paggamit ng variable na $conn upang i-store ang koneksyon sa database. Maaari mong gamitin ang variable na ito para sa mga query at iba pang database operations.

Tandaan na kailangan mong i-update ang iba pang bahagi ng iyong code na gumagamit ng mysql_ functions upang gamitin ang tamang mysqli_ functions.
Click to expand...

ito ang lumabas

Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\SCESGS\login.php:12 Stack trace: #0 {main} thrown in C:\xampp\htdocs\SCESGS\login.php on line 12
Ito codes ko
<?php
require_once('mysql_connection.php');
session_start();
$type = $_GET['usertype'];

$selectquery = "SELECT * FROM accounts where usertype = '".$type."'";
$selectresult = mysql_query($selectquery);
while ($row = mysql_fetch_array($selectresult)){
$image = $row['picture'];
}

if(isset($_POST['login'])){
$username = $_POST['username'];
$password = $_POST['password'];
$query = "SELECT * FROM accounts where username='".$username."' and password = '".$password."' and usertype = '".$type."'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if(is_array($row)) {
$_SESSION["id"] = $row['id'];
if($type == "ADMIN"){
header('location: view_accounts.php');
} elseif($type == "USER"){
header('location: view_records.php');
}
}
else
{
echo "<script>alert('Incorrect Username or Password!')</script>";
}
}
?>
 
choiniglory03 said:
ito ang lumabas

Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\SCESGS\login.php:12 Stack trace: #0 {main} thrown in C:\xampp\htdocs\SCESGS\login.php on line 12
Ito codes ko
<?php
require_once('mysql_connection.php');
session_start();
$type = $_GET['usertype'];

$selectquery = "SELECT * FROM accounts where usertype = '".$type."'";
$selectresult = mysql_query($selectquery);
while ($row = mysql_fetch_array($selectresult)){
$image = $row['picture'];
}

if(isset($_POST['login'])){
$username = $_POST['username'];
$password = $_POST['password'];
$query = "SELECT * FROM accounts where username='".$username."' and password = '".$password."' and usertype = '".$type."'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if(is_array($row)) {
$_SESSION["id"] = $row['id'];
if($type == "ADMIN"){
header('location: view_accounts.php');
} elseif($type == "USER"){
header('location: view_records.php');
}
}
else
{
echo "<script>alert('Incorrect Username or Password!')</script>";
}
}
?>
Click to expand...
Ang error na iyong nakikita ay dahil sa paggamit mo ng mga deprecated na functions tulad ng mysql_query() at mysql_fetch_array(). Upang maayos ang error na ito, kailangan mong gamitin ang bagong MySQLi extension at mga functions nito.

Narito ang naayos na code gamit ang MySQLi extension:

PHP: 
<?php
require_once('mysql_connection.php');
session_start();
$type = $_GET['usertype'];

$selectquery = "SELECT * FROM accounts where usertype = '".$type."'";
$selectresult = mysqli_query($conn, $selectquery);
while ($row = mysqli_fetch_array($selectresult)){
    $image = $row['picture'];
}

if(isset($_POST['login'])){
    $username = $_POST['username'];
    $password = $_POST['password'];
    $query = "SELECT * FROM accounts where username='".$username."' and password = '".$password."' and usertype = '".$type."'";
    $result    = mysqli_query($conn, $query);
    $row  = mysqli_fetch_array($result);
    if(is_array($row)) {
        $_SESSION["id"] = $row['id'];
        if($type == "ADMIN"){
            header('location: view_accounts.php');
        } elseif($type == "USER"){
            header('location: view_records.php');
        }
    } 
    else 
    {
        echo "<script>alert('Incorrect Username or Password!')</script>";
    }
}
?>

Sa naayos na code, ginagamit natin ang mysqli_query() function para sa pagbuo ng query at mysqli_fetch_array() function para sa pagkuha ng resulta ng query.

Tandaan na kailangan mo rin i-update ang iba pang bahagi ng iyong code na gumagamit ng deprecated na functions para gamitin ang tamang functions ng MySQLi extension.
 
🤖 said:
Ang error na iyong nakikita ay dahil sa paggamit mo ng mga deprecated na functions tulad ng mysql_query() at mysql_fetch_array(). Upang maayos ang error na ito, kailangan mong gamitin ang bagong MySQLi extension at mga functions nito.

Narito ang naayos na code gamit ang MySQLi extension:

PHP: 
<?php
require_once('mysql_connection.php');
session_start();
$type = $_GET['usertype'];

$selectquery = "SELECT * FROM accounts where usertype = '".$type."'";
$selectresult = mysqli_query($conn, $selectquery);
while ($row = mysqli_fetch_array($selectresult)){
    $image = $row['picture'];
}

if(isset($_POST['login'])){
    $username = $_POST['username'];
    $password = $_POST['password'];
    $query = "SELECT * FROM accounts where username='".$username."' and password = '".$password."' and usertype = '".$type."'";
    $result    = mysqli_query($conn, $query);
    $row  = mysqli_fetch_array($result);
    if(is_array($row)) {
        $_SESSION["id"] = $row['id'];
        if($type == "ADMIN"){
            header('location: view_accounts.php');
        } elseif($type == "USER"){
            header('location: view_records.php');
        }
    }
    else
    {
        echo "<script>alert('Incorrect Username or Password!')</script>";
    }
}
?>

Sa naayos na code, ginagamit natin ang mysqli_query() function para sa pagbuo ng query at mysqli_fetch_array() function para sa pagkuha ng resulta ng query.

Tandaan na kailangan mo rin i-update ang iba pang bahagi ng iyong code na gumagamit ng deprecated na functions para gamitin ang tamang functions ng MySQLi extension.
Click to expand...

eto na nmn error parin

Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\SCESGS\admin_header.php:20 Stack trace: #0 C:\xampp\htdocs\SCESGS\view_accounts.php(18): include() #1 {main} thrown in C:\xampp\htdocs\SCESGS\admin_header.php on line 20
ito po codes
<?php
$id = $_SESSION['id'];
$selectquery = "SELECT * FROM accounts where id = '".$id."'";
$selectresult = mysql_query($selectquery);
while ($row = mysql_fetch_array($selectresult)){
$picture = $row['picture'];
$lastname = $row['lastname'];
$firstname = $row['firstname'];
}
?>
 
choiniglory03 said:
eto na nmn error parin

Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\SCESGS\admin_header.php:20 Stack trace: #0 C:\xampp\htdocs\SCESGS\view_accounts.php(18): include() #1 {main} thrown in C:\xampp\htdocs\SCESGS\admin_header.php on line 20
ito po codes
<?php
$id = $_SESSION['id'];
$selectquery = "SELECT * FROM accounts where id = '".$id."'";
$selectresult = mysql_query($selectquery);
while ($row = mysql_fetch_array($selectresult)){
$picture = $row['picture'];
$lastname = $row['lastname'];
$firstname = $row['firstname'];
}
?>
Click to expand...
Ang error na iyong nakikita ay dahil hindi mo pa rin ginamit ang tamang function para sa pagkuha ng resulta ng query. Sa halip na gamitin ang mysql_query() at mysql_fetch_array(), kailangan mong gamitin ang mysqli_query() at mysqli_fetch_array().

Narito ang naayos na code gamit ang tamang functions ng MySQLi extension:

PHP: 
<?php
require_once('mysql_connection.php');
session_start();
$type = $_GET['usertype'];

$selectquery = "SELECT * FROM accounts where usertype = '".$type."'";
$selectresult = mysqli_query($conn, $selectquery);
while ($row = mysqli_fetch_array($selectresult)){
    $image = $row['picture'];
}

if(isset($_POST['login'])){
    $username = $_POST['username'];
    $password = $_POST['password'];
    $query = "SELECT * FROM accounts where username='".$username."' and password = '".$password."' and usertype = '".$type."'";
    $result    = mysqli_query($conn, $query);
    $row  = mysqli_fetch_array($result);
    if(is_array($row)) {
        $_SESSION["id"] = $row['id'];
        if($type == "ADMIN"){
            header('location: view_accounts.php');
        } elseif($type == "USER"){
            header('location: view_records.php');
        }
    }
    else
    {
        echo "<script>alert('Incorrect Username or Password!')</script>";
    }
}
?>

Tandaan na kailangan mong i-update ang iba pang bahagi ng iyong code na gumagamit ng deprecated na functions tulad ng mysql_query() at mysql_fetch_array() para gamitin ang tamang functions ng MySQLi extension.
 
🤖 said:
Ang error na iyong nakikita ay dahil hindi mo pa rin ginamit ang tamang function para sa pagkuha ng resulta ng query. Sa halip na gamitin ang mysql_query() at mysql_fetch_array(), kailangan mong gamitin ang mysqli_query() at mysqli_fetch_array().

Narito ang naayos na code gamit ang tamang functions ng MySQLi extension:

PHP: 
<?php
require_once('mysql_connection.php');
session_start();
$type = $_GET['usertype'];

$selectquery = "SELECT * FROM accounts where usertype = '".$type."'";
$selectresult = mysqli_query($conn, $selectquery);
while ($row = mysqli_fetch_array($selectresult)){
    $image = $row['picture'];
}

if(isset($_POST['login'])){
    $username = $_POST['username'];
    $password = $_POST['password'];
    $query = "SELECT * FROM accounts where username='".$username."' and password = '".$password."' and usertype = '".$type."'";
    $result    = mysqli_query($conn, $query);
    $row  = mysqli_fetch_array($result);
    if(is_array($row)) {
        $_SESSION["id"] = $row['id'];
        if($type == "ADMIN"){
            header('location: view_accounts.php');
        } elseif($type == "USER"){
            header('location: view_records.php');
        }
    }
    else
    {
        echo "<script>alert('Incorrect Username or Password!')</script>";
    }
}
?>

Tandaan na kailangan mong i-update ang iba pang bahagi ng iyong code na gumagamit ng deprecated na functions tulad ng mysql_query() at mysql_fetch_array() para gamitin ang tamang functions ng MySQLi extension.
Click to expand...

Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\SCESGS\admin_header.php:20 Stack trace: #0 C:\xampp\htdocs\SCESGS\view_accounts.php(18): include() #1 {main} thrown in C:\xampp\htdocs\SCESGS\admin_header.php on line 20

..

ito codes ko
..


<?php
$id = $_SESSION['id'];
$selectquery = "SELECT * FROM accounts where id = '".$id."'";
$selectresult = mysql_query($selectquery);
while ($row = mysql_fetch_array($selectresult)){
$picture = $row['picture'];
$lastname = $row['lastname'];
$firstname = $row['firstname'];
}
?>
 
choiniglory03 said:
Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\SCESGS\admin_header.php:20 Stack trace: #0 C:\xampp\htdocs\SCESGS\view_accounts.php(18): include() #1 {main} thrown in C:\xampp\htdocs\SCESGS\admin_header.php on line 20

..

ito codes ko
..


<?php
$id = $_SESSION['id'];
$selectquery = "SELECT * FROM accounts where id = '".$id."'";
$selectresult = mysql_query($selectquery);
while ($row = mysql_fetch_array($selectresult)){
$picture = $row['picture'];
$lastname = $row['lastname'];
$firstname = $row['firstname'];
}
?>
Click to expand...
Ang error na iyong nakikita ay dahil hindi mo pa rin ginamit ang tamang function para sa pagkuha ng resulta ng query. Sa halip na gamitin ang mysql_query() at mysql_fetch_array(), kailangan mong gamitin ang mysqli_query() at mysqli_fetch_array().

Narito ang naayos na code gamit ang tamang functions ng MySQLi extension:

PHP: 
<?php
require_once('mysql_connection.php');
session_start();
$id = $_SESSION['id'];
$selectquery = "SELECT * FROM accounts where id = '".$id."'";
$selectresult = mysqli_query($conn, $selectquery);
while ($row = mysqli_fetch_array($selectresult)){
    $picture = $row['picture'];
    $lastname = $row['lastname'];
    $firstname = $row['firstname'];
}
?>

Tandaan na kailangan mong i-update ang iba pang bahagi ng iyong code na gumagamit ng deprecated na functions tulad ng mysql_query() at mysql_fetch_array() para gamitin ang tamang functions ng MySQL
 
🤖 said:
Ang error na iyong nakikita ay dahil hindi mo pa rin ginamit ang tamang function para sa pagkuha ng resulta ng query. Sa halip na gamitin ang mysql_query() at mysql_fetch_array(), kailangan mong gamitin ang mysqli_query() at mysqli_fetch_array().

Narito ang naayos na code gamit ang tamang functions ng MySQLi extension:

PHP: 
<?php
require_once('mysql_connection.php');
session_start();
$id = $_SESSION['id'];
$selectquery = "SELECT * FROM accounts where id = '".$id."'";
$selectresult = mysqli_query($conn, $selectquery);
while ($row = mysqli_fetch_array($selectresult)){
    $picture = $row['picture'];
    $lastname = $row['lastname'];
    $firstname = $row['firstname'];
}
?>

Tandaan na kailangan mong i-update ang iba pang bahagi ng iyong code na gumagamit ng deprecated na functions tulad ng mysql_query() at mysql_fetch_array() para gamitin ang tamang functions ng MySQL
Click to expand...


if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg") {
echo "<script>alert('PNG, JPG, and JPEG are allowed!')</script>";
} else {
$image= addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name= addslashes($_FILES['image']['name']);
move_uploaded_file($_FILES["image"]["tmp_name"], $dir . $_FILES["image"]["name"]);
$query = "INSERT INTO accounts(id,firstname,lastname,username,password,picture,usertype) VALUES (null,'".$firstname."','".$lastname."','".$username."','".$password."','".$picture."','".$usertype."')";
mysql_query($query);
echo "<script>alert('Data Successfully Saved!')</script>";
echo '<script>windows: location="view_accounts.php"</script>';

}
 
🤖 said:
Sorry I couldn't contact the ChatGPT think tank :(
Click to expand...

Fatal error: Uncaught ArgumentCountError: mysqli_query() expects at least 2 arguments, 1 given in C:\xampp\htdocs\SCESGS\create_account.php:39 Stack trace: #0 C:\xampp\htdocs\SCESGS\create_account.php(39): mysqli_query('INSERT INTO acc...') #1 {main} thrown in C:\xampp\htdocs\SCESGS\create_account.php on line 39
code
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg") {
echo "<script>alert('PNG, JPG, and JPEG are allowed!')</script>";
} else {
$image= addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name= addslashes($_FILES['image']['name']);
move_uploaded_file($_FILES["image"]["tmp_name"], $dir . $_FILES["image"]["name"]);
$query = "INSERT INTO accounts(id,firstname,lastname,username,password,picture,usertype) VALUES (null,'".$firstname."','".$lastname."','".$username."','".$password."','".$picture."','".$usertype."')";
mysql_query($query);
echo "<script>alert('Data Successfully Saved!')</script>";
echo '<script>windows: location="view_accounts.php"</script>';

}
 
Try this one


<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "grading_system";

$bd = mysqli_connect($mysql_hostname, $mysql_user, $mysql_password, $mysql_database);

if (!$bd) {
die("Connection failed: " . mysqli_connect_error
());
}
?>
 

Similar threads

Popular Tags

android api app arduino bot c c++ capstone capstone project code coding coding and programming css database developer development help how how to html in java javascript language laravel mag mysql need patulong php program programmer programming programming language project python question react script sql system thesis tutorial udemy vb.net visual basic web web development website with

About this Thread

  • 12
    Replies
  • 337
    Views
  • 5
    Participants
Last reply from:
Well1AmNichtDiePerson

New Topics

Popular On This Forum

Online statistics

Members online
1,052
Guests online
5,141
Total visitors
6,193
Back
Top