Advertisement
Guest User

Untitled

a guest
Mar 29th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. unserialize(): Error at offset 221 of 225 bytes
  2.  
  3. <?php
  4. $servername = "localhost";
  5. $username = "xxxx";
  6. $password = "xxxx";
  7. $dbname = "xxxxx"; // Create connection
  8. $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection
  9. if (!$conn) {
  10. die("Connection failed: " . mysqli_connect_error());
  11. }
  12. $s=range(001,150);
  13. shuffle($s);
  14. echo $s[0];
  15. //$m=base64_encode(serialize($s));
  16. $m=serialize($s);
  17. $sql = "UPDATE renu_testgani SET qorder='$m' WHERE qno=2";
  18. if (mysqli_query($conn, $sql)) {
  19. echo "Record updated successfully";
  20. } else {
  21. echo "Error updating record: " . mysqli_error($conn);
  22. }
  23. mysqli_close($conn);
  24. ?>
  25.  
  26. <?php
  27. session_start();
  28. $servername = "xxxx";
  29. $username = "xxxx";
  30. $password = "xxxx";
  31. $dbname = "xxxx";
  32. $conn = new mysqli($servername, $username, $password, $dbname); // Check connection
  33. if ($conn->connect_error) {
  34. die("Connection failed: " . $conn->connect_error);
  35. }
  36. $q=array();
  37. $sql = "SELECT qorder FROM renu_testgani WHERE qno=2";
  38. $result = $conn->query($sql);
  39. if ($result->num_rows > 0) {
  40. //output data of each row
  41. while($row = $result->fetch_assoc()) {
  42. $w=$row["qorder"];
  43. }
  44. } else {
  45. echo "0 results";
  46. }
  47. $q=unserialize($w);
  48. echo $q[0];
  49. $conn->close();
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement