Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.05 KB | None | 0 0
  1. <?php
  2.  
  3. $host = "host";
  4. $db = "db";
  5. $user = "user";
  6. $pass = "pass";
  7.  
  8. $connection = mysql_connect($host, $user, $pass);
  9.  
  10. if(!$connection)
  11. {
  12. die("Database server connection failed.");
  13. }
  14. else
  15. {
  16. $dbconnect = mysql_select_db($db, $connection);
  17.  
  18. if(!$dbconnect)
  19. {
  20. die("Unable to connect to the specified database!");
  21. }
  22. else
  23. {
  24. $query = "SELECT * FROM tests";
  25. $resultset = mysql_query($query, $connection);
  26.  
  27. $records = array();
  28.  
  29. while($r = mysql_fetch_assoc($resultset))
  30. {
  31. $records[] = $r;
  32. }
  33.  
  34. echo json_encode($records);
  35. }
  36. }
  37.  
  38. ?>
  39.  
  40. CREATE TABLE IF NOT EXISTS `tests` (
  41. `id` int(11) NOT NULL AUTO_INCREMENT,
  42. `testName` varchar(255) DEFAULT NULL,
  43. `testPop` int(11) DEFAULT NULL,
  44. PRIMARY KEY (`id`)
  45. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
  46.  
  47. INSERT INTO `tests` (`id`, `testName`, `testPop`) VALUES
  48. (1, 'Test 1', '0'),
  49. (2, 'Test 2', '0'),
  50. (3, 'Test 3', '0'),
  51. (4, 'Test 4', '0'),
  52. (5, 'Test 5', '0'),
  53. (6, 'Test 6', '0'),
  54. (7, 'Test 7', '0'),
  55. (8, 'Test 8', '0'),
  56. (9, 'Test 9', '0'),
  57. (10, 'Test 10', '0'),
  58. (11, 'Test 11', '0'),
  59. (12, 'Test 12', '0');
  60.  
  61. func retrieveData() {
  62.  
  63. let getDataURL = "http://exampleip.org/tests.php"
  64. let url: NSURL = NSURL(string: getDataURL)!
  65.  
  66. do {
  67.  
  68. let data: Data = try Data(contentsOf: url as URL)
  69. jsonArray = try JSONSerialization.jsonObject(with: data, options: .mutableContainers) as! NSMutableArray
  70.  
  71. // Looping through jsonArray
  72. for i in 0..<jsonArray.count {
  73.  
  74. // Create Test Object
  75. let tID: String = (jsonArray[i] as AnyObject).object(forKey: "id") as! String
  76. let tName: String = (jsonArray[i] as AnyObject).object(forKey: "testName") as! String
  77. let tPop: String = (jsonArray[i] as AnyObject).object(forKey: "testPop") as! String
  78.  
  79. // Add Test Objects to Test Array
  80. testArray.append(Test(testName: tName, andTestPop: tPop, andTestID: tID))
  81.  
  82. }
  83. }
  84. catch {
  85. print("Error: (Retrieving Data)")
  86. }
  87.  
  88. myTableView.reloadData()
  89. }
  90.  
  91. @IBAction func addPointButtonClick(_ sender: UIButton!) {
  92.  
  93. // Adding row to tag
  94. let buttonPosition = (sender as AnyObject).convert(CGPoint.zero, to: self.myTableView)
  95. if let indexPath = self.myTableView.indexPathForRow(at: buttonPosition) {
  96.  
  97. // Change pointAdd to addedPoint Image
  98. (sender as UIButton).setImage(UIImage(named: "pointAdd.png")!, for: .normal)
  99. cell.pointAddButton.isHidden = true
  100. cell.addedPointButton.isHidden = false
  101.  
  102. self.myTableView.beginUpdates()
  103.  
  104. // ----- Inserting Cell to Section 0 -----
  105. addedPointsArray.insert(testArray[indexPath.row], at: 0)
  106. myTableView.insertRows(at: [IndexPath(row: 0, section: 0)], with: .fade)
  107.  
  108. // ----- Removing Cell from Section 1 -----
  109. testArray.remove(at: indexPath.row)
  110. let rowToRemove = indexPath.row
  111. self.myTableView.deleteRows(at: [IndexPath(row: rowToRemove, section: 1)], with: .fade)
  112.  
  113. self.myTableView.endUpdates()
  114.  
  115. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement