Error in PHP! Help..

[cutterpillow20]

---

Gud day! ga self study ra ko ani.. patabang tana ko dili ko kabalo magtan.aw ug error sa php beginner pa. unsa pasabot ani na error?

"<br /><b>Notice</b>: Undefined index: fname in <b>C:\xampp\htdocs\Tutorial\learning_php\learning_ php\web_forms\web_forms.php</b> on line <b>199</b><br /> " ug kani pud


"/Tutorial/learning_php/learning_php/working_with_databases/connecting_to_data.php
Intro: Let's do a little generic database work!


Warning: mysql_connect(): Access denied for user 'user1'@'localhost' (using password: YES) in C:\xampp\htdocs\Tutorial\learning_php\learning_php \working_with_databases\connecting_to_data.php on line 8
Could not connect: Access denied for user 'user1'@'localhost' (using password: YES)"

Salamat daan!
Godbless!

[chrisvil]

Your will need to define the fname,

sample.html
<form method="POST" action="sample.php">
     <label>Firstname</label>
     <input type="text" name="fname">
     <input type="submit" value="Submit">
</form>



sample.php

<?php

$fname = $_POST['fname'];

if (isset($fname))
   echo 'Firstname :' . ' ' . $fname;

?>

Kanang ikaduha nimo problema need na nimo i grant privileges ang user sa MySQL, in case you are using MyQSL,

GRANT SELECT, INSERT, DELETE ON db_name.* TO db_user@'localhost' IDENTIFIED BY 'db_passwd';

FLUSH PRIVILEGES;

or 

GRANT ALL ON *.* TO root@'localhost' IDENTIFIED BY 'db_passwd';

FLUSH PRIVILEGES;

WHERE: *.* is equal to db_name.db_table.

[cutterpillow20]

Salamat kaau boss. ugma na naku ni buhaton ka tulogon nku. ehehehe

[boang3000]

Warning: mysql_connect(): Access denied for user 'user1'@'localhost' (using password: YES) in C:\xampp\htdocs\Tutorial\learning_php\learning_php \working_with_databases\connecting_to_data.php on line 8
Could not connect: Access denied for user 'user1'@'localhost' (using password: YES)"

setup a database connection boss:
sample code ni xa sa pagconnect.

$local = "localhost";
$user = "root";
$pass = "";
$db = "your_db_name";

$link = mysql_connect('$local', '$user', '$pass'); // connect to localhost
if(!$link){
    die('CANT CONNECT TO DATABASE: '.mysql_error());
}
mysql_select_db('$db', $link); // connect to database

[ondoy]

try to check if 'user1' has access to your database ug naa cyay access rights sa schema

[thuzhar]

try to check if 'user1' has access to your database ug naa cyay access rights sa schema

yep. sakto si boss ondoy. hehe. basin wae rights si user1 sa db.

[anonymousprogrammer2012]

be sure nga ang imu ge post kay any other field at least nag describe cya nga ni exist ang name sa imu input ang $_POST['fname'] or $_GET['fname'] or any request...mysql_connect() error? check you mysql connection settings or create another account...simple..

[Rickstar13]

masabot raman ang error boss. basaha lng og tarong. or copy paste then google imo error. para makat.on ka og error tracking. kaya rana nimo boss.

[Rickstar13]

boss murag wala pa ka nakabalo sa basics in connecting to db to accessing data from database etc etc.
i suggest watch tutorial sa youtube naay nindot didto kadtong newboston php tutorial. mao to akong ga cge og tan.aw og nakat.on pd ko didto before i shift to asp.net c#

good luck.

[cutterpillow20]

Salamat sainu mga reply... wala pa jud nku na buhat na kay naguba ako PC palpak kaau.. karon pa nku na auson.. ehehe


Godbless!