PHP - Calculating True And False Positives And Negatives

MySQL cannot store Boolean values and thus I use 0/1.  Is there much benefit to cast them as Boolean immediately after querying the database, do whatever PHP processing is required, and then convert them back to 0/1 before writing to the database?  One benefit is I can type declare my arguments, but I am debating whether it is worth it.  Thanks

Hey Everyone, I want to start out by saying thanks in advance for reading this. Since I started working with the XAMPP package this community has been a great resource, though this is my first post.  most of my work has been modifying existing stuff in our network, this is my first project from scratch.

I am working on an access control project where I am storing site names and RFID tags in a table, and using PHP to check for existing records. Basically, I want to submit 2 credentials from a host (site and RFID), check if they exist together in the table, if so return TRUE or 1, if not return FALSE or 0. I am new to both PHP and MySQL (although I took a course years ago) so I am looking here for help.

On this server I have XAMPP installed and everything I need running. I have a table and created a few records for testing. My current trouble is getting PHP to return the proper values for the SQL query. The SQL query works fine, I think - it returns the number of rows that match and that record.  I'm not sure this is the result I need to be able to deal with the way I want.  Using other resources my current PHP statement looks like this:
Code: [Select]
if(mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE 'site_name' LIKE 'berland' AND 'card_id' LIKE '290093C84E' LIMIT 0 , 30"))>0){echo '1';}
   else
   {echo '0';} So, my table has the entry as noted in this query above. Final one will be dynamic where the host will be sending those values - I will likely need help with that as well, but small steps first.;-) Anyway, I was playing around with the end statement >0{echo '1';} but wasn't able to make it do what I want.
Any help is appreciated. Thank you.

Aaron

hi there,

is there a difference between if($var == false) and if(false == $var)

thankyou!

$looponce = 1;
foreach ($this->info as $k => $v) {
if ( (($k == 'subject') && ($v['required'])) && (!$this->settings['customSubject'])) {
for ($i = 0; $i <= 0; $i++) {
$output[] = $this->display_errors('error_system_subject');
}
}
if ( (($k == 'name') && (!$v['required'])) || ((!array_key_exists("name", $this->info)) && ($looponce == 1)) ) {
$output[] = $this->display_errors('error_system_name');
$looponce++;
}
}

That is my loop that i check things in. What i'm more interested in is the name if statement.

If currently checks for a name key in an array(below) and makes sure that it is set to required. If it's not set to required, print out a system error and die()'s.

I'm looking for ways to remove the need for program errors and just change them to what is needed to run.

What i know how to do is, get into the inner array, what i don't know is how to edit the data and put it back exactly as it was given to me. The inner array data can be put back in any order, but the outer array must be in exact order as it was given.


above code $this->info = $formdata;

$formdata = array(
'name' => array('name'=>"Full Name", 'required'=>false, 'type'=>'text'), # This needs to be required=>true, but i can't trust the user, which is why i have the error.
'telephone' => array('name'=>"Telephone", 'required'=>false, 'type'=>'phone'),
);


Any help is greatly appreciated, also am i doing the foreach loop in the code above in an efficient manner or is there another way?

Apart from the fact this can cause an infinite loop is it OK to use?

$user->reset_token = $user->generate_password(32);

// Make sure the token is unique
while(TRUE)
{
$count = ORM::factory('manager')->where('reset_token', '=', $user->reset_token)->count_all();
if($count < 1) break;

$user->reset_token = $user->generate_password(32);
}

Or would you approach the logic for this differently?

Thoughts appreciated. Cheers

I am wondering if these "true" values are the same to PHP...
Code: [Select]
<a href="' . BASE_URL . 'members/log_in.php?addComment=true">Log In</a>


