darbok

Members
  • Content count

    26
  • Joined

  • Last visited

Community Reputation

1 Neutral

About darbok

  • Rank
    Newbie
  • Birthday 02/10/1975

Profile Information

  • Gender
  • Location
    Auburn NY

Contact Methods

  • Skype
    ensign75
  1. I feel stupid, I can't figure out why i kept getting the error message "is currently unable to handle this request."
  2. <?php $con = mysqli_connect("localhost","mark","library","markdb"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "INSERT INTO UserNames (FirstName, LastName) VALUES ('John', 'Doe')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); ?> i have my table set to varchar (16)
  3. is there a way to make a singular login for a wordpress website that also logs a person into the forums and the wiki at the same time?
  4. Looking at how form items are put into a mysql table, the part that seems daunting is if ones form has like 50 items... having to list all those IDs with their variables makes me wonder if there is a better way or if its just " it up buttercup.".
  5. I ment linebreak not pagebreak.
  6. how can i put a pagebreak between these? echo $phone = 3152245368; echo $phone = 3156045555;
  7. Thank you!
  8. what is the best method for getting data from a form to a mysql DB? Post? get? request? thanks
  9. I'm getting a resource #4 error, not sure how to fix it, but i bet its an easy fix that i'm not seeing. <?php $result=mysql_query("SELECT * FROM topdata a, venuetop b, stats c, mid_data d, influence e, botdata f, accounts g WHERE (a.char_name=b.char_name) AND (b.char_name=c.char_name) AND (c.char_name=d.char_name) AND (d.char_name=e.char_name) AND (e.char_name=f.char_name) AND (f.char_name=g.log_name) AND (a.char_name="$_POST[char_name]")") or die ("Couldn't get character data.<br>".mysql_error()."<br>Please contact Savvannis with your login name, character name, the above error and the page address above."); $row=mysql_fetch_array($result); echo $result; ?>
  10. thanks for the help, much appreciated, the hints and such were a good deal. To make it work I turned it into two files, one for the form and one for the php, I also changed the SQL column names to be one word all lower case instead of two words uppercase. I also took the single quote marks out of my column names.
  11. this is the error I get now. Parse error: syntax error, unexpected ';' in C:xampphtdocspracticeformspracticeforms.php on line 24 though i think it's gotten better. <!doctype html> <html> <head> <link rel="stylesheet" href="style.css"> <meta charset="utf-8"> <title> My Practice Page </title> </head> <body> <?php $first_name = $_POST["firstname"]; $last_name = $_POST["lastname"]; $city = $_POST["city"]; $db = MYSQLI_CONNECT('localhost','root','','practiceforms'); if (!$db) { die("Connection failed: " . mysqli_connect_error()); } echo 'Connected successfully'; if(isset($_POST['first_name']) && isset($_POST['last_name']) &&(isset($_POST['city'])); { $sql = "INSERT INTO users ('FIRST NAME', 'LAST NAME', 'CITY') VALUES ('$first_name','$last_name','$city')"; } mysqli_query($db, $sql); mysqli_close($db); ?> <form method="post" action=""> First Name:<br> <input type="text" name="firstname" value=""> <br> Last Name:<br> <input type="text" name="lastname" value =""><br> City:<br> <input type ="text" name="city" value=""> <br> <input type="submit" name="submit" value="submit"> </form> </body> </html>
  12. I see I think. I guess I was just trying to make a simple form to practice doing the basics of putting something into a table.
  13. yes I do. I get this error. Notice: Undefined index: first name in C:xampphtdocspracticeformspracticeforms.php on line 11Notice: Undefined index: last name in C:xampphtdocspracticeformspracticeforms.php on line 12Notice: Undefined index: city in C:xampphtdocspracticeformspracticeforms.php on line 13
  14. So, I've revised the code to this, I get no more error messages, but my input is still not going into the table. <!doctype html> <html> <head> <link rel="stylesheet" href="style.css"> <meta charset="utf-8"> <title> My Practice Page </title> </head> <body> <?php $first_name = $_POST['first name']; $last_name = $_POST['last name']; $city = $_POST['city']; $db = MYSQLI_CONNECT('localhost','root','','practiceforms'); if (!$db) { die("Connection failed: " . mysqli_connect_error()); } $sql = "INSERT INTO users (first name, last name, city) VALUES ('$first_name','$last_name','$city')"; mysqli_query($db, $sql); mysqli_close($db); ?> <form method="post" action=""> First Name:<br> <input type="text" name="First Name" value=""> <br> Last Name:<br> <input type="text" name="Last Name" value =""><br> City:<br> <input type ="text" name="city" value=""> <br> <input type="submit" name="submit" value="submit"> </body> </html>
  15. hmm, ok... so then the info that is entered into the form, how then does it get connected to the variables like $first_name, $last_name, $city ?