PHP - Pdo Runs Twice When Everything Else Is Commented Out

How would I go about settings up a verification system with scripts that I write, so that I could sell scripts but if they were to get leaked or something I could kill the script, is there a way to set up a IP verification system when a script is run through CLI so it only runs if someones IP matches the one in the script?

Hello all, 
I have a php file connecting to phpmyadmin on xampp. I set the localhost password to ‘password’ I run the script with ajax and it does work because I tested it with a filecreate. I get NO errors and all I want to do is check and see if the email exists and if not then create a row in the database.

<?php
// Connect to Phpmyadmin database localhost.
$hostname = "localhost";//"";127.0.0.1
$username = "root";
$password = "password";//"password";
$dbname = "test";

$conn = new mysqli($hostname, $username, $password, $dbname);
if($conn -> connect_error) {
	die("Connection failed: " . $conn -> connect_error);
}
// USED to CHANGE the db. - (mysqli_select_db($con, "test") or die());

/* Check to make all fields entered -make sure submitted- #2*/
if(isset($_POST["register"])) {
	if(!$_POST["email"] | !$_POST["password"] | !$_POST["password2"]) {
		die("You did not fill in all the fields");
	}

/* do escape strings for SQL injection */
$emailsafe = mysqli_real_escape_string($conn, $_POST["email"]);
$passsafe = mysqli_real_escape_string($conn, $_POST["password"]);
$pass2safe = mysqli_real_escape_string($conn, $_POST["password2"]);

/* Check and see if email EXISTS in db. */

/* Insert email in db if does not exist */
$sql = "SELECT email FROM users WHERE email = '$emailsafe'";//limit 1
$result = $conn->query($sql) or die("invalid email check " . mysqli_error($conn));
$numrows = mysqli_num_rows($result);
if($numrows != 0) {
	die("Sorry the email " . $_POST["email"] . "is already in use");
}
// check if passwords both match
if($_POST["password"] != $_POST["password2"]) {
	die("Passwords did NOT match");
}
// if passwords match encrypt
$hashedpass = password_hash($passsafe, PASSWORD_DEFAULT);
// With everything escaped and hashed INSERT into db.
$sqlINSERT = "INSERT INTO users(email, password) " .
	"VALUES('" . $emailsafe ."','". $hashedpass ."')";
if($query = $conn->query($sqlINSERT)=== TRUE) {
	echo '<script type="text/javascript">alert("Successfully INSERTed");</script>';
} else {
	die("Unsuccessful");
}
$conn->close();
?>

I ran my php with ajax and it creates the file successfully so i know it runs. I wanted to setup PHP debugging with atom or visual studio but i have not been able to successfully do that... I tried with xdebug so i just use the network tab inchrome to find if errors exist.
I wish i was able to run debug line by line I use xampp for some reason my network tab makes me use mysqli I thought the newest php just used mysql I downloaded the php7 and put it on my hard drive but there was no php.ini to setup xdebug. I found a php.ini in xampp but that did not correctly do it. I also downloaded the NEWEST xampp thinking that was the problem.. packages on atom followed many different guides online but nothing was successful.

Write a function Counter() that keeps track of the number of times it is called. This function should not take any parameters and return the number of times that it has been called.

I have this function and for some reason it is running over 100 queries on page load.  I'm not sure what I am doing wrong.  Can I please get some guidance on this?

Code: [Select]
<?php

function fetch_users($page = 1, $per_page = 20, $type = null, $country = null, $state = null)
{
$start = (int)(($page - 1) * $per_page);
$per_page = (int)$per_page;
$type  = (int)$type;
$country  = (int)$country;
$state  = (int)$state;

$sql = "SELECT
                `users`.`id`,
                `users`.`firstname`,
                `users`.`lastname`,
                `users`.`username`,
                `users`.`email`,
                `users`.`gender`,
                `users`.`accounttype`,
                `users`.`personalweb`,
                `users`.`guestviews`,
                `users`.`iviews`,
                `users`.`eviews`,
                `users`.`credentials`,
                `users`.`specialties`,
                `users`.`country`,
                `users`.`city`,
                `users`.`state`,
                `users`.`phonenumber`,
                `users`.`dateofbirth` AS `dob`,
`users`.`mail_status`,
`users`.`status`,
                `investor_info`.`investor_type`,
                DATE_FORMAT(`users`.`dateofbirth`,'%D') AS `dayofbirth`,
                DATE_FORMAT(`users`.`dateofbirth`,'%c') AS `monthofbirth`,
                DATE_FORMAT(`users`.`dateofbirth`,'%Y') AS `yearofbirth`,
                DATE_FORMAT(`users`.`dateofbirth`,'%D \of %M %Y') AS `dateofbirth`,
                DATE_FORMAT(`users`.`signupdate`,'%h:%i %p %M %e, %Y') AS `signupdate`,
                SUM(`investor_info`.`capital_available`) AS `totalavailable`,
`companytype`,
`capital`
            FROM `users`
            LEFT JOIN `investor_info`
            ON `users`.`id` = `investor_info`.`uid`
            LEFT OUTER JOIN employees
            ON users.id = employees.userid
            LEFT OUTER JOIN (
SELECT 
companies.companyid, 
companies.companytype AS `companytype`,
SUM(companies.capital) AS `capital`
FROM  `companies`
GROUP BY companies.companytype) SumCompanies
            ON employees.companyid = SumCompanies.companyid
WHERE `users`.`status` > 2 ";

if($type != null)
{
$acctype = $type - 1;

$sql.= "AND`users`.`accounttype` = {$acctype} ";
}

if($country != null)
{
$sql.= "AND`users`.`country` = {$country} ";
}

if($state != null)
{
$sql.= "AND`users`.`state` = {$state} ";
}

$sql.= "GROUP BY `users`.`id` 
ORDER BY `users`.`id` DESC 
LIMIT {$start}, {$per_page}";

$result = mysql_query($sql) or die(mysql_error());

$users = array();

$i = 0;

while($row = mysql_fetch_assoc($result))
{
$users[$i] = array(
'id'  => $row['id'],
'firstname'  => $row['firstname'],
'lastname'  => $row['lastname'],
'username'  => $row['username'],
'email'  => $row['email'],
'gender'  => $row['gender'],
'accounttype'  => $row['accounttype'],
'guestviews' => $row['guestviews'],
'iviews'  => $row['iviews'],
'eviews'  => $row['eviews'],
'credentials'  => $row['credentials'],
'specialties'  => $row['specialties'],
'country'  => $row['country'],
'state'  => $row['state'],
'city'  => $row['city'],
'phonenumber'  => $row['phonenumber'],
'dob'  => $row['dob'],
'mail_status'  => $row['mail_status'],
'status'  => $row['status'],
'investor_type'  => $row['investor_type'],
'dayofbirth'  => $row['dayofbirth'],
'monthofbirth'  => $row['monthofbirth'],
'yearofbirth'  => $row['yearofbirth'],
'dateofbirth'  => $row['dateofbirth'],
'signupdate'  => $row['signupdate'],
'totalavailable'  => $row['totalavailable'],
'companytype'  => $row['companytype'],
'capital'  => $row['capital'],
);

$i++;
}

return $users;
}

?>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=356031.0