Guest User

Untitled

a guest
Aug 27th, 2018
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.27 KB | None | 0 0
  1. Using variables defined in an included file (included by another file) in the including file in php
  2. $dbhost = "localhost";
  3. $dbname = "mydbname";
  4. $dbuser = "myuserid";
  5. $dbpass = "mypass";
  6. $dblink = mysql_connect($dbhost, $dbuser, $dbpass);
  7. mysql_select_db($dbname,$dblink);
  8.  
  9. $errorlogs = "c:/wamp/www/smstrunk/tmp/weblogs.log";
  10. $displaycount = 2;
  11. $querylimit = "LIMIT $displaycount";
  12. $maximportfilesize = 2097152;
  13.  
  14. include("firstfile.php");
  15.  
  16. //Returns the GET/POST parameter value
  17. function getPassedParam($param){
  18.  
  19. if(isset($_POST[$param])) $value = $_POST[$param];
  20. elseif(isset($_GET[$param])) $value = $_GET[$param];
  21. else $value = "";
  22.  
  23. return $value;
  24. }
  25. //##########################################
  26.  
  27. // DB Functions
  28. function selectSQL($qry, $dblink){
  29.  
  30. global $errorlogs;
  31.  
  32. $result = mysql_query($qry, $dblink);
  33. if (!$result) {
  34. log2File("Invalid query: " . mysql_error());
  35. return false;
  36. }
  37. log2File($qry);
  38.  
  39. return $result;
  40. }
  41.  
  42. function updateSQL($qry, $dblink){
  43.  
  44. $result = mysql_query($qry, $dblink);
  45. if (!$result) {
  46. log2File("Invalid query: " . mysql_error());
  47. return false;
  48. }
  49. log2File($qry);
  50.  
  51. return mysql_affected_rows($dblink);
  52. }
  53.  
  54. function insertSQL($qry, $dblink){
  55. echo $displaycount;
  56. $result = mysql_query($qry, $dblink);
  57. if (!$result) {
  58. log2File("Invalid query: " . mysql_error());
  59. return false;
  60. }
  61. log2File($qry);
  62.  
  63. return mysql_insert_id();
  64.  
  65. }
  66. //##########################################
  67.  
  68. //Mailing Functions
  69. function auto_reg_mail($to, $message){
  70.  
  71. $subject = 'Registration Confirmation';
  72. $headers = 'From: noreply@smstrunk.com' . "rn" . 'X-Mailer: PHP/' . phpversion();
  73.  
  74. mail($to, $subject, $message, $headers);
  75. }
  76. //##########################################
  77.  
  78.  
  79. //Logging Function
  80. function log2File($message, $file=NULL){
  81.  
  82. global $errorlogs;
  83. if($file == NULL)$file = $errorlogs;
  84.  
  85. $msg = date("Y-m-d H:m:s") . " [" . $_SERVER['PHP_SELF'] . "] $message n";
  86. error_log($msg, 3, $file);
  87. }
  88. //##########################################
  89.  
  90.  
  91. // Application Specific Functions
  92. // 1. Get customer id from msisdn
  93. function getCustID($msisdn, $lowner, $dblink, $alias = ""){
  94.  
  95. //Check if msisdn already exists for this user
  96. $sql = sprintf("SELECT custid, mstatus FROM msisdn WHERE number = '%s' AND owner = '$lowner'", mysql_real_escape_string($msisdn));
  97. $rsmsisdn = selectSQL($sql, $dblink);
  98.  
  99. if($rwmsisdn = mysql_fetch_assoc($rsmsisdn)){
  100. $custID = $rwmsisdn['custid'];
  101. $mstatus = $rwmsisdn['mstatus'];
  102. $sql = sprintf("UPDATE msisdn SET mstatus = 0, alias = '%s' WHERE custID = '$custID'", mysql_real_escape_string($alias));
  103. updateSQL($sql, $dblink);
  104. }else{
  105. // if not insert number
  106. $sql = sprintf("INSERT INTO msisdn (number, owner, alias) VALUES ('%s', '$lowner', '%s')", $msisdn, mysql_real_escape_string($alias));
  107. $custID = insertSQL($sql, $dblink);
  108. }
  109. return $custID;
  110. }
  111.  
  112. ?>
  113.  
  114. include ("secondfile.php");
  115.  
  116. echo $dblink;
Add Comment
Please, Sign In to add comment