/prog/ - Mysql help

Name: Anonymous 2012-10-03 0:23

Need help guys.
I have a form and want the form data to save to mysql data base. I looked this shit up but could never find nothing, used the tutorials but none of them worked.

Here is the form

<form method="post" action="input.php">
      <tr>
      <td>Name</td>
      <td><input type="text" name="name" size="20">
      </td>
      </tr>
      <tr>
      <td>Comment</td>
      <td><input type="text" name="comment" size="90">
      </td>
      </tr>
      <tr>
      <td></td>
      <td align="right"><input type="submit"
      name="submit" value="Sent"></td>

Could you also explain whats happening with the php code please?

Name: Anonymous 2012-10-03 0:26

Could you also explain whats happening with the php code please?
I don't see any PHP code.

Name: Anonymous 2012-10-03 0:26

use the php to save the submitted form to yoursql data base

Name: Anonymous 2012-10-03 0:29

>>3
Ya i am doing that but every php code i am using doesn't work.
Sorry I should have been more direct could you make the php code that saves it to mysql data base?

Name: Anonymous 2012-10-03 0:34

>>3
You'll find that in every PHP tutorial for beginners. Read the whole thing.

Name: Anonymous 2012-10-03 0:36

>>3
http://www.w3schools.com/php/php_mysql_insert.asp

Name: Anonymous 2012-10-03 0:42

>>5
Thats what I thought too, but they explain whats going on and everything but their examples aren't what kind of stuff i am trying to do. I have been using the w3schools tutorials on php. They have great php tutorials but is their a better site to explain php?

Name: Anonymous 2012-10-03 0:45

>>7
What about it doesn't work? You are giving no information to help here..

Name: Anonymous 2012-10-03 0:45

Maybe I just need to try more and experiment more. I know this is a simple action to carry out.....

Name: Anonymous 2012-10-03 0:48

