Reply to thread

Message

<blockquote data-quote="NSA" data-source="post: 201761" data-attributes="member: 10034">Hello,&nbsp;For some reason when I post the username data to PHP, it stores it in the database as 0.I've posted my source below, ignore the JavaScript for now.&nbsp;install-2.php[HTML]&lt;!DOCTYPE html&gt;&lt;html&gt;&lt;head&gt;&nbsp; &nbsp; &lt;title&gt;Live Chat Admin&lt;/title&gt;&nbsp; &nbsp; &lt;link rel=&quot;stylesheet&quot; href=&quot;install_style.css&quot; type=&quot;text/css&quot; /&gt;&nbsp; &nbsp; &lt;script src=&quot;//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js&quot;&gt;&lt;/script&gt;&lt;/head&gt;&lt;body&gt;&lt;div id=&quot;install_container&quot;&gt;&lt;h1&gt;Live Chat Administration&lt;/h1&gt;&lt;input type=&quot;text&quot; id=&quot;username&quot; name=&quot;username&quot; placeholder=&quot;Admin Username...&quot; /&gt;&lt;br /&gt;&lt;input type=&quot;password&quot; id=&quot;password&quot; name=&quot;password&quot; placeholder=&quot;Admin Password...&quot; /&gt;&lt;br /&gt;&lt;a href=&quot;&quot; id=&quot;goBack&quot;&gt;Go Back&lt;/a&gt;&lt;a href=&quot;index.php&quot; class=&quot;transition&quot;&gt;Complete Setup&lt;/a&gt;&lt;div id=&quot;tip&quot;&gt;&lt;p&gt;&lt;b&gt;Tip:&lt;/b&gt; Before running the installation, you should create the database and run the SQL files included in the ZIP&lt;/p&gt;&lt;/div&gt;&lt;/div&gt;&lt;/body&gt;&lt;script type=&quot;text/javascript&quot;&gt;$(document).ready(function() {&nbsp; &nbsp; function submitData(){&nbsp; &nbsp; var username = $('#username').val();&nbsp; &nbsp; var password = $('#password').val();&nbsp; &nbsp; &nbsp; /* get some values from elements on the page: */&nbsp; &nbsp; &nbsp; &nbsp; url = &quot;set_admin.php&quot;;&nbsp; /* Send the data using post */&nbsp; var posting = $.post( url, {username:&nbsp; username, password: password} );&nbsp; &nbsp; }&nbsp; &nbsp; $(&quot;body&quot;).css(&quot;display&quot;, &quot;none&quot;);&nbsp;&nbsp; &nbsp; $(&quot;body&quot;).fadeIn(2000);&nbsp;&nbsp; &nbsp; $(&quot;a.transition&quot;).click(function(event){&nbsp; &nbsp; &nbsp; &nbsp; submitData();&nbsp; &nbsp; &nbsp; &nbsp; event.preventDefault();&nbsp; &nbsp; &nbsp; &nbsp; linkLocation = this.href;&nbsp; &nbsp; &nbsp; &nbsp; $(&quot;body&quot;).fadeOut(1000, redirectPage);&nbsp;&nbsp; &nbsp; &nbsp; });&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; function redirectPage() {&nbsp; &nbsp; &nbsp; &nbsp; window.location = linkLocation;&nbsp; &nbsp; }&nbsp;});$(&quot;#goBack&quot;).click(function(event) {&nbsp; &nbsp; event.preventDefault();&nbsp; &nbsp; history.back(1);});&lt;/script&gt;&lt;/html&gt;[/HTML]&nbsp;set_admin.php[PHP]&lt;?php&nbsp; &nbsp; include(&quot;config.php&quot;);&nbsp; &nbsp; $con = mysql_connect($host,$usrnme,$psswrd);&nbsp; &nbsp; mysql_select_db($db, $con);&nbsp; &nbsp; $username = $_POST[&quot;username&quot;];&nbsp; &nbsp; $password = hash(&quot;sha512&quot;, $_POST['password']);&nbsp; &nbsp; $old_password = hash(&quot;sha512&quot;, &quot;password&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $q = &quot;UPDATE chat_admins SET username = '$username' AND password = '$password' WHERE username = 'Josh' AND password = '$old_password'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; if(!mysql_query($q)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $fp = fopen('config.php' , 'w');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fwrite($fp, &quot;Could not set save some setting... try again.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fclose($fp);&nbsp; &nbsp; &nbsp; &nbsp; }?&gt;[/PHP]&nbsp;Any help would be appreciated.Thanks.</blockquote>

[QUOTE="NSA, post: 201761, member: 10034"] Hello, For some reason when I post the username data to PHP, it stores it in the database as 0. I've posted my source below, ignore the JavaScript for now. install-2.php [HTML]<!DOCTYPE html> <html> <head> <title>Live Chat Admin</title> <link rel="stylesheet" href="install_style.css" type="text/css" /> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> </head> <body> <div id="install_container"> <h1>Live Chat Administration</h1> <input type="text" id="username" name="username" placeholder="Admin Username..." /> <input type="password" id="password" name="password" placeholder="Admin Password..." /> <a href="" id="goBack">Go Back</a><a href="index.php" class="transition">Complete Setup</a> <div id="tip"> Tip: Before running the installation, you should create the database and run the SQL files included in the ZIP </div> </div> </body> <script type="text/javascript"> $(document).ready(function() { function submitData(){ var username = $('#username').val(); var password = $('#password').val(); /* get some values from elements on the page: */ url = "set_admin.php"; /* Send the data using post */ var posting = $.post( url, {username: username, password: password} ); } $("body").css("display", "none"); $("body").fadeIn(2000); $("a.transition").click(function(event){ submitData(); event.preventDefault(); linkLocation = this.href; $("body").fadeOut(1000, redirectPage); }); function redirectPage() { window.location = linkLocation; } }); $("#goBack").click(function(event) { event.preventDefault(); history.back(1); }); </script> </html>[/HTML] set_admin.php [PHP]<?php include("config.php"); $con = mysql_connect($host,$usrnme,$psswrd); mysql_select_db($db, $con); $username = $_POST["username"]; $password = hash("sha512", $_POST['password']); $old_password = hash("sha512", "password"); $q = "UPDATE chat_admins SET username = '$username' AND password = '$password' WHERE username = 'Josh' AND password = '$old_password'"; if(!mysql_query($q)){ $fp = fopen('config.php' , 'w'); fwrite($fp, "Could not set save some setting... try again."); fclose($fp); } ?> [/PHP] Any help would be appreciated. Thanks. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members