INSERT INTO accounts geht nicht?

Kindischer Namesfaker · 5. November 2013

Hallo der gibt mir den error

es geht mit dem INsert into accounts nicht? IN die db wird nix geschrieben?

PHP

<html>
	<form action = "reg.php" method = "post">
	<p>Name <input type = "Namen" name="Name" /></p>
	<p>Passwort <input type = "Pass" name="pw" /></p>
	<p><input type = "submit" />
	<input type = "reset" /></p>
	</form>
<body>
<?php
	$con = new mysqli("localhost","****","****");
	mysqli_select_db($con,"accounts");
	if(isset($_POST["Name"]) && isset($_POST["pw"]))
	{
		$con->query("INSERT INTO accounts (Name, Passwort) VALUES (" . $con->real_escape_string($_POST["Name"]) . "," . $con->real_escape_string($_POST["pw"]) . ")");
	}
	else
	{
		echo "Alles ausfüllen!";
	}
?>
</body>
</html>

Alles anzeigen

Binär · 5. November 2013

PHP

$con->query("INSERT INTO accounts (Name, Passwort) VALUES (" . mysql_real_escape_string($_POST["Name"]) . "," . mysql_real_escape_string($_POST["pw"]) . ")");

Und bitte in Zukunft mit mysql_real_escape_string escapen.

Kindischer Namesfaker · 5. November 2013

Gelöst neuer Fehler

Es wird nix in die DB geschrieben...

PHP

<html>
    <form action = "reg.php" method = "post">
    <p>Name <input type = "Namen" name="Name" /></p>
    <p>Passwort <input type = "Pass" name="pw" /></p>
    <p><input type = "submit" />
    <input type = "reset" /></p>
    </form>
<body>
<?php
    $con = new mysqli("localhost","****","****");
    mysqli_select_db($con,"accounts");
    if(isset($_POST["Name"]) && isset($_POST["pw"]))
    {
        $con->query("INSERT INTO accounts (Name, Passwort) VALUES (" . $con->real_escape_string($_POST["Name"]) . "," . $con->real_escape_string($_POST["pw"]) . ")");
    }
    else
    {
        echo "Alles ausfüllen!";
    }
?>
</body>
</html>

Alles anzeigen

Klemmlampe · 5. November 2013

Ja.

PHP

$name = $con->escape_string($_POST["Name"]);
$password = $con->escape_string($_POST["pw"]); // Aber warum in klartext? :c
$con->query("INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('{$name}', {$password}')");

Kindischer Namesfaker · 5. November 2013

Was anderes aber @dead

Code

Parse error: syntax error, unexpected T_OBJECT_OPERATOR in /www/htdocs/w010875e/php/reg.php on line 16

Line16

PHP

con->query("INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('{$ne}', {$passwd}')");

Klemmlampe · 5. November 2013

Da fehlt ein $ vor con.

breadfish.de 12. März 2022