<?php
$con = mysql_connect("notlocalhost","User","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("example_db", $con);

mysql_query("INSERT INTO Persons (name, comment)

Here is the php code i have. Of course it will give me the unexpected $end

Name: Anonymous 2012-10-03 0:50

So assuming you put a ?> at the end, why are you using "notlocalhost" as the MySQL host? Is that thing configured to allow remote queries?

Name: Anonymous 2012-10-03 0:52

>>11
No no hahah i just put that there for the viewing of the thread. I was just showing that i am not using local host.

Name: Anonymous 2012-10-03 0:54

>>6
No warning at all about SQL injection or any use of mysql_real_escape_* functins? Seriously?

Name: Anonymous 2012-10-03 0:55

>>12
So WHAT error are you getting? Seriously, give useful info or just fuck right off.

Name: Anonymous 2012-10-03 0:57

<?php

$db = new \PDO('sqlite:niggers.db');

if (array_key_exists('user', $_POST) && array_key_exists('pass', $_POST)) {

  $query = $db->prepare('INSERT INTO users (username, password) VALUES (?, ?)');

  $query->execute(array($_POST['user'], password_hash($_POST['pass']));

  // password_hash requires PHP 5.5 or a fallback implementation

  header('Location: ?page=success');

  die();

}

?>

<!DOCTYPE html>

<form method="POST" action="?">

  <input type="text" name="user">

  <input type="password" name="pass">

  <input type="submit" value="Save »">

</form>

Name: Anonymous 2012-10-03 1:00

>>14

<?php
$con = mysql_connect("mysql3.000webhost.com","a1320903_dog1","sniper123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("a1320903_dog", $con);

mysql_query("INSERT INTO Persons (name, comment)

?>
This is my input.php
Ok when i press submit It gives me the unexpected $end

Name: Anonymous 2012-10-03 1:01

>>16
Ok you're more retarded than I thought. Nice job just stopping mid-PHP there.
IHBT

Name: Anonymous 2012-10-03 1:02

>>16
Hahahahah I missed seeing the credentials for your DB user, too. Brilliant!

Name: Anonymous 2012-10-03 1:03

>>17
k just started to try to learn php......

Name: Anonymous 2012-10-03 1:04

opps
fuck

Name: Anonymous 2012-10-03 1:05

>>16
>>19
You started writing the line mysql_query("INSERT INTO Persons (name, comment) and then just stop the PHP with ?>. Why didn't you add the end of the string and the closing paren, and semicolon? And the rest of the PHP code after that...

Name: Anonymous 2012-10-03 1:06

ehh deleted it anyway lol fuck yes i am a idiot. To caught up in the moment. I deserve all negative comments.

Name: Anonymous 2012-10-03 1:08

>>22
If you wanna tinker with MySQL and PHP then set up a local Apache2 server and then you can do it all on your own comp.

If you're on Linix, you can search up any basic tut on "setting up a LAMP server".

If you're on Windows, you can look into installing EasyPHP.

Name: Anonymous 2012-10-03 1:09

>>18
You mean brillant!

[spoiler]"mysql3.000webhost.com" [10.1.1.103] is not publicly routable on the Internet.[/spoilet]

Name: Anonymous 2012-10-03 1:09

>>21
ahh ok then what would I need after the

mysql_query("INSERT INTO Persons (name, comment)

Name: Anonymous 2012-10-03 1:10

>>24
I would be willing to bet his login for 000webhost uses/used the same username and password as his MySQL user.

Name: Anonymous 2012-10-03 1:11

>>25
You need to finish writing the code. Look at the tutorial in >>6 to see what I mean about you just abruptly ending your script.

Name: Anonymous 2012-10-03 1:16

>>27
oke i will try

Name: Anonymous 2012-10-03 2:20

I don't know about your PHP, but you're missing the table tags, so the tr and td don't have any effect. If you're writing HTML, you don't need the tr or td close tags. If you're writing XHTML, make your input self-closing.

<form method="post" action="input.php">

    <table>

        <tr><td>Name<td><input type="text" name="name" size="20">

        <tr><td>Comment<td><input type="text" name="comment" size="90">

        <tr><td><td align="right"><input type="submit" name="submit" value="Sent">

    </table>

</form>

Mysql help

1 Name: Anonymous 2012-10-03 0:23

2 Name: Anonymous 2012-10-03 0:26

3 Name: Anonymous 2012-10-03 0:26

4 Name: Anonymous 2012-10-03 0:29

5 Name: Anonymous 2012-10-03 0:34

6 Name: Anonymous 2012-10-03 0:36

7 Name: Anonymous 2012-10-03 0:42

8 Name: Anonymous 2012-10-03 0:45

9 Name: Anonymous 2012-10-03 0:45

10 Name: Anonymous 2012-10-03 0:48

11 Name: Anonymous 2012-10-03 0:50

12 Name: Anonymous 2012-10-03 0:52

13 Name: Anonymous 2012-10-03 0:54

14 Name: Anonymous 2012-10-03 0:55

15 Name: Anonymous 2012-10-03 0:57

16 Name: Anonymous 2012-10-03 1:00

17 Name: Anonymous 2012-10-03 1:01

18 Name: Anonymous 2012-10-03 1:02

19 Name: Anonymous 2012-10-03 1:03

20 Name: Anonymous 2012-10-03 1:04

21 Name: Anonymous 2012-10-03 1:05

22 Name: Anonymous 2012-10-03 1:06

23 Name: Anonymous 2012-10-03 1:08

24 Name: Anonymous 2012-10-03 1:09

25 Name: Anonymous 2012-10-03 1:09

26 Name: Anonymous 2012-10-03 1:10

27 Name: Anonymous 2012-10-03 1:11

28 Name: Anonymous 2012-10-03 1:16

29 Name: Anonymous 2012-10-03 2:20

Name: Anonymous 2012-10-03 0:23

Name: Anonymous 2012-10-03 0:26

Name: Anonymous 2012-10-03 0:26

Name: Anonymous 2012-10-03 0:29

Name: Anonymous 2012-10-03 0:34

Name: Anonymous 2012-10-03 0:36

Name: Anonymous 2012-10-03 0:42

Name: Anonymous 2012-10-03 0:45

Name: Anonymous 2012-10-03 0:45

Name: Anonymous 2012-10-03 0:48

Name: Anonymous 2012-10-03 0:50

Name: Anonymous 2012-10-03 0:52

Name: Anonymous 2012-10-03 0:54

Name: Anonymous 2012-10-03 0:55

Name: Anonymous 2012-10-03 0:57

Name: Anonymous 2012-10-03 1:00

Name: Anonymous 2012-10-03 1:01

Name: Anonymous 2012-10-03 1:02

Name: Anonymous 2012-10-03 1:03

Name: Anonymous 2012-10-03 1:04

Name: Anonymous 2012-10-03 1:05

Name: Anonymous 2012-10-03 1:06

Name: Anonymous 2012-10-03 1:08

Name: Anonymous 2012-10-03 1:09

Name: Anonymous 2012-10-03 1:09

Name: Anonymous 2012-10-03 1:10

Name: Anonymous 2012-10-03 1:11

Name: Anonymous 2012-10-03 1:16

Name: Anonymous 2012-10-03 2:20