Jump to content

wildbuddha

Members
  • Posts

    10
  • Joined

  • Last visited

About wildbuddha

  • Birthday 04/15/1979

Profile Information

  • Gender
    Male
  • Location
    New York, NY

wildbuddha's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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 = mysqli_query($dbc,"SELECT * FROM user WHERE name_username = '".$_POST['userName']."'") or die(); //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 (md5($_POST['passwordLogin']) != $info['password']) { die('Incorrect password, please try again.'); } else { $myFile = "test.txt"; $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $_POST['userName']."\n"; fwrite($fh, $stringData); fclose($fh); session_start(); $_SESSION['username'] = $_POST['userName']; header ("Location: profile.php"); } } } } 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.
  2. 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.
  3. You're right! "Before the If" was displayed after inserting the code you gave me. That means that's the undefined variable? Thanks btw
  4. 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.
  5. 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!
  6. 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
  7. 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!
  8. 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? localhost.sql.zip registration.php
  9. 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>"; } } }
  10. 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. module3_2.php registration.php localhost.sql.zip
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.