PHP - Defining A Constant (i Think!)

Hi,
I'm trying to echo some error message like this:
Code: [Select]
<?php echo (isset($_GET['failed']))?'.CNT_TXT_MYERRORMESSAGE.''; ?>
i know it must be a syntax error....but I'm a newb....
Thanks

hi, I have just used teh pagination from this site: http://papermashup.com/easy-php-pagination/

all is working ok apart from I get an error:

Notice: Use of undefined constant num - assumed 'num' in D:\retroandvintage.co.uk\wwwroot\default.php on line 207

line 207: Code: [Select]
$total_pages = $total_pages[num];
Please help?

here is my site: http://www.retroandvintage.co.uk/default.php?page=5

I get an undefined constant error message.  Am I using the variable correctly?  Should I use an echo to output the variable as text?

Added by <?php ${displayName}; ?>

I've been working on a registration form and it seems like the better I get at solving more complex issues the smaller issues plague me the most.

I've got the following function:

//process database actions
function process_database($post) {
  global $table;

  //connect to database
  $connect_db = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

  //check database connection
  if ($connect_db->connect_error) {
    return false;
  } else {
    if ($stmt = $connect_db->prepare( "INSERT INTO $table (firstname, lastname, username, email, password) VALUES ( ?, ?, ?, ?, ? )" ) ) {
      $stmt->bind_param(NULL, $firstname, $lastname, $username, $email, $password);

      $firstname = $post['firstname'];
      $lastname = $post['lastname'];
      $username = $post['username'];
      $email = $post['email'];
      $password = $post['password'];

      if (!$stmt->execute()) {
        return false;
      }
    } 
  }

  return true;
}

This is in a functions.php file. The issue is in the $connect_db assignment that has the constants from the config.php file in it.

That file looks like this:

<?php
ob_start();
session_start();

$timezone = date_default_timezone_set("America/xxxxxxx");

$whitelist = array('username', 'email', 'email2', 'password', 'password2');
//TODO here I've removed firstname and lastname from the whitelist as they're optional
//may add them back and try to iterate around them in the future

$table = 'users';

