Jump to content

wildteen88

Staff Alumni
 View Profile  See their activity

  • Posts

    10,480

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by wildteen88

    HELP with 9 lines of code

    in PHP Coding Help

    Posted

    Is this your code for logging in a user?

    <?php
include("connect.php");

$query = "SELECT * FROM user ";
$result = mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$user_login_username = mysql_result($result,$i,"user_login_username");
$user_login_password = mysql_result($result,$i,"user_login_password");
$id = mysql_result($result,$i,"id");

++$i; } } else { echo "The database is empty"; }?>

    If it is that is not the correct way to go about logging in users.

     

    You should instead be performing a query like

    SELECT username, password FROM users_table WHERE username='$username_entered' AND password='$password_entered'

    You should then check to see if the query returned a match (mysql_num_rows). If it returned a match log the user in. If no match was returned the user entered invalid login credentials.

     

    Help with checkbox's with 2d array

    in PHP Coding Help

    Posted

    The <optgroup> tag is to be used within a <select> list only, eg

    <select>
  <optgroup label="Swedish Cars">
    <option value="volvo">Volvo</option>
    <option value="saab">Saab</option>
  </optgroup>
  <optgroup label="German Cars">
    <option value="mercedes">Mercedes</option>
    <option value="audi">Audi</option>
  </optgroup>
</select>

     

    You probably want to use a div or fieldset/legend tags maybe?

     

    Apache not loading the dll's

    in PHP Installation and Configuration

    Posted

    The extensions php_mysql.dll and php_mysqli.dll require an external library called libmysql.dll in order to load properly. This file should be in C:/PHP can you confirm that file is present? If that file does not exist then I guess you used the PHP installer

     

    If you did use the installer go to php.net and download the zipped binaries version of PHP 5.2.17 and extract the contents of this zip to C:/PHP overwriting any existing files. The installer never installs all the required files for extensions to load properly. The zip file contains all required external libraries for most of the extensions.

     

    After unzipping restart the Apache service.

    Altering data in mysql db table with form

    in PHP Coding Help

    Posted

    First in your second page where you display the data to be edited you are only showing one field to be edited, which is the Property_Rating.

    <td align="center"> </td>
<td align="center"><strong>Property_Name</strong></td>
<td align="center"><strong>roperty_Rating</strong></td>
<td align="center"><strong>Property_Address</strong></td>
</tr>
<tr>
<td> </td>
<td align="center"><input name="Property_Rating" type="text" id="Property_Rating" value="<? echo $rows['Property_Rating']; ?>"></td> <-- the only editable field you have

</tr>

    You do not have a field for Property_Name or Property_Address. However in the page you update the data in the database you are trying to update the Propety_Name field! You should add in the missing form fields.

     

    In your update page the variables $Property_Name and $id are undefined. Before updating your database you should first get the data from your form. That data is stored within the $_POST superglobal. Example

    $id = $_POST['id'];
