i'm trying enter username text field , click submit should connect me database. a) wrong code below:
<!doctype html> <html> <head> <style> .error {color: #ff0000;} </style> </head> <body> <?php // define variables , set empty values $nameerr = $emailerr = ""; if ($_server["request_method"] == "post") { if (empty($_post["login"])) { $nameerr = "login required"; } else { $login = test_input($_post["login"]); // check if login contains letters , whitespace if (!preg_match("/^[a-za-z ]*$/",$login)) { $nameerr = "only letters , white space allowed"; } } } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?> <h2>edge user login</h2> <p><span class="error">* required field.</span></p> <form method="post" action="<?php echo htmlspecialchars($_server["php_self"]);?>"> login: <input type="text" name="name"> <span class="error">* <?php echo $nameerr;?></span> <br><br> <br><br> <input type="submit" name="submit" value="submit"> </form> <?php $mysqli_connection = new mysqli('localhost', $login, 'secret', 'edgeserver'); if ($mysqli_connection->connect_error) { echo "not connected, error: " . $mysqli_connection->connect_error; } ?> b) dont want user have enter username everytime run php command. there way of using master sheet can referred to?
a.) don't want users connect mysql through server
these should login details mysql, typically create user in mysql (maybe phpmyadmin?) , fill details in here:
$mysqli_connection = new mysqli('localhost', $login, 'secret', 'edgeserver'); then select table create holds users.
b.) can store user-names in sessions, that's getting complicated, , i’d recommend working login first.
possibly this ( googled ) might you.
Comments
Post a Comment