define('DB_HOST', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_NAME', 'means');

$conn = mysqli_connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

if($conn->connect_errno) {

    printf("Connect Failed: %s\n", $conn->connect_error);
    exit();
    
}

ob_end_flush();
?>

The constants defined in config.php are not being recognized in functions.php. I understand that constants are global and available throughout a script.

I've connected to two files with the following line:

//require config file
require_once($_SERVER['DOCUMENT_ROOT'] . '/../config/config.php');

as I have the config/config.php outside htdocs. I know this works because of a db query to check uniqueness of username that works properly.

Why are these constants coming back as undefined in the process_database().function.php? Nothing I've tried works and I've run out of ideas. TIA

I was wondering if there is a way to get a constant by using a variable connected to it, eg:


define( 'CONSTANT_LOL', 'haha' );

$var = 'LOL';

echo CONSTANT_$var;


Any help is appreciated,

Chris

I am having a problem with some php code that runs on a landing page that queries a database for the content needed to display on the template page from the keywords passed in the url. My issue is that when I tried to add some php code to the template page it reads it fails and returns

Notice: Use of undefined constant tdbd_name - assumed 'tdbd_name' in /var/www/ppcindex.php on line 147 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ppcindex.php on line 150

If anyone could point me in the right direction it would be much appreciated.

Here is the code from the landing page php





<?php 
// template variables - PLEASE CHANGE 


error_reporting(E_ALL); 
ini_set('display_errors','On'); 
define("TEMPLATE_NAME","ppcindexcontent.php"); // your page templates 
define("FULL_PATH","/var/www/speedppc/"); // true path to your speedPPC install directory 
define("MAX_ROWS",1); // maximum display rows for CSV data - we recommend no more the 100 records 

if(!isset($_GET["CSVID"])){ 
    define("CSVID", "18"); // CSVID of your csv file. leave blank if passing csvid in the url (See README.txt) 
} 
else { 
    define("CSVID", $_GET[csvid], true); 
} 

define("REPLACECHAR", '-'); // this is the replacement character for the custom function replace() 
// include files 
include(FULL_PATH."config.php"); 
include(FULL_PATH."common.php"); 

// variables passed in URL 
$csvkeyword = $_GET['csvkeyword']; 
$seed = $_GET['seed']; 
$expansion = $_GET['expansion']; 
$final = $_GET['final']; 

// connect to DB 
$dbhandle = dbconnect($host, $user, $pass, $db); 


// functions 
function replaceTokens($passedContent) { 
    global $csvkeyword, $seed, $expansion, $final; 
    $tokens = array("[%csvkeyword%]", "[%seed%]", "[%expansion%]", "[%final%]", "[%Csvkeyword%]", "[%Seed%]", "[%Expansion%]", "[%Final%]"); 
    $tokenValues = array(rs($csvkeyword), rs($seed), rs($expansion), rs($final), uc(rs($csvkeyword)), uc(rs($seed)), uc(rs($expansion)), uc(rs($final))); 
    $replacedContent = str_replace($tokens, $tokenValues, $passedContent); 
    return $replacedContent; 
} 

function stripUndefinedTokens($passedContent) { 
    $patterns = '/\[%.*?(%\]|\]|%)/'; 
    $result = preg_replace($patterns, '', $passedContent); 
    return $result; 
} 

function changeCase($passedContent) { 
    $patterns = '/\$.*?\]/'; 
    $string = $passedContent; 
    preg_match_all($patterns, $string, $matches); 
    $uniqueMatches = array_unique($matches[0]);   

    foreach($uniqueMatches as $key => $value) { 
        if(substr($value, 13, 1) == strtoupper(substr($value, 13, 1))) { 
            $string = str_replace($value, '".ucwords('.strtolower($value).')."', $string); 
        } 
    } 
    return $string; 
} 

function replaceChar($passedContent) { 
    $string = $passedContent; 
    $patterns = '/replace\(.*?\)/'; 
    preg_match_all($patterns, $string, $matches); 
    $replaceChar = '-'; 
    foreach($matches[0] as $key => $value) { 
        $valueReplaced = str_replace(' ', REPLACECHAR, $value); 
        $string = str_replace($value, $valueReplaced, $string); 
    } 
    $replace = array("replace(", ")"); 
    //$string = str_replace($replace, '', $string); 
    return $string; 
} 

function rs($passWord) { 
    return str_replace('-', ' ', $passWord); 
} 

function uc($passWord) { 
    return ucfirst($passWord); 
} 

// get CSV table Information 
$sql = "SELECT * FROM tabledb_details WHERE tdbd_id = '".CSVID."'"; 
$result = mysql_query($sql); 
$row = mysql_fetch_assoc($result); 

// replace '-' in keyword with space and also use keyword with '-' in it incase it is part of the word 
$keywordsArray = explode(",", $csvkeyword); 
$i = 0; 
foreach($keywordsArray as $key => $value) { 
    $keywords[$i] = $value; 
    $i++; 
    $position = strpos($value, '-'); 
    if($position !== false){ 
        $keywords[$i] = str_replace("-", " ", $value); 
        $i++; 
    } 
} 

// CSV fields  to search keyword occurence in 
$keywordFields = explode("|", $row[tdbd_search_fields]); 

$sqlKeyword = ' ('; 
foreach($keywords as $key => $value) { 
    $sqlKeyword .= "("; 
    foreach($keywordFields as $keyField => $valueField) { 
        $sqlKeyword .= "`" . $valueField . "` REGEXP '( |^)".$value."( |s|[\.]|$)' OR ";  
    } 
    $sqlKeyword = substr($sqlKeyword, 0, -4); 
    $sqlKeyword .= ") OR "; 
} 
$sqlKeyword = substr($sqlKeyword, 0, -4).')'; 

// set the default sql 'where' section if the keyword is not defined in url 
if($csvkeyword == '' || !isset($csvkeyword)) { 
    $sqlKeyword = '1'; 
} 




// start template Display Output 
ob_start(); 
include(TEMPLATE_NAME); 
$output = ob_get_contents(); 
ob_end_clean(); 

// get the position of the loop template 
$loopStart = strpos($output,"[start_csv_loop]"); 
$loopEnd = strpos($output,"[end_csv_loop]"); 
// get the loop template layout 
$loopTemplate = substr($output, ($loopStart+16), ($loopEnd-($loopStart+16))); 

// get content before loop template 
$preContent = stripslashes(stripUndefinedTokens(addslashes(replaceTokens(substr($output, 0, $loopStart))))); 

// get content after loop template 
$postContent = stripslashes(stripUndefinedTokens(addslashes(replaceTokens(substr($output, $loopEnd+14))))); 



// output pre content 
eval("\$preContent = \"$preContent\";"); 
print_r( replaceChar($preContent) ); 

$sqlSearch = "SELECT * FROM ".$row[tdbd_name]." WHERE ".$sqlKeyword." LIMIT ".MAX_ROWS; 
$resultSearch = mysql_query($sqlSearch); 

while($displayrows = mysql_fetch_assoc($resultSearch)) { 
    $display = replaceTokens($loopTemplate); 
    $display = str_replace('\\', '[backslash]', $display); 
    $display = str_replace('[%', '$displayrows[', $display); 
    $display = addslashes(str_replace('%]', ']', $display)); 
    $display = replaceTokens($display); 
    $display = changeCase($display); 

    eval("\$display = \"$display\";"); 

    $display = stripslashes($display); 
    $display = str_replace('[backslash]', '\\', $display); 
    $display = replaceChar($display); 

    print_r( $display ); 

} 
// output post content 
eval("\$postContent = \"$postContent\";"); 
print_r( replaceChar($postContent) ); 
?>




And here is part of the template (ppcindexcontent.php) the above code is reading.

                 <div style=" float:right; width: 300px; height: 0px; margin-top:-20px ; margin-bottom:0px"> 
                <p style=" font-size:16px; text-align: center;  line-height:1; color:#0391D1;">     

                 
<?php 
error_reporting(E_ALL); 
ini_set('display_errors','On'); 
$mySQLServer = "xxxxxx"; 
$mySQLUser = "xxxxxxxx"; 
$mySQLPass = "xxxxxxxxx"; 
$mySQLDB = "xxxxxxxxxxx";  
$SQLToday = date("m/d/y") . "<br />"; 
$SQLsevendays = mktime(0,0,0,date("n"),date("j")-7,date("Y")); 
$SQLsevenname = (date("l", $SQLsevendays)); 
$SQLsevennumber = (date("jS", $SQLsevendays)); 
$dbhandle = mssql_connect($mySQLServer, $mySQLUser, $mySQLPass) 
  or die("Couldn't connect to SQL Server on $myServer");  
$selected = mssql_select_db($mySQLDB, $dbhandle) 
  or die("Couldn't open database $myDB");  
$query = "WEB_ApproveHistory @State='CA', @Days=5, @Records=8"; 
$data = mssql_query($query); 
$result = array(); 

while ($row = mssql_fetch_object($data)) : 
 $result[] = $row; 
 $returnedresults = (97*($row->TotalApprovals)) ; 
  

endwhile; 
$englishreturnedresults = number_format($returnedresults); 
echo 'In just the last week since ' . $SQLsevenname . ' the ' . $SQLsevennumber . ' xx '; 
echo $englishreturnedresults;  
echo ' to People Just Like you In California. <br><br>Here are just a few people who' ; 

echo '<ul class="BulletCheck">'; 

mssql_next_result($data); 


while ($row = mssql_fetch_object($data)) : 

       $result[] = $row; 
       echo '<li>' . '  ' . $row->FirstName  . ' From '. $row->City . ', ' . $row->State .' PreApproved On ' .$row->ApprovedDate . '</li>'; 
endwhile; 
mssql_close($dbhandle); 
?>             

</div>

Howdy Fairly new to the whole php scene made some php code which works, but i get the error Notice: Use of undefined constant Yes - assumed 'Yes' in C:\Program Files\EasyPHP-5.3.3\www\htdocs\top.php on line 26, line 26 is the first line code, kind of lost and would appreciate an explanation on how to fix this if possible thanks!

Code: [Select]
<?php if ($players['Banned'] == Yes){ 
echo $players['name']  ?> (BANNED)

<?php } else {?>

<a href="profile.php?id=<?php echo $players['id'] ?>"><?php echo $players['name']  ?>

Code: [Select]
$entrantQuery = "SELECT entrantID FROM entrants WHERE Game = $idT";
$entrantResult = mysql_query(entrantQuery);
$entrantRow = mysql_fetch_row(entrantResult);

I have these at the start of my php (after getting $idT), but I get the error
Notice: Use of undefined constant entrantQuery - assumed 'entrantQuery' in C:\Entrants.php on line ..

Notice: Use of undefined constant entrantResult - assumed 'entrantResult' in C:\www\Entrants.php on line..

Ive used this code lots of times before, what am I missing? They are variables that I am defining!

I know that I have posted a similar question to this but I am still having some confusion that I hoped I could clear up.  Thank you all for being patient with and helping me clean up this mess.   Below is the code that is spitting out the bottom error messages.  So, I understand that the way to define a variable which uses += and not send it into a loop, generating a notice is this..   Using the top example   $meter_multiplier=0; while ($row5 = sqlsrv_fetch_array($query5)){
meter_multiplier += $row5['meter_multiplier'];
}   versus...    $meter_multiplier += $row5['meter_multiplier'];   how can I implement this type of statment below.  Should the php be called another name and reference sql that way, so the names are different?   example       $meter_multiplier=0; while ($row5 = sqlsrv_fetch_array($query5)){ meter_multiplier += $row5['meter_mult'];

<?php
$sql5 = "select meter_id, subaccount_number, service_name, service_address, service_address2, service_city, service_st, service_zip, service_contact, basic_charge, energy_charge, base_rate, intermediate_rate, peak_rate, meter_multiplier, raw_material_price FROM [radiogates].[dbo].[ops_invoice] where meter_id ='$comm_id' and subaccount_number='$session_id'";$query5 = sqlsrv_query($conn, $sql5);if ($query5 === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row5 = sqlsrv_fetch_array($query5)){  	

$meter_multiplier += $row5['meter_multiplier']; 
$raw_material_price += $row5['raw_material_price']; 
$basic_charge += $row5['basic_charge'];
$peak_rate += $row5['peak_rate']; 
$intermediate_rate += $row5['intermediate_rate']; 
$energy_charge += $row5['energy_charge'];
$base_rate += $row5['base_rate']; 
$account_number = $row5['meter_id']; 
$service_name = $row5['service_name']; 
$service_address = $row5['service_address'];
$service_address2 = $row5['service_address2']; 
$service_city = $row5['service_city']; 
$service_st = $row5['service_st']; 
$service_zip = $row5['service_zip'];} 
sqlsrv_free_stmt($query5);
?> 

Notice: Undefined variable: meter_multiplier in C:\xampp1\htdocs\Utrack\invoice.php on line 335

Notice: Undefined variable: raw_material_price in C:\xampp1\htdocs\Utrack\invoice.php on line 335

Notice: Undefined variable: basic_charge in C:\xampp1\htdocs\Utrack\invoice.php on line 335

Notice: Undefined variable: peak_rate in C:\xampp1\htdocs\Utrack\invoice.php on line 335

Notice: Undefined variable: intermediate_rate in C:\xampp1\htdocs\Utrack\invoice.php on line 335

Notice: Undefined variable: energy_charge in C:\xampp1\htdocs\Utrack\invoice.php on line 335

Notice: Undefined variable: base_rate in C:\xampp1\htdocs\Utrack\invoice.php on line 335
Edited by Butterbean, 10 January 2015 - 06:34 PM.

I need to define a query in a PHP script that will check a MySQL db - based on six variables (the six variables are statically defined
 within the script based on another snippet of code reading the new file that's being prepared for insertion into the db.)

Objective: if the six variables, from the new records, does not produce an exact match already within the db based on ($rcheck)
then insert the new record into the db. Note: I have the INSERT statement working correctly but having issues with the query ($rcheck).

As for the records being checked by ($rcheck) in the MySQL db: they are all UNIQUE records based on the six fields
I'm trying to build the query around to ensure no DUPLICATE entries are made with new insertions.
-------------------

Issue: I can't get the query ($rcheck) to fire correctly to check the queued (new records' data) against the db - based on six fields of data.
Error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.

FYI: if I just do a standard "SELECT * FROM information"; the quey works as it should but I need to check the db based on the six fields as shown in below code:



$rcheck = "SELECT docno,fdate,ftime,vegregno,direction,grossmass FROM information where docno = $docnoNew 
AND fdate = $fdateNew AND ftime = $ftimeNew AND vegregno = $vegregnoNew AND direction = $directionNew 
AND grossmass = $grossmassNew;";

$duplicate = mysql_query(rcheck);    // Execute query to check for duplicate transaction in table

        while ($row = mysql_fetch_array($duplicate)) {

            echo $row['docno']."<br/>";
            echo $row['fdate']."<br/>";
            echo $row['ftime']."<br/>";
            echo $row['vegregno']."<br/>";
            echo $row['direction']."<br/>";
            echo $row['grossmass']."<br/>";
}



I know the problem rests with trying to use multiple "AND" clauses but I'm not sure how to get around this issue.
Any advice on how to define this query to check based on all six fields surely appreciated to get ($rcheck) working!

thanks

What the hell am i missing here??

Trying to set the $output so if there are any errors it will display a message.
If no email or password is entered the $output is echoed fine

But if the wrong email or password is entered the $ouptut is not echoed at all???

if (loggedin()){
header ("Location: index.php");
exit();
}
if (isset ($_POST['login']))
{
$email= $_POST['email'];
$password= $_POST['password'];
if (isset ($_POST['rememberme'])) {$rememberme= $_POST['rememberme'];}
if (isset($rememberme)) {$rememberme= "on";} else {$rememberme= "off";}
if (empty($email)) {$output= "<span class='error'>Please enter a username or password</span>";}
if (empty($password)) {$output= "<span class='error'>Please enter a username or password</span>";}
if ($email&&$password)
{
$login= mysql_query ("SELECT * FROM user WHERE email='$email'");
while ($row= mysql_fetch_assoc($login))
{
$passwordcheck = $row['password'];
if (md5($password)==$passwordcheck)
$loginok = true;
else 
$loginok = false;

if ($loginok==true)
{
$uniquelogon = "{$row['uniqlogon1']}";
if ($rememberme=="on"){
setcookie("uniquelogon", $uniquelogon, time()+2628000);}
else
if ($rememberme=="off"){
session_start();
$_SESSION['uniquelogon'] = "$uniquelogon";}
header ("Location: index.php");
exit();
}
else
echo "<span class='error'>Your Email or Password do not match our records</span>";
}
}
}

<?php if (!empty($output)) {echo $output;} ?>
<form action"login.php" method="POST">
<p>Email:<br>
<input type="text" name="email">
</p>
<p>Password:<br>
<input id="pwd" type="password" class="required lock pad" watermark="{html:'Password',cls:'pad empty'}" name="password">
</p>
<p>
<input type="checkbox" name="rememberme">
Remember Me!<br>
</p>
<input type="submit" name="login" value="Log In">
</form>


Ive used all my special powers trying to get this to work, but i am missing something...

Hi all,

In my server at present php4 is running. upto now it is working fine.Suddenly it is showing lot of errors like
Use of undefined constant or Undefined variable:.

While trying in Google and all i came to know that the variable should be initialized and bounded by quotes.I checked in 1 file and it worked fine.

But my coding is 99% completed and to change in every file is not an easy thing.Can anybody help regarding this Please?

Here i'm having 1 more problem also which suffering me for a long time. I'm having one login form in this.That user session is working properly in Chrome but not in Mozilla.Even in Chrome once i try to logoff and relogin again it is behaving like in Mozilla.

anybody please help me regarding these 2 issues.Thanks in advance.

im getting these errors Notice: Use of undefined constant QUERY_STRING - assumed 'QUERY_STRING' in C:\xampps\htdocs\skyline\admin\other.php on line 36  and  
Notice: Undefined variable: update in C:\xampps\htdocs\skyline\admin\other.php on line 67

 

<?php
    $hostname = "localhost";
    $dbname = "pricelist";
    $username = "root";
        $password = "";
    
        $conn = new MySQLi($hostname, $username, $password, $dbname) or die('Can not connect to database')        
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<otype></otype>
</head>
<body>
<?php
    if(isset($_POST['Submit'])){
    
    
    $oname = $_POST['updateoname'];
    
    $otype = $_POST['updateotype'];
    
    $ocost = $_POST['updateocost'];
    
    $onotes = $_POST['updateonotes'];
        
    $update = "UPDATE other SET oname='$oname', otype='$otype', ocost='$ocost', onotes='$onotes' WHERE id = ".$id;
    $conn->query($update) or die("Cannot update");
    }
?>
<?php

$sql = "SELECT * FROM other ";
$result = $conn->query($sql) or die(mysql_error());
$query=getenv(QUERY_STRING);
parse_str($query);
?>
<h2>Update Record </h2>
<form action="" method="post">
<?php
    
    
    while ($row = $result->fetch_assoc()) {?>
    
<table border="0" cellspacing="10">
<tr>
<td>otype:</td> <td><input type="text" name="updateotype" value="<?php echo $row['otype']; ?>"></td>
</tr>
<tr>
<td>ocost:</td> <td><input type="text" name="updateocost" value="<?php echo $row['ocost']; ?>"></td>
</tr>
<tr>
<td>name:</td> <td><input type="text" name="updateoname" value="<?php echo $row['oname']; ?>"></td>
</tr>
<tr>
<td>onotes URL:</td> <td><input type="text" name="updateonotes" size="100" value="<?php echo $row['onotes']; ?>"></td>
</tr>
<tr>
<td><INPUT TYPE="Submit" VALUE="Update the Record" NAME="Submit"></td>
</tr>
</table>
<?php    }
    ?>
</form>
<?php
    if($update){
    
    echo "<b>Update successful!</b>";
    
    
        
}  
?>
</body>
</html>

Hi, I would like to generate a constant value that change from a website to website but have an identical value for a single website. For example 

$_SERVER['SERVER_ADDR']

doesn't change for a single website, but easy to guess. an other idea is 

realpath(dirname(__FILE__))

but this can change if the web application execute scripts located in sub directories of the main script that use this variable. So what other possibilities to get a constant value that doesn't change ?   Thank you.

How do you establish a tax rate in a MySQL database to use in a form calculation, then be able to change the value to a new constant value from the form?