$Property_Name  = $_POST['Property_Name'];
$Property_Address = $_POST['Property_Address'];

    Quick Function Edit

    in PHP Coding Help

    Posted

    Not sure what you mean but change

    function fetch_user_info_by_id()
{
global $user_info;

    to

    function fetch_user_info_by_id($id = null)
{
global $user_info;

if(is_null($id))
	$id = $user_info['uid'];

     

    Next change

    			WHERE `users`.`id` = '${user_info['uid']}'";

    to

    			WHERE `users`.`id` = '$id'";

    php require_once not working

    in PHP Coding Help

    Posted

    In order to run PHP code on your computer you need to install a http server (IIS or Apache) which is configured with PHP. Simply just loading test.php directly into your web browser will not work.

     

    If you have installed a Server that is configured with PHP then make sure you are saving the php files in your servers root folder and going to http://localhost/test.php to run it.

     

     

    Stuck on somthing simple

    in PHP Coding Help

    Posted

    Your using preg_match incorrectly here

    o in the "case" section I added this

     

    case preg_match("/{SUBGAME[1-9]?}/",$html_file):

    preg_match will return 1 if it found a match and 0 if it didn't.

     

    The third parameter for preg_match will return any array of matches. Syntax for preg_match: preg_match(pattern, subject, $matches)

     

    NOTE: preg_match will return one match from the pattern. If you have multiple {subgameX}'s you need to use preg_match_all.

    Looking for a better way to remember & display drop down box data

    in PHP Coding Help

    Posted

    What you'll want to do is store your countries in an array

    $countries = array('Afganistan', 'Albania', 'Algeria', 'American Samoa', 'Andorra', 'Angola',  etc..);

     

    Then use a loop to output each country into an <option></option>. Within this loop you'll have an if statement which selects the chosen country.

    <select name="country">
<?php
$selectedCountry = isset($_POST['country']) ? $_POST['country'] : $row['country']; // get the chosen country
foreach($countries as $country):
    $selected = ($selectedCountry == $country) ? ' selected="selected"' : null; // if the current country equals the chosen country then select it.
?>
<option value="<?php echo $country; ?>"<?php echo $selected; ?>><?php echo $country; ?></option>
<?php endforeach; ?>
</select>

    Stuck on somthing simple

    in PHP Coding Help

    Posted

    You're right in thinking preg_match is what you need. You can use the following regex to match anything within { and }

    ~{[a-z0-9_\- ]+}~

    Example code

    $field = 'my Game';

$text = "{subgame1}

{subgame}

{{$field}}

{subgame12}";

echo $text;

preg_match_all('~{[a-z0-9_ -]+}~i', $text, $matches);
echo '<pre>' . print_r($matches, true) . '</pre>';

     

    You can then use a foreach loop to run your code for each match

    foreach($matches[0] as $gameMatch)
{
      // run code here
}

    Arrays and Formatting

    in PHP Coding Help

    Posted

    Try

    <?php


class Game
{
    public $draw = array(10,25,36,3,12,13);

    public $numbers = array();

    public $age;
    public $count;
    public $draws = array();

    function __construct($sub1, $sub2)
    {
        $this->name = $sub1;
        $this->age = $sub2;

        $this->numbers = range(1, 49);

        return $this->name;age;

    }

    function checkAge()
    {
        if ($this->age <18)
        {
            return "Sorry $this->name, you are too young to gamble";
        }
        else
        {
            return "Hi $this->name welcome to Lucky Lotto Dip, how many draws would you like?";
        }
    }

    function genDrawLines($lines)
    {
        // loop for as many draws required
        for($i = 0; $i < $lines; $i++)
        {
            $this->draws[$i] = array();
            $nKeys = array_rand($this->numbers, 6); // pick random numbers
            foreach($nKeys as $key)
                $this->draws[$i][] .= $this->numbers[$key]; // add numbers to draw
        }
    }


    function display($sub3)
    {
        // generate the numbers for each draw
        $this->genDrawLines($sub3);

        echo "<pre>";
        echo "*********************";
        echo "<br />";
        echo "*    Lucky Lotto    *";
        echo "<br />";
        echo "*********************";

        // loop through the draws
        foreach($this->draws as $key => $drawNumbers)
        {
            $matches = 0;
            echo "<br />";
            echo "* ";

            for ($j =0; $j <6; $j++)
            {
                if ($drawNumbers[$j] < 10)
                    echo " " . $drawNumbers[$j] . " ";

                else
                    echo $drawNumbers[$j] . " ";

                // increment matches when the number within the current draw exists within the draw array
                if (in_array($drawNumbers[$j], $this->draw))
                    $matches++;
            }

            echo "* ";
            echo "<br />";

            echo "*********************";
            echo "<br />";
            echo "\t\t$matches matches"; // display matchers

            echo "<br />";
            echo "*********************";
        }
    }
}

$object2 = new Game("Chris", 36);
echo $object2->checkAge();
echo $object2->display(4);

?>

    Query suddenly not returning all results

    in PHP Coding Help

    Posted

    What version are you using on localhost? If its before 5.0.3 MySQL didn't actually support bit datatypes, instead BIT(1) datatype was an alias of TINYINT(1). This is why on your localhost it is displaying 1 or 0. However on your godaddy server you must be using a newer version of MySQL which has support for Bits. I found this out by reading this artical.

     

    Maybe change the data type for the volunteer, staff, admin and active columns to TINTINT(1) rather than BIT(1).

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.