Connecting to a mysql DB on another server

[irandoct]

Dear Friends,
I have provided an install script for a php program that need to check license code of customer on my server . I need this install script check the license code on myown server . I use mysql database. i have added two functions as below :

function license() {
SSNhead();
echo"<center>Please enter your license code here:</center>";
echo "<center><form name=\"form\" action=\"".$_SERVER['PHP_SELF']."?act=search\" method=\"post\">"
    . "<input type=\"text\" name=\"q\"/>"
    . "<input type=\"submit\" name=\"Submit\" value=\"License Check\" />"
."</form></center>";
 SSNfoot();
}
function search() {
SSNhead();
$var = @$_POST['q'] ;
$trimmed = trim($var);
if ($trimmed == "")
  {
  echo "<p><center><b><h4><font color=\"#ff0000\">Please enter your license code!</b></h4></font></center></p>";
  echo"<center><a href=\"javascript:history.back()\">go back</a></center><br>";
  exit;
  }
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }
mysql_connect("localhost","admin","123");
mysql_select_db("license") or die("Unable to select database");
$query = "select * from main where license like \"%$trimmed%\"
  order by license";
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows == 0)
  {
  echo "<center><h4><font color=\"#ff0000\">Your license code is invalid!</h4></font></center>";
  echo "<center><a target=\"_blank\" href=\"http://www.mysite.com/sales\">Club Membership</a></center>";
  }
  else {
echo "<center>Your license code verified, Thank You</center><br>";
echo "<div align=\"center\"><a href=\"".$_SERVER['PHP_SELF']."?act=install\"><b>INSTALL DATABASE TABLES</b></a></div><br>";
  }
SSNfoot();
}

This script work on local machine good . but i need this script check the customers license on myown server !
can you please modify my code ?
Thank you
Mansour

[gotissues68]

Change that line to be the same script running on your server and include a link back to the customer's server with the ?install set 🙂 That seems to me to be the easiest way to do it.

action=\"".$_SERVER['PHP_SELF']

HTH

[irandoct]

Originally posted by gotissues68
Change that line to be the same script running on your server and include a link back to the customer's server with the ?install set 🙂 That seems to me to be the easiest way to do it.

action=\"".$_SERVER['PHP_SELF']

HTH

Thank you ,
can you please explain me more about your idea ? i can't underestand your replay !
Regards

[gotissues68]

When you call the script, you're calling PHP_SELF rather, so the script on the local server, by calling "www.yourserver.com/somescript.php" instead of PHP_SELF, it will check the proper database to verify that the key the user has entered is valid and subsequently let them continue with the install.

HTH

[irandoct]

Originally posted by gotissues68
When you call the script, you're calling PHP_SELF rather, so the script on the local server, by calling "www.yourserver.com/somescript.php" instead of PHP_SELF, it will check the proper database to verify that the key the user has entered is valid and subsequently let them continue with the install.

HTH

Dear Sir,
i have made a new file (search.php) and puted it on my own server with following code :

<?php

$var = @$_Post['q'] ;
$trimmed = trim($var);
if ($trimmed == "")
  {
  echo "<p>Please enter your license code</p>";
  exit;
  }
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }
mysql_connect("localhost","dbadmin","password");
mysql_select_db("dbname") or die("Unable to select database");
$query = "select * from main where license like \"%$trimmed%\"
  order by license";
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows == 0)
  {
  echo "<center><h4><font color=\"#ff0000\">Your license code is invalid!</h4></font></center>";
  echo "<center><a target=\"_blank\" href=\"http://www.mysite.com/sales\">Club Membership</a></center>";
  }
  else {
echo "<div align=\"center\"><a href=\"ssninstaller.php?act=install\"><b>INSTALL DATABASE</b></a></div><br>";
  }
?>

also i have changed the action of form to : http://www.mysite.com/search.php

function license() {
SSNhead();
echo"<center>Please enter your license code here:</center>";
echo "<center><form name=\"form\" action=\"http://www.mysite.com/search.php\" method=\"post\">"
    . "<input type=\"text\" name=\"q\"/>"
    . "<input type=\"submit\" name=\"Submit\" value=\"License Check\" />"
."</form></center>";
 SSNfoot();
}

How can i refer to the install script on customer computer after

if ($numrows == 0)
  {

Thank You Very Much
Mansour