-
Posts
10 -
Joined
-
Last visited
Posts posted by wildbuddha
-
-
Not quite sure what I'm doing wrong:
function getName() { $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $username = $_POST['userName']; $id=$_POST['id']; $sql="SELECT name_first, name_last FROM user WHERE name_username='$username' AND id='$id'"; /*$query=mysqli_query($dbc,$sql) or die('no query');*/ $result = $dbc->query($sql); while($row = $result->fetch_array() or die('names are not working')){ echo $row['name_first']; echo " "; echo $row['name_last']; } }
I'm getting the die error "names are not working." Thanks, in advance for any help.
-
You're right! "Before the If" was displayed after inserting the code you gave me. That means that's the undefined variable? Thanks btw
-
Hi everyone. Thanks, in advance, for any and all help! I'm sure there's something simple I'm missing as I'm very new to PHP.
function uploadAttachment() { if(isset($_POST['submitAttachment'])) { if ($File) { copy ($File, "$File_name"); $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $username = $_POST['userName']; $id=$_POST['id']; $sql="UPDATE user SET avatarURL='$File_name' WHERE name_username='$username' AND id='$id'"; $query=mysqli_query($dbc,$sql) or die(); $sql2="SELECT * FROM user WHERE name_username='$username' AND id='$id'"; $query2=mysqli_query($dbc,$sql2) or die(); if($query) { echo "You uploaded the following photo:"; echo "<img src=\""; echo $File_name; echo "\" width=\"400px\">"; unlink ($File); } else { echo "You did not upload a file."; } } } }
The above code is giving me an error:
"Notice: Undefined variable: File in /Users/justinalba/Sites/php-class/module3/functions.php on line 257"
How come the variable can be found on line 255 but not 257? Do I need to declare $File as something?
Thanks.
-
When I add the database to the mysqli_query:
$query = mysqli_query($dbc,"SELECT * FROM users WHERE name_username = '".$_POST['userName']."'") or die('error');
it works!!! Thank you so much!
-
That mostly solved the problem, but I'm still getting an error...
function login() { $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); if (isset($_POST['submitLogin'])) { // if form has been submitted // makes sure they filled it in if(!$_POST['userName'] | !$_POST['passwordLogin']) { die('You did not fill in a required field.'); } $query = mysql_query("SELECT * FROM users WHERE name_username = '".$_POST['userName']."'") or die('error'); // //Gives error if user dosen't exist $check = mysqli_num_rows($query); if ($check == 0) { die('That user does not exist in our database. <a href=registration.php>Click Here to Register</a>'); } while($info = mysqli_fetch_array( $query )) { $_POST['passwordLogin'] = stripslashes($_POST['passwordLogin']); $info['password'] = stripslashes($info['password']); //gives error if the password is wrong if ($_POST['passwordLogin'] != $info['password']) { die('Incorrect password, please try again.'); } else { header('profile.php'); } } } }
This line:
$query = mysql_query("SELECT * FROM users WHERE name_username = '".$_POST['userName']."'") or die('error'); //
gives the die error.
This line:
$query = mysqli_query("SELECT * FROM users WHERE name_username = '".$_POST['userName']."'") or die('error');
Gives the die error and this error:
Warning: mysqli_query() expects at least 2 parameters, 1 given in /Users/****/Sites/php-class/module3/functions.php on line 110 -
by using a global right? I've looked all over, but when I put "global $dbc" with the code nested in top Dreamweaver tells me the line with "global" is an error. Thank you btw, I'm about to put your suggestion action. I really appreciate your swift reply!
-
Hi everyone! Thanks, in advance, for any and all help. It's greatly appreciated.
So I created this function:
function login() { $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); if (isset($_POST['submitLogin'])) { // if form has been submitted // makes sure they filled it in if(!$_POST['userName'] | !$_POST['passwordLogin']) { die('You did not fill in a required field.'); } $query = mysql_query("SELECT * FROM users WHERE name_username = '".$_POST['userName']."'")or die(mysql_error()); //Gives error if user dosen't exist $check = mysql_num_rows($query); if ($check == 0) { die('That user does not exist in our database. <a href=add.php>Click Here to Register</a>'); } while($info = mysql_fetch_array( $query )) { $_POST['passwordLogin'] = stripslashes($_POST['passwordLogin']); $info['password'] = stripslashes($info['password']); //gives error if the password is wrong if ($_POST['passwordLogin'] != $info['password']) { die('Incorrect password, please try again.'); } else { echo "you are logged in"; } } } }
I get an error that there is "No database selected." However the rest of my functions:
function checkUserName(){ if(isset($_POST['userNameAvailabilityCheck'])) { $username = $_POST['username']; $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $query = "SELECT name_username FROM user WHERE name_username = '$username' ORDER by ID DESC"; $result = mysqli_query($dbc, $query); $row = mysqli_fetch_row($result); $usernameExisting = $row[0]; if($usernameExisting == $username) // if the result matches the first MySql row result, error { echo 'Username already exists.'; } elseif (strlen($username) < 6 || strlen($username) > 15) // checks length of username { echo "Username must be 6 to 15 characters"; } elseif (preg_match("/^[a-zA-Z1-9]+$/", $username)) //checks for illegal characters, succcess! { echo 'Username is available.'; } else //if there are illegal characters { echo 'Use alphanumeric characters only.'; } } } function register(){ if(isset($_POST['submitRegistration'])) $username=$_POST['username']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $password=$_POST['password2']; { if($_POST['username']=="") { echo "Please type username"; } elseif (!preg_match("/^[a-zA-Z1-9]+$/", $username)) //checks for illegal characters, succcess! { echo 'Use alphanumeric characters only.'; } elseif (strlen($username) < 6 || strlen($username) > 15) // checks length of username { echo "Username must be 6 to 15 characters"; } elseif($_POST['password1']==""|$_POST['password2']=="") { echo "Please type password"; } elseif($_POST['password1']!=$_POST['password2']) { echo "Uh-oh. Your passwords don't match."; } else { $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $username=$_POST['username']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $password=$_POST['password2']; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $sql = "INSERT INTO user (id, name_first, name_last, name_username, password) VALUES ('', '$firstName', '$lastName', '$username', '$password')"; mysqli_query ($dbc, $sql) or die("Problem executing query"); echo "Rows inserted: ", mysqli_affected_rows($dbc), "<br><br>"; $rowcount = 0; $q = mysqli_query($dbc, "select * from user"); while ($dbc = mysqli_fetch_row($q)) { $rowcount++; for ($k=0; $k<count($dbc); $k++){ echo " $dbc[$k] "; } echo "<br>"; } echo "<p> A total of $rowcount rows<br>"; } } }
Seem to work without a hitch...any suggestions on what the problem with the database is in that particular function when it works through all the others? My guess is that I'm not passing $dbc through any of the sql statements. What do you think?
-
Hi, thanks so much for the reply! Correct me if I'm wrong, and I probably am, but aren't the variables you speak of for the database and not the values of the form? I actually was able to solve the problem by moving:
$db_hostname = "localhost";
$db_username = "root";
$db_password = "";
$db_name = "justinalba_module3_db";inside the "else" statement that contains the MySql. Regardless, I would never have tried that if you didn't respond So thank you.
function register(){ if(isset($_POST['submitRegistration'])) $username=$_POST['username']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $password=$_POST['password2']; { if($_POST['username']=="") { echo "Please type username"; } elseif (!preg_match("/^[a-zA-Z1-9]+$/", $username)) //checks for illegal characters, succcess! { echo 'Use alphanumeric characters only.'; } elseif (strlen($username) < 6 || strlen($username) > 15) // checks length of username { echo "Username must be 6 to 15 characters"; } elseif($_POST['password1']==""|$_POST['password2']=="") { echo "Please type password"; } elseif($_POST['password1']!=$_POST['password2']) { echo "Uh-oh. Your passwords don't match."; } else { $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; $username=$_POST['username']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $password=$_POST['password2']; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $sql = "INSERT INTO user (id, name_first, name_last, name_username, password) VALUES ('', '$firstName', '$lastName', '$username', '$password')"; mysqli_query ($dbc, $sql) or die("Problem executing query"); echo "Rows inserted: ", mysqli_affected_rows($dbc), "<br><br>"; $rowcount = 0; $q = mysqli_query($dbc, "select * from user"); while ($dbc = mysqli_fetch_row($q)) { $rowcount++; for ($k=0; $k<count($dbc); $k++){ echo " $dbc[$k] "; } echo "<br>"; } echo "<p> A total of $rowcount rows<br>"; } } }
-
Hello all. This is my first post in a php forum. Thanks, in advance, for any help. This code:
<?php // database table 'users' is setup with the following fields: // first_name, last_name, user_name, password $db_hostname = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "justinalba_module3_db"; //connection to the database $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $sql = "INSERT INTO user (name_first, name_last, name_username, password) VALUES ('Sam', 'Row', 'samrow', 'pw123')"; mysqli_query ($dbc, $sql) or die("Problem executing query"); echo "Rows inserted: ", mysqli_affected_rows($dbc), "<br><br>"; $rowcount = 0; $q = mysqli_query($dbc, "select * from user"); while ($dbc = mysqli_fetch_row($q)) { $rowcount++; for ($k=0; $k<count($dbc); $k++){ echo " $dbc[$k] "; } echo "<br>"; } echo "<p> A total of $rowcount rows<br>"; ?>
works perfectly...then I add it to a function:
function register(){ if(isset($_POST['submitRegistration'])) $username=$_POST['username']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $password=$_POST['password2']; { if($_POST['username']=="") { echo "Please type username"; } elseif (!preg_match("/^[a-zA-Z1-9]+$/", $username)) //checks for illegal characters, succcess! { echo 'Use alphanumeric characters only.'; } elseif (strlen($username) < 6 || strlen($username) > 15) // checks length of username { echo "Username must be 6 to 15 characters"; } elseif($_POST['password1']==""|$_POST['password2']=="") { echo "Please type password"; } elseif($_POST['password1']!=$_POST['password2']) { echo "Uh-oh. Your passwords don't match."; } else { $username=$_POST['username']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $password=$_POST['password2']; $dbc = @mysqli_connect($db_hostname, $db_username, $db_password, $db_name) or die("Unable to connect to MySQL"); $sql = "INSERT INTO user (id, name_first, name_last, name_username, password) VALUES ('', '$firstName', '$lastName', '$username', '$password')"; mysqli_query ($dbc, $sql) or die("Problem executing query"); echo "Rows inserted: ", mysqli_affected_rows($dbc), "<br><br>"; $rowcount = 0; $q = mysqli_query($dbc, "select * from user"); while ($dbc = mysqli_fetch_row($q)) { $rowcount++; for ($k=0; $k<count($dbc); $k++){ echo " $dbc[$k] "; } echo "<br>"; } echo "<p> A total of $rowcount rows<br>"; } } }
and I get the "die("Unable to connect to MySQL")" error.
Any thoughts? I know I restated several variables inside the whatif statement. I was just trying to see what the problem was.
Thanks,
JA.
Login not Appending to TXT file
in PHP Coding Help
Posted
I'm having a problem with the above code where the file writing isn't writing to the file at all. Any suggestions? Thanks, in advance, for any help.