Guest User

Untitled

a guest
Jan 14th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. $.ajax({
  2. url: "createchild.php",
  3. type: 'POST',
  4. data: ({ATU:ATUv,AM:AMv,ATS:ATSv,segment:segmentv,acrcat:acrcatv,owner:childowner,topparent:childtp}),
  5. success: function(msg) {
  6. console.log(msg);
  7. }
  8.  
  9. <?php
  10. header('Content-type: text/plain; charset=utf-8');
  11. $servername = "xxxxxxxxxxxxx";
  12. $username = "xxxxxxxxxxxxxxxxxxxx";
  13. $password = "xxxxxxxxxxxxxxx";
  14. $dbname = "xxxxxxxxxxxxx";
  15.  
  16. // Create connection
  17. $conn = new mysqli($servername, $username, $password, $dbname);
  18. // Check connection
  19. if ($conn->connect_error) {
  20. die("Connection failed: " . $conn->connect_error);
  21. }
  22. $sql ="INSERT INTO tablename (top_parent, qualified,retry,partner_attached,partner_name,migration,sap,AM,ATS,ATU,owner,engagement,segment,acr_cat,childtp)
  23. VALUES ('" . $_POST['childname'] . "','No','Unknown','No','Unknown','Not Qualified','Not Qualified','" . $_POST['AM'] . "','" . $_POST['ATS'] . "','" . $_POST['ATU'] . "','" . $_POST['owner'] . "','No','" . $_POST['segment'] . "','" . $_POST['acrcat'] . "','" . $_POST['topparent'] . "'); ";
  24.  
  25. if ($conn->multi_query($sql) === TRUE) {
  26. echo "New record created successfully";
  27. echo "".$_POST['$childname']."";
  28.  
  29. } else {
  30. echo "Error: " . $sql . "<br>" . $conn->error;
  31. echo "".$_POST['$childname']."";
  32. }
  33.  
  34. $conn->close();
  35. ?>
Add Comment
Please, Sign In to add comment