Code: [Select]
if (isset($_GET['addComment']) && ($_GET['addComment']==TRUE)){


Debbie

Is there any reason why I would want to use this...

Code: [Select]
$_SESSION['loggedIn'] = TRUE;
versus this...

Code: [Select]
$_SESSION['loggedIn'] = 1;
(The first one is easier to read...)


Debbie

<?php
$id1 = '5' ;
$id = array(1,2,3,4,5,6,7);

    foreach($id as $value){
if($id1==$value){
    echo 'One of them matches, ' ;
    echo 'Do not execute command <BR>' ;
} ////// if ends here
} ////// loop ends here

?>   How to do something if all statements are false ? like when id $id1 = '10' , ?

hi i have set 2 varibles, and want to echo them out if they are true,  i have this script but doesnt work, please help.
<?php
$month=$_GET['month'];
$year=$_GET['year'];

If($year!=0 && $month!=0)
{
echo $month;
echo $year;

}
?>

cheers matt

I have a timestamp field in my mySQL table and need to check if it's 14 day or older.  What's the best way to do this?

Any help will be appreciated

Hi everyone,
I'm trying to add up the current time with a specified amount of seconds and insert it in a database afterwards.
When I add say: 500 seconds to the current time it adds a whole lot more and I get a number few thousands higher than I want. Can anyone help me???.
Gr Ryflex

Not asking someone to do this for me. Just looking for someone to help me get going, and show me how to do this.


Need helping calculating text boxes on a form. I want my form to display the premium of $10,000 health insurance. What I mean by this is that I have a form that involves filling out life insurance information.

This is the table I'm basing this off of...

                                                      Age <=30
#health conditions <=2                   $0.90
2 <= #health conditions <=5           $1.20



The number of health conditions is equivalent to the number of check boxes that were checked. Additionally,
the following conditions apply:

- Men are charged a 5% gender risk
- Students receive an 8% discount

For example, if you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm new to php and haven't really calculated forms before...


here is my form codes....



Code: [Select]
<!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>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>

I have a form that I will post the code for. In my form I have a few things that need to be filled out.... Age, Gender, Coverage Amount, and Health Conditions.

The Health Conditions are 5 check boxes the user can select.

Now what I'm trying to do is make it so that when the user hits submit the Age and number of Health Conditions checked off will do this...

if # of Health Conditions <=2 and Age is <= 30 then = $0.90

if # of Health Conditions =>2 but <=5 and Age is <= 30 then = $1.20

Then after those are calculated I need these to apply to the code...


- Men are charged a 5% gender risk
- Students receive an 8% discount


Here is a example of what I'm trying to get this to do...

If you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm doing a life insurance form and these are some of the calculations that need to go into it. I'm not sure how I would code these. If someone could help me get started that would be great.



Here is my form code and the display page.


Code: [Select]
<!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>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>



Display Page




Code: [Select]
<!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>

        <title>Lab4</title>

       

    </head>

    <body>

    <div id="page">

        <div id="main">






        <div id="content">

           

            <h2>Life Insurance</h2>

            <table>

                <tr>

                    <th>Coverage Amount</th>

                    <th>Name</th>

                    <th>Gender</th>

<th>Age</th>

<th>Health Conditions</th>

<th>Employment Status</th>

<th>Comments</th>



                </tr>

<?php

$coverage_amount = $_POST['coverage_amount'];
$age = $_POST['age'];
$health = $_POST['health'];


if $age = 



?>










                                <tr>



                    <td><?php echo $_POST['coverage_amount'];?></td>

                    <td><?php echo $_POST['first_name'];?></td>

                    <td><?php echo $_POST['gender'];?></td>

<td><?php echo $age?></td>

<td class="right"><?php echo $_POST['health'];?></td>

<td class="right"><?php echo $_POST['employment'];?></td>

<td><?php echo $_POST['comments'];?></td>



                </tr>

                 

                            </table>

        </div>

        </div>

        <div id="footer"></div>

    </div>

    </body>

</html>

Hey here is my code im trying to redirect  the index.php to index.php?id=1
the way i have done it doesn't look really good is there a better way to do it please?

im trying to redirect to id=1 because otherwise i wont be able to echo out anything...

id 1 is default category so is there a way to tell it if  $id is empty echo from id 1?

<?php   

        $id = $_GET['id']; 
if($id == ''){
echo "<meta http-equiv=Refresh content=0;url=index.php?id=1>";

}
        $result = mysql_query("SELECT * FROM pages WHERE id='$id' ",$connect);
        while($row = mysql_fetch_assoc($result))
             {
        echo $row['anything1']; 
        echo $row['anything2']; 
} 
?>