Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 376991" data-attributes="member: 36373">All you have to do is create a database connect and run your queries out of it.[PHP]$server = &quot;localhost&quot;;$username = &quot;username&quot;;$password = &quot;password&quot;;$connection = new mysqli($server, $username, $password);if($connection-&gt;connect_error){&nbsp; die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);}[/PHP]Then:[PHP]$query = &quot;SELECT * FROM USERS WHERE `username` = '&quot;.$_POST['username'].&quot;' AND `password` = '&quot;.MD5($_POST['password']).&quot;' LIMIT 1&quot;;$results = mysqli-&gt;query($query);if(mysqli_num_rows($results) &gt; 0){//Login$_SESSION['user'] = $_POST['username'];}[/PHP]Pretty much just going to do this.. and same with register... This was off the top of my head so <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /> Don't copy and paste cause no promises.</blockquote>

[QUOTE="JayC, post: 376991, member: 36373"] All you have to do is create a database connect and run your queries out of it. [PHP] $server = "localhost"; $username = "username"; $password = "password"; $connection = new mysqli($server, $username, $password); if($connection->connect_error){ die("Connection failed: " . $conn->connect_error); } [/PHP] Then: [PHP] $query = "SELECT * FROM USERS WHERE `username` = '".$_POST['username']."' AND `password` = '".MD5($_POST['password'])."' LIMIT 1"; $results = mysqli->query($query); if(mysqli_num_rows($results) > 0){ //Login $_SESSION['user'] = $_POST['username']; } [/PHP] Pretty much just going to do this.. and same with register... This was off the top of my head so :) Don't copy and paste cause no promises. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members