PHP - Oophp Construct Instead Of Setter Method

hi, cane somebody please explain how to use the declare contruct of PHP 
some code snippets may help..thanks in advance

Hi Chaps,

I have a while loop which produces a couple of variables:
do {
$L_NAME.$i = 'Item 1';
$L_NUMBER.$i = '0001';
$L_QTY.$i = '1';
$L_AMT.$i = 10.50;
$NVP.$i = "L_NAME.$i.= .$L_NAME.$i.&L_NUMBER.$i. = .$L_NUMBER.$i.&amp";
} while($i == $items);
Basically what I need to do is contruct a parameter made up of all the $NVP variables.

I've a feeling that I would need to add each variable to an array and then use a foreach statement, but I'm not 100% sure.

I'd be interested in the correct way to go about this, any comments welcome!

Hey All,

I'm tryin to make a log-in system for multiple usernames and passwords, but I don't really know how many if statements i'd need for it.. I'm also a noob..


Code: [Select]
<?php

session_start();
$users = array("user1" =>"3202", "user2" =>"2002", "user3" =>"1061", "user4"=>"1400", "user5"=>"1001");

if($_REQUEST['username'] == "infs" && $_REQUEST['password'] == "3202"){

$_SESSION['username'] = "user1" ;
$_SESSION['password'] = "3202" ;

$_SESSION['username'] = "user2" ;
$_SESSION['password'] = "2002" ;

$_SESSION['username'] = "user5" ;
$_SESSION['password'] = "1001" ;

$_SESSION['username'] = "user3" ;
$_SESSION['password'] = "1061" ;

$_SESSION['username'] = "user4" ;
$_SESSION['password'] = "1400" ;
header("Location: home.php ");
}else{


 After checking if the matching username and password exist in my array then save them in a session...


What's the best way of doing it?

 

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

I am trying to insert the current Date/Time into mysql database using the following code.

I do not understand how $submitDate &  $submitTime are to be set.

Will this work as coded?

Code: [Select]

<?php
 
class SubmitDateRecord {

  const DB_TABLE = 'timesheet';
const DB_FIELD_SUBMIT_TIME = 'submit_time';

 
private $submitDate;
private $submitTime;

 
public function setSubmitDate($submitDate) {
    $this->submitDate = $submitDate;
}

public function getSubmitDate() {
    return $this->submitDate;
}

public function setSubmitTime($submitTime) {
    $this->submitTime = $submitTime;
}

public function getSubmitTime() {
    return $this->submitTime;
}

 

public function addRecord() {

    $insertTable = "`".self::DB_TABLE."`";
       
$insertFields[] = "`".self::DB_FIELD_SUBMIT_TIME."`";

$insertValues[] = "'{$this->submitDate} {$this->submitTime}'";
           

$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);

$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);

if ($result) {
    return true;
} else {
    return false;
}

}


private function _buildRecordObjects($result) {

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

$submitdateObj = new SubmitDateRecord();

$submitdateObj->setAttendanceId($row['attendance_id']);
$submitdateObj->setEmployeeId($row['employee_id']);

/* $row['submit_time'] comes in '0000-00-00 00:00:00' format.
 * We want date in '0000-00-00' format and time in '00:00' format.
 */
$tmpArr = explode(' ', $row['submit_time']);
$submitdateObj->setSubmitDate($tmpArr[0]);
$submitdateObj->setSubmitTime(substr($tmpArr[1], 0, 5)); // Omiting 'seconds' part is ok since it is always zero








$submitdateObj->setStatus($row['status']);



$submitdateArr[] = $submitdateObj;

}

return $submitdateArr;

}

}

Hi there,

I want to allow the ability for DJ's to turn on and off radio requests.

Now obviously I've encorporated a check box and submit button within a PHP login. But I was wanting to know if this can be done with PHP or is a database required as the option will need to be remembered for a period of time.

I'd probably look to do it by making it display on a page 'requests enabled' if enabled and a blank page if disabled. therefore I could encorporate:

<?php
if(!empty($requests))
{
//requests template
}
else  
{
//radio requests disabled template
}
?>

