PHP - Specifying Default Values For Bitmask Constants

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

Often in the very beginning of index.php, I will define a bunch of constants.  To make sure I can quickly identify them as being one of my defined constants, I will often include some sort of prefix.

define ('xzy_somecontant',123);
define ('xzy_anothercontant',321);

Sometimes I have a bunch of constants that are related;

define ('xzy_id_for_page1',123);
define ('xzy_id_for_page2',231);
define ('xzy_id_for_page3',312);

It would be nice to somehow group them into say "xzy_page_ids", and then access them by some index such as "page1" or "1" (or whatever makes sense for the given naming structure).   Is this possible?  Is there another defacto way of doing so such as a static class or something?   Thanks

Some questions about PHP Constants...

1.) What make a Constant "come to life"?

2.) What is the life of a Constant?

3.) Can you define a Constant in "file_1.php" and use the Constant in "file_2.php" and "file_3.php"??


Debbie

Hi,

I have a small CMS I coded and developped on my local WAMP server and everything worked fine but when I decided to export everything to my hostgator server I realized that the constants I define in some of my includes are not being defined..

Here is one of the errors I get :
Code: [Select]
Fatal error: require_once() [function.require]: Failed opening required 'LIB_PATHDSdatabase.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nethox/public_html/photo_gallery/includes/photograph.php on line 2
You can see that LIB_PATH is not defined and even the .DS. is not working..

Here is a sample of the code I made :

Code: [Select]
<?php
// Defining core paths
// Defining them as absolute paths to make sure that require_once works as expected

// DIRECTORY_SEPARATOR is a PHP pre-defined constant
// (will do \ for Windows, / for Unix) 
defined('DS') ? null : define('DS', '/');

defined('SITE_ROOT') ? null : define('SITE_ROOT', 'http://www.lemontree-designs.com'.DS.'photo_gallery');

defined('LIB_PATH') ? null : define('LIB_PATH', SITE_ROOT.'/includes');

defined('LOG_PATH') ? null : define('LOG_PATH', SITE_ROOT.DS.'logs');

defined('PUBLIC_AREA') ? null : define('PUBLIC_AREA', 'http://www.lemontree-designs.com'.DS.'photo_gallery'.DS.'public');

// Load config file first
require_once(LIB_PATH."/config.php");

// Load basic functions next so that everything after can use them
require_once(LIB_PATH.DS."functions.php");

// Load core objects
require_once(LIB_PATH.DS."session.php");
require_once(LIB_PATH.DS."database.php");
require_once(LIB_PATH.DS."pagination.php");
// Load database-related classes
require_once(LIB_PATH.DS."user.php");
require_once(LIB_PATH.DS."photograph.php");
require_once(LIB_PATH.DS."comment.php");

?>
Any help is appreciated!

EDIT : For the sake of debugging, I've changed the defined value of DS to '/' instead of DIRECTORY_SEPARATOR to see if it's what caused an issue..

Code: [Select]
<?php

class constantTest {

const HELLOWORLD = 'maybe not';

function __construct()
{
echo HELLOWORLD; // Output: HELLOWORLD
echo constant('HELLOWORLD'); // Output: Warning: constant() [function.constant]: Couldn't find constant HELLOWORLD
echo  self::HELLOWORLD . "\n"; // Output: maybe not
}
}

$bob = new constantTest();

I have read through the manual but as far as I can see all three methods should output the constant rather than just the last one.
Question: Why?

This is probs. an easy one but I have in my database some values, these values are defined constants in my php code. How do I display the value of the constant not the text (constant name)?

Hey guys

Anyone know the correct syntax to put a constant inside a header? this is driving me crazy
with RPATH being my constant

header("Location: ".RPATH."admin/monitor.php");

Can you echo class constants?
This does not work for me.

echo “here is a class constant: self::CLASS_CONSTANT”; // using double quotes

Instead I *must* concatenate it:

echo ‘here is a class constant: ‘ . self::CLASS_CONSTANT;

But of course I do not have to do this with a normal variable, which will echo a variable fine:

echo “my name is $name_variable”;

Am I doing something wrong or is this normal behavior?
Edited by E_Leeder, 30 October 2014 - 11:04 AM.

