PHP - Moved: My Code Runs But Does Not Work ?

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?

This topic has been moved to Miscellaneous.

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

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.

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.

Hi,
I have a script that reads data from a website and insert this into a DB and every time a record is written into DB the script gives an output on the screen
When I run this script local on my computer it runs ok and the screen update is every 20 or 30 seconds (not realtime) i though this maybe because of my computer is to slow etc.
When I upload this to the server, it's even worse, no updates at all but it does insert the records into the DB.
I believe it must be a setting in the Apache or PHP server.
Anyone please, advice

Thanks

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;
}

?>

I have a script that is mostly written in PHP with a little JS Ajax for updating. It won't stop. There are some cookies and a couple of simple sessions. I've created a 'destroy' page which destroys the session and deletes the cookies but the program still won't stop. I've deleted the files from the server - the script doesn't exist - and yet if I upload the script after several minutes it updates where it left off. I simply can't figure out how to stop of otherwise 'destroy' this script.

What I've tried:

A redirect page that includes the following:

unset($_SESSION['FOR-EACH-SESSION']);
setcookie("FOR-EACH-COOKIE", "", time() - 42000);
session_unset();
session_destroy();
die;
exit;

Deleting the script from the server does not stop the script. Yes, if I go to the script after the files have been deleted I receive a 404 error naturally. Yet, when I upload the files again the script still starts off where it left off, it has sessions from the server that still exist.

I don't get. Is there anything else I can do?

This topic has been moved to MySQL Help.

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

This topic has been moved to PHP Regex.

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

Hi all,
I have two issue with script.
1. It works in PhpEd and with apache but doesn't work at remote server with apache.
    Error is well known -  "Warning: Cannot modify header information - headers already sent "

2. when I added more than 20 records like $var = $_POST['var']; it stops work local. Error is same.


adminka_wrapp.php
Code: [Select]
<?php
$addFormatName = $_POST['addFormatName'];
$addFormatDes  = $_POST['addFormatDes'];
$page               = $_GET['page'];


if (isset($addFormatName) && isset($addFormatDes))
  {
      $page = 'add_formats';
  } else if ($page == NULL)
    {
        $page =  "user_access_log";
    }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <link rel="stylesheet" type="text/css" href="../style/adminkaview.css">       
    </head>
    <body>
        <div class="col-wrap1">
            <div class="col-wrap2">
                <div class="col1">
                    <div class="content" id="c1">
                        <p><a href="?page=view_add_format">Format and extensions</a></p>
                    </div>
                </div>
                <div class="col2">
                    <div class="content" id="c2">
<?php require("$page.php");?>
                    </div>
                </div>
                <div class="clear"></div>
            </div>
        </div>
    </body>
</html>

view_add_format.php
Code: [Select]
<?php
require_once "../function.php"; 

$q = connect("SELECT
                      `formats`.*
              FROM
                       `xxx`.`formats` 
            ");
echo "<form method='post' action='adminka_wrapp.php'>
     <table>
            <tr>
                <td>id</td>
                <td>Formats Name</td>
                <td>Description</td>
            </tr>";             
  while($rowResult = $q->fetch_assoc())
  {
    echo "<tr>";  
    $id            = $rowResult["id"];  
    $formatName    = $rowResult["f_name"];  
    $description   = $rowResult["description"];
    echo    "<td>".$id."</td>"
           ."<td>".$formatName."</td>"
           ."<td>".$description."</td>";
    echo "</tr>";
  }
  
echo " <tr>
           <td>
               <input type='submit' value='AddFormat' name='submitAddFormat'>
           </td>
           <td>
                <input type='text' name='addFormatName' maxlength='20' size='5'>
            </td>
            <td>
                <input type='text' name='addFormatDes' maxlength='20' size='5'>
            </td>    
                ";                
echo "</table>
      </form>";          
?>

add_formats.php
Code: [Select]
<?php
require "../function.php"; 
 
  if (isset($addFormatName) && isset($addFormatDes) )
 {
   
        $q  = connect("INSERT INTO  
                                   `xxx`.`formats`     
                                   (`id`
                                   ,`f_name`
                                   ,`description`
                                   )
                       VALUE
                                   (NULL
                                   ,'$addFormatName'
                                   ,'$addFormatDes'
                                   )               
                   ");   
        header("Location: adminka_wrapp.php?page=view_add_format");
        exit();     
 }
?>

function.php
Code: [Select]
<?php
function connect($query)
{
  $db = new mysqli('127.0.0.1', 'xxx', 'xxx', 'xxx');
  if (mysqli_connect_errno()) 
     {
         printf("Connect failed: %s\n", mysqli_connect_error());
         exit();
     }
$result = $db->query($query);
$db->close();
return $result;   
}
?>

This topic has been moved to MySQL Help.

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

This topic has been moved to Miscellaneous.

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

This topic has been moved to PHP Applications.

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

Hello there   After a few years of spending less and less time coding, I've got a lot of catching up to do. Back when I left I usually would run without classes. Now this is a big deal for me today.   I do understand the concept of classes and already did some working models, mostly from my learning process.   Now here is what is bothering me:

<?PHP

class database {
	// Variables
	public $test;
	
	// Constructor
	public function __construct()
	{
		$test = "4";
	}
	
	
	// Functions
	//
	public function test()
	{
		var_dump($this->test);
	}
	
}

$test = new database;

$test->test();

?>

Wether I run this script on itself, nor through another file, this does work. What i get is:   NULL   The constructor does run, I did an echo inside it. Also it does not matter if the variable is public, private or protected - it will be always NULL.   Error_reporting is on E_ALL, does not show any errors.   What have I overlooked?