What's the best method for this?

Thanks

The following query code works correctly, however, I'm trying to figure out which is best when working with themes, templates, content pages. My themes are my different versions of the main site designs. As of right now I have the following code plus the database structure.

site_themes - id, theme_name, status_id (only one theme can have a value of 1(active) at any given time)

site_templates - id, template_name, header_code, footer_code, status_id (any can have a value of 1(active) at any given time,

Code: [Select]
<?php

require("kowmanager/config/database.php");

$site_variables_query = "SELECT * FROM site_variables WHERE id = '1'";
$site_variables_result = mysqli_query($dbc, $site_variables_query);

$row = mysqli_fetch_array($site_variables_result, MYSQLI_ASSOC);

$site_theme_query = "SELECT * FROM site_themes WHERE status_id = '1'";
$site_theme_result = mysqli_query($dbc, $site_theme_query);

$row2 = mysqli_fetch_array($site_theme_result, MYSQLI_ASSOC);

if ($row['site_is_down'] == 'Yes') {
    
} else {
    echo "site is up";
}

?>

Hi,

I have a problem and can't seem to figure out how to do it..

Basically i have these 2 tables:

Quote

People
Pid
Pname
Pdateadded
Pdeleted


And..

Quote

Quote:
PeopleCon
PCid
Pid
PCorder
Pdateadded
Pdeleted


Now, currently i insert the data into a table "People".. like you guys have helped me with..

But what i need to do is, first check to see if the author already exists in the People table, if so then just INSERT into PeopleCon, ELSE INSERT into both People and PeopleCon...

Also if there are 4 authors, and 2 exist in People, and 2 do not. What needs to happen is the first 2 are simply inserted into PeopleCon, but the last 2 are INSERTED into both People and PeopleCon. When the authors are inserted into PeopleCon, the PCorder row needs to increment by the number of authors byt order of author.

So this is the logic:

Multiple authors are entered in textboxes Fire the script Check to see if author already exists in "People" table IF it does exist, INSERT into PeopleCon table ELSE do the insert into the People AND PeopleCon table, first it will INSERT into the People, and GET the MAX (ID) and insert into the PeopleCon
So i currently have this, but as 3 separate methods:


class People {

    public function checkNameExists(){

       $query = "SELECT * FROM People WHERE Pname = '". mysql_real_escape_string($_POST['author'])."'";

        $result = mysql_query($query);
        if(mysql_num_rows($result) > 0):
            $row = mysql_fetch_array($result);
            return true;
        else:
            return false;
        endif;
    }

    public function insertAuthor(){
        $callback = create_function('$author','return "(\'".mysql_real_escape_string($author)."\',NOW(),0)";');
        $sql = sprintf(
            'INSERT INTO People (Pname, Pdateadded, Pdeleted) VALUES %s'
            ,implode(',',array_map($callback,$_POST['author']))
        );
        $result = mysql_query($sql);
        return "Successfully added NEW author";
    }

    public function insertAuthorCon(){

        $sql = "INSERT INTO PeopleCon
                    (Pid, PCorder, PCdateadded, PCdeleted) VALUES
                    (
                    'MAX ID WILL GO HERE',
                    'INCREMENT OF ORDER GOES HERE',
                    now(),
                    0
                    )";
        $result = mysql_query($sql);
        return "Successfully added existing author";
    } 


But obviously i need to combine these together into one method to match what i am trying to achieve..

Can anyone point me in the right direction?

Thanks again...

Hi all,
What is the maximum size of data that we can pass through GET Method?
And can we increase its size ?

here is what i am trying to do. i have a url in my browser like this: http://localhost/jmla/index.php?option=com_content&view=article&id=1295:sovereign-a-country-risk-workshop

as usuall we get elements form the url using the $_GET method, but here when i try to get id from the above url. i can get 1295:sovereign-a-country-risk-workshop. whereas the id is only 1295 and the other part is alias which i want to get seperately.

is there a way to do so?

I know I'm posting this inside the PHP coding board but I'm curious on how most handle this situation. I have a page that uses php to retrieve data from my database and I want to have it place a | in between each of the returned data which it does but it still places one after the last returned row. I'm wondering if I should do this with jquery load and then have it place that character in between each of the data or if there's a way to do it with php or what? Any ideas?

Code: [Select]
<?php require ("../header.php"); ?>

<div id="titlehistory" class="content">
 
<h1 class="pageheading">Title History</h1>

<?php 
$titlesQuery ="
SELECT 
    titles.titleName, 
    titles.shortName
FROM
    titles
WHERE
    titles.statusID = 1 
ORDER BY      
    titles.ID";
$titlesResult = mysqli_query($dbc,$titlesQuery);

?>
     
    <p><span class="minilinks">
   
        <?php
        while ( $row = mysqli_fetch_array ( $titlesResult, MYSQLI_ASSOC ) ) {
            $fieldarray=array('titleName','shortName');     
            foreach ($fieldarray as $fieldlabel) {         
                ${$fieldlabel} = $row[$fieldlabel];     
            }
             
            echo '<a href="/titlehistory/'.$shortName.'">'.$titleName.'</a>&nbsp; |';
        }
        ?>
    </span></p>
   
    <p class="nohistory">Please select a title to view.</p>

</div>

<?php require ("../footer.php"); ?>

Hi There,

I am trying to implement a facebook plugin into my website. When the user posts a link to my site on their wall it will redirect them back to my page with some GET info in the URL eg. www.example.com/download.php?post_id=43221. I don't need to know the Post Id number, I just need to know if they went to the facebook page. So my question is, how would I make it s that if there is a Post ID number it displays the page and if not it directs them to another page?

Please help me with this, i'm totally stumped.

Thanks

George Bates 

I have a restricted page for members of a website. This restricted area is within a directory called 'download.'

There is a login form on two pages (home and support pages, found in the main menu). These pages are on the site root directory. When the user successfully logs in they are taken inside the download directory to index.php.

This index.php has a different look to the site root design. I have since redesigned this page to have the same structure as the site root pages.

I would love for the user to able to navigate around the main site if they wanted, and when they clicked support in the menu they would have all the download files there on the page, instead of a login form.

My question is how would I implement this login so that when the user logs in the support page changes from the login page to the page with the files.

I don't want to to duplicate the site within the download directory, I was hoping for an efficient method, but I am unsure how to go about it. 

I have an error that I seem to find curious. Let me explain what I have. I have a Database class that has a function (the culprit) that is called fetchAll. It is suppose to call the mysqli method mysqli_result::fetch_all(). This method does exist, I have looked it up: The PHP Manual, however do note the last comment on the page, it describes my problem, but does not explain how I can fix it. Now, here is my error:

Quote

Fatal error: Call to undefined method mysqli_result::fetch_all() in /var/www/core/includes/Database.php on line 36


Here is line 36:
$row = $this->result->fetch_all($mode);

Here is the entire function, or is it called a method since it is in a class?

function fetchAll($mode = 'MYSQLI_ASSOC'){

$row = $this->result->fetch_all($mode);

return !empty($row) ? $row : array();//if not empty return row, else return an array?

}


I could post the entire class, but I think it might be irrelevant so I will spear you guys.

Do you guys think you might be able to help me out?

Thanks!

I have a massive form (300+ fields) submitting post data that I wish to write to an xml.  The hierarchy will vary from node to node ie:

Code: [Select]
<E02>
  <E02_02>value</E02_02>
  <E02_03>value</E02_03>
  <E02_04_0>
    <E02_04>value</E02_04>
    <E02_05>value</E02_05>
  </E02_04_0>
</E02>
I'm not sure how necessary that example was, but anyways...  The nodes and the data in them will be different all of the time, I plan to deal with the structural differences with a really big switch/case.  So my questions a

1) Whats is the advantage of using something like simplexml to write the xml, as apposed to just writing it out in a string, and saving it as a .xml file?

2) If I shouldn't write it out as a string, what method would you guys suggest, keep in mind there will be a lot of values to store, in many different parent elements (xml->emdata->header->record->E02->E02_04_0->E02-02)