I am following a book and need help setting up Path Constants.

Here is the script I need to adjust...

// Constants
define('BASE_URI', '/path/to/Web/parent/folder/');
define('BASE_URL', 'www.example.com');
define('MYSQL', '/path/to/mysql.inc.php');

Since I am working in NetBeans, I do not have access above my Project Folder which serves as my "Web Root".

So if my Project Folder is called "MyProjectFolder", and I want both BASE_URI and BASE_URL to point to that directory on my laptop, what should I put?

I'm thinking something like this...

// Constants
define('BASE_URI', '/');
define('BASE_URL', '/');
define('MYSQL', '/includes/mysql.inc.php');




TomTees

I have defined my database connection data as constants in a separate file for security reasons.  How can I simply access the data stored in those constants.  I have to call the file to get the value of the constants.  If I inadvertently call the file twice in a script  using an include or require statement, I get an error that I am trying to define the constants again.  Can I somehow just call the constants without including the file where they are defined?

--Kenoli

What is the best practice for using site-wide constants in a class?

E.g. COMPANY_NAME is set in a config file and used on many pages. How would it be best to use this in a class. I'm guessing just calling COMPANY_NAME anywhere in the class would not be considered best practice.

Thanks.

Well hello there, I want to create a script that writes a few PHP constants to a file called config.php. It does not work however, with the way I wrote it as below:

Code: [Select]
$configdata = "<?php
//Configuration File

\define("DBHOST", $dbhost);             //DB Hostname
\define("DBUSER", $dbuser);             //DB Username
\define("DBPASS", $dbpass);             //DB Password
\define("DBNAME", $dbname);             //Your database name
\define("DOMAIN", $domain);             //Your domain name (No http, www or . )
\define("SCRIPTPATH", $scriptpath);     //The folder you installed this script in
\define("PREFIX", $prefix);
?>";

$file = fopen('../inc/config.php', 'w');
fwrite($file, $configdata);
fclose($file);

I am getting this error 'syntax error, unexpected T_STRING in ...', and I have no idea how to fix it. Strangely the below codes using PHP variables work flawlessly:

Code: [Select]
$configdata = "<?php
//Configuration File

\$dbhost = '{$dbhost}';       //DB Hostname
\$dbuser = '{$dbuser}'; //DB User
\$dbpass = '{$dbpass}'; //DB Password
\$dbname = '{$dbname}';     //Your database name
\$domain = '{$domain}';     //Your domain name (No http, www or . )
\$scriptpath = '{$scriptpath}'; //The folder you installed this script in
\$prefix = '{$prefix}';    

?>";

//Write the config.php file...

$file = fopen('../inc/config.php', 'w');
fwrite($file, $configdata);
fclose($file);


This confuses me, all I did was to change the string to output from a list of variables to a list of constants, and it gives weird errors that I have absolutely no idea how to fix. Can anyone please lemme know what I did wrong? Thanks.

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id                 order_no               order_date                  miles
310                001                   02-15-2020                MI,108.53
                                                                                     Oh,194.57
                                                                                     PA,182.22
                                                                                     WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id                  order_no              order_date              state      miles

310                001                   02-15-2020               MI          108.53

310                001                   02-15-2020              Oh          194.57

310                001                   02-15-2020              PA          182.22

310                001                   02-15-2020             WA          238.57
 

------------------my php code -----------

 

<?php
//invoice.php  
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else 
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

 

 <?php
                   $order_no=$_GET['order_no'];
        $sql = "SELECT * from tis_invoice where order_no = :order_no";
        $query = $dbh -> prepare($sql);
        $query->execute(
  array(
   ':order_no'       =>  $_GET["order_no"]
  )
 );
        $result = $query->fetchAll();
        foreach($result as $row)
?>
    
                    <form method="post">
                        <table align="center" style="width: 55%">
                        <tr><td>Invoice Number</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                        <tr><td>Invoice Date</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                        <tr><td>
                               <textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
                           </td></tr>
                           <tr><td>
                         
                            <input type="submit" name="add" class="btn btn-primary" value="Add" />
                       </td></tr></table>
                    </form>

-- Can any one help how to correct my code..present nothing inserted on table

 

Thank You

Edited February 8, 2020 by karthicbabu

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)