Guest User

Untitled

a guest
Sep 3rd, 2015
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.74 KB | None | 0 0
  1. $username = $_POST['username'];
  2. $password = $_POST['password'];
  3. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
  4.  
  5. while($row = mysql_fetch_array($result))
  6. {
  7. echo $row['FirstName'];
  8. }
  9.  
  10. $username = mysql_real_escape_string($_POST['username']);
  11. $password = $_POST['password'];
  12. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '$username'");
  13.  
  14. if($result === FALSE) {
  15. die(mysql_error()); // TODO: better error handling
  16. }
  17.  
  18. while($row = mysql_fetch_array($result))
  19. {
  20. echo $row['FirstName'];
  21. }
  22.  
  23. mysql_connect($host, $username, $password) or die("cannot connect");
  24. mysql_select_db($db_name) or die("cannot select DB");
  25.  
  26. $sql = "SELECT * FROM table_name";
  27. $result = mysql_query($sql);
  28.  
  29. if (false === $result) {
  30. echo mysql_error();
  31. }
  32.  
  33. mysql_query("
  34. SELECT * FROM Users
  35. WHERE UserName
  36. LIKE '".mysql_real_escape_string ($username)."'
  37. ");
  38.  
  39. $username = $_POST['username'];
  40. $password = $_POST['password'];
  41.  
  42. $result = mysql_query("
  43. SELECT * FROM Users
  44. WHERE UserName LIKE '".mysql_real_escape_string($username)."'
  45. ");
  46.  
  47. if($result)
  48. {
  49. while($row = mysql_fetch_array($result))
  50. {
  51. echo $row['FirstName'];
  52. }
  53. } else {
  54. echo 'Invalid query: ' . mysql_error() . "n";
  55. echo 'Whole query: ' . $query;
  56. }
  57.  
  58. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '$username'");
  59.  
  60. mysql_select_db('database name ')or DIE('Database name is not available!');
  61.  
  62. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
  63.  
  64. f($result === FALSE) {
  65. die(mysql_error());
  66.  
  67. $username = $_POST['username'];
  68. $password = $_POST['password'];
  69. $query = "SELECT * FROM Users WHERE UserName LIKE '$username'";
  70. echo $query;
  71. $result = mysql_query($query);
  72.  
  73. if($result === FALSE) {
  74. die(mysql_error("error message for the user"));
  75. }
  76.  
  77. while($row = mysql_fetch_array($result))
  78. {
  79. echo $row['FirstName'];
  80. }
  81.  
  82. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '%$username%'");
  83. while($row = mysql_fetch_array($result))
  84. {
  85. echo $row['FirstName'];
  86. }
  87.  
  88. $username = $_POST['username'];
  89. $password = $_POST['password'];
  90. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '%$username%'") or die(mysql_error());
  91.  
  92. while($row = mysql_fetch_array($result))
  93. {
  94. echo $row['FirstName'];
  95. }
  96.  
  97. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
  98.  
  99. $username = $_POST['username'];
  100. $password = $_POST['password'];
  101. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
  102.  
  103. if( $result === FALSE ) {
  104. trigger_error('Query failed returning error: '. mysql_error(),E_USER_ERROR);
  105. } else {
  106. while( $row = mysql_fetch_array($result) ) {
  107. echo $row['username'];
  108. }
  109. }
  110.  
  111. $query = "SELECT Name,Mobile,Website,Rating FROM grand_table order by 4";
  112.  
  113. while( $data = mysql_fetch_array($query))
  114. {
  115. echo("<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td>$data[3]</td></tr>");
  116. }
  117.  
  118. $username = $_POST['username'];
  119. $password = $_POST['password'];
  120. $result = mysql_query("SELECT * FROM Users WHERE UserName ='$username'");
  121.  
  122. while($row = mysql_fetch_array($result))
  123. {
  124. echo $row['FirstName'];
  125. }
  126.  
  127. <?php
  128. $username = $_POST['username'];
  129. $password = $_POST['password'];
  130. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '".$username."'");
  131.  
  132. while($row = mysql_fetch_array($result))
  133. {
  134. echo $row['FirstName'];
  135. }
  136. ?>
  137.  
  138. mysql_query("SELECT * FROM Users WHERE UserName ='".$username."'");
  139.  
  140. $username = $_POST['username'];
  141. $password = $_POST['password'];
  142.  
  143. $sql = "SELECT * from Users WHERE UserName LIKE '$username'";
  144. $result = mysql_query($sql,$con);
  145.  
  146. while($row = mysql_fetch_array($result))
  147. {
  148. echo $row['FirstName'];
  149. }
  150.  
  151. $results = mysql_query($connt, "SELECT * FROM users");
  152.  
  153. <?php
  154. $servername = "localhost";
  155. $username = "username";
  156. $password = "password";
  157. $dbname = "myDB";
  158.  
  159. // Create connection
  160. $conn = new mysqli($servername, $username, $password, $dbname);
  161. // Check connection
  162. if ($conn->connect_error) {
  163. die("Connection failed: " . $conn->connect_error);
  164. }
  165.  
  166. $sql = "SELECT id, firstname, lastname FROM MyGuests";
  167. $result = $conn->query($sql);
  168.  
  169. if ($result->num_rows > 0) {
  170. // output data of each row
  171. while($row = $result->fetch_assoc()) {
  172. // code here
  173. }
  174. } else {
  175. echo "0 results";
  176. }
  177. $conn->close();
  178. ?>
  179.  
  180. $username = $_POST['username'];
  181. $password = $_POST['password'];
  182. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
  183. if(!$result)
  184. {
  185. echo "error executing query: "+mysql_error();
  186. }else{
  187. while($row = mysql_fetch_array($result))
  188. {
  189. echo $row['FirstName'];
  190. }
  191. }
  192.  
  193. if (isset($_GET['q1mrks']) && isset($_GET['marks']) && isset($_GET['qt1'])) {
  194. $Q1mrks = $_GET['q1mrks'];
  195. $marks = $_GET['marks'];
  196. $qt1 = $_GET['qt1'];
  197.  
  198. $qtype_qry = mysql_query("
  199. SELECT *
  200. FROM s_questiontypes
  201. WHERE quetype_id = '$qt1'
  202. ");
  203. $row = mysql_fetch_assoc($qtype_qry);
  204. $qcode = $row['quetype_code'];
  205.  
  206. $sq_qry = "
  207. SELECT *
  208. FROM s_question
  209. WHERE quetype_code = '$qcode'
  210. ORDER BY RAND() LIMIT $Q1mrks
  211. ";
  212. $sq_qry = mysql_query("
  213. SELECT *
  214. FROM s_question
  215. WHERE quetype_code = '$qcode'
  216. LIMIT $Q1mrks
  217. ");
  218. while ($qrow = mysql_fetch_array($sq_qry)) {
  219. $qm = $qrow['marks'] . "<br />";
  220. $total += $qm . "<br />";
  221. }
  222. echo $total . "/" . $marks;
  223. }
  224.  
  225. include_once(db_connetc.php');
  226.  
  227. // Create a connection
  228. $connection = mysql_connect("localhost", "root", "") or die(mysql_error());
  229.  
  230. //Select database
  231. mysql_select_db("db_name", $connection) or die(mysql_error());
  232.  
  233. $employee_query = "SELECT * FROM employee WHERE `id` ='".$_POST['id']."';
  234.  
  235. $employee_data = mysql_query($employee_query);
  236.  
  237. if (mysql_num_rows($employee_data) > 0) {
  238.  
  239. while ($row = mysql_fetch_array($employee_data)){
  240. echo $row['emp_name'];
  241. } // end of while loop
  242. } // end of if
  243.  
  244. $username = $_POST['uname'];
  245.  
  246. $password = $_POST['pass'];
  247.  
  248. $result = mysql_query('SELECT * FROM userData WHERE UserName LIKE $username');
  249.  
  250. if(!empty($result)){
  251.  
  252. while($row = mysql_fetch_array($result)){
  253. echo $row['FirstName'];
  254. }
  255. }
  256.  
  257. <?php
  258. $username = $_POST['username'];
  259. $password = $_POST['password'];
  260.  
  261. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '".mysql_real_escape_string($username)."'")or die(mysql_error());
  262. while($row=mysql_fetch_array($result))
  263. {
  264. echo $row['FirstName'];
  265. }
  266. ?>
  267.  
  268. $username = $_POST['username'];
  269. $password = $_POST['password'];
  270. $result = mysql_query("SELECT * FROM Users WHERE UserName =`$usernam`");
  271.  
  272. $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '%$username%'");
  273.  
  274. if (isset($_GET['q1mrks']) && isset($_GET['marks']) && isset($_GET['qt1'])) {
  275. $Q1mrks = $_GET['q1mrks'];
  276. $marks = $_GET['marks'];
  277. $qt1 = $_GET['qt1'];
  278.  
  279. $qtype_qry = mysql_query("
  280. SELECT *
  281. FROM s_questiontypes
  282. WHERE quetype_id = '$qt1'
  283. ");
  284. $row = mysql_fetch_assoc($qtype_qry);
  285. $qcode = $row['quetype_code'];
  286.  
  287. $sq_qry = "
  288. SELECT *
  289. FROM s_question
  290. WHERE quetype_code = '$qcode'
  291. ORDER BY RAND() LIMIT $Q1mrks
  292. ";
  293. $sq_qry = mysql_query("
  294. SELECT *
  295. FROM s_question
  296. WHERE quetype_code = '$qcode'
  297. LIMIT $Q1mrks
  298. ");
  299. while ($qrow = mysql_fetch_array($sq_qry)) {
  300. $qm = $qrow['marks'] . "<br />";
  301. $total += $qm . "<br />";
  302. }
  303. echo $total . "/" . $marks;
  304. }
  305.  
  306. $username = $_POST['username'];
  307. $password = $_POST['password'];
  308. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
  309.  
  310. if($result){
  311. while($row = mysqli_fetch_array($result))
  312. {
  313. echo $row['FirstName'];
  314. }
  315. }
  316.  
  317. $username = $_POST['username'];
  318. $password = $_POST['password'];
  319. $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE {$username}');
  320.  
  321. while($row = mysql_fetch_array($result))
  322. {
  323. echo $row['FirstName'];
  324. }
Add Comment
Please, Sign In to add comment