Advertisement
Guest User

Untitled

a guest
Mar 29th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. Customerinfo.php
  2. <?php
  3. require './databaseconnect.php';
  4.  
  5. session_start();
  6.  
  7. $_SESSION['CustomerName'] = str_replace("'", "", $_REQUEST['CustomerName']);
  8. $_SESSION['CustomerCompany'] = str_replace("'", "", $_REQUEST['CustomerCompany']);
  9. $_SESSION['CustomerEmail'] = str_replace("'", "", $_REQUEST['CustomerEmail']);
  10. $_SESSION['CustomerIssue'] = str_replace("'", "", $_REQUEST['CustomerIssue']);
  11.  
  12. $create_customer = "INSERT INTO customers (CustomerName, CustomerCompany, CustomerEmail, CustomerIssue)" .
  13. "VALUES ('{$_SESSION['CustomerName']}', '{$_SESSION['CustomerCompany']}', '{$_SESSION['CustomerEmail']}', '{$_SESSION['CustomerIssue']}');";
  14.  
  15. mysql_query($create_customer)
  16. or die(mysql_error());
  17.  
  18. $sql ="SELECT * FROM customers WHERE CustomerName = '{$_SESSION['CustomerName']}' and CustomerCompany = '{$_SESSION['CustomerCompany']}' and CustomerEmail = '{$_SESSION['CustomerEmail']}' and CustomerIssue = '{$_SESSION['CustomerIssue']}'";
  19. $result = mysql_query($sql);
  20. $row = mysql_fetch_array($result);
  21.  
  22. $_SESSION['SessionID'] = $row[0];
  23.  
  24. $customerissue = '<div class="clienttext"><p class="clientname"><img src="./Images/chatleft.png"/>&nbsp;'.$_SESSION['CustomerName'].':</p>
  25. <p>'.str_replace("'", "", $_SESSION['CustomerIssue']).'</p></div>';
  26.  
  27. $startconvo = "INSERT INTO conversion (SessionID, ConvText)"."VALUES ('{$_SESSION['SessionID']}', '{$customerissue}')";
  28. mysql_query($startconvo)
  29. or die(mysql_error());
  30.  
  31. ?>
  32. db.php
  33. <?php
  34. $host = 'localhost';
  35. $dbname = 'bxurqygq_ToDo';
  36. $user = 'bxurqygq_Matthew';
  37. $pass = 'COD4-f081';
  38.  
  39. try{
  40. $DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
  41. }
  42. catch(PDOException $e){
  43. echo $e->getMessage();
  44. }
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement