PHP - Small Class Help

Hi,

I need to be able to call a class based on variables.  E.G.

I would normally do:
Code: [Select]
$action = new pattern1()
but i would like to be able to do it dynamicaly:
Code: [Select]
$patNum = 1;
$action = new pattern.$patNum.()
Im wondering if that's possible?  If so what would the correct syntax be?

Many Thanks.

Hi people!

class FirstOne{

public function FunctionOne($FirstInput){
//do stuff and output value
return $value1;
}

}


Then:-


class SecondOne{

public function FunctionTwo($AnotherInput){
//do stuff and output value
return $value2;
}

}


What I want to know is this, if I want to use FunctionOne() in Class SecondOne do I do it like this:-

(Assume as I have instantiated the first class using $Test = new FirstOne(); )


class SecondOne{

function SecondedFunction(){
global $Test;
return $Test->FunctionOne();
}

public function FunctionTwo($AnotherInput){
//do stuff and output value
return $value2;
}

public function FunctionThree(){

//some code here
$this->Test->SecondedFunction();<--I think as I can omit the $this-> reference
}
}


My point is: Do I have to do it this way or is there way of having this done through __construct() that would negate the need for a third party function?

I have a version working, I just think that it is a little convoluted in the way as I have done it, so I thought I would ask you guys.

Any help/advice is appreciated.

Cheers
Rw

I have two classes:

## Admin.php

<?php
class Admin
{
public function __construct()
{
include("Config.php");
}

/**
* deletes a client
* @returns true or false
*/
function deleteClient($id)
{
return mysql_query("DELETE FROM usernames WHERE id = '$id'");
}
}
?>


## Projects.php

<?php
class Projects
{
public function __construct()
{
include("Config.php");
$this->admin = $admin;
$this->dataFolder = $dataFolder;
}

/**
* Deletes a project
* @returns true or false
*/
function deleteProject($id)
{
$root  = $_SERVER['DOCUMENT_ROOT'];
$theDir  = $root . $this->dataFolder;
$sql  = mysql_query("SELECT * FROM projectData WHERE proj_id = '$id'");
while ($row = mysql_fetch_array($sql))
{
$mainFile = $row['path'];
$thumb = $row['thumbnail'];
if ($thumb != 'null')
{
unlink($theDir . "/" . substr($thumb,13));
}
unlink($theDir . "/" . substr($mainFile,13));
}
$delete = mysql_query("DELETE FROM projectData WHERE proj_id = '$id'");
$getDir = mysql_query("SELECT proj_path FROM projects WHERE id = '$id'");
$res = mysql_fetch_array($getDir);
rmdir($theDir . "/" . $res['proj_path']);
return mysql_query("DELETE FROM projects WHERE id = '$id'");
}
}
?>


How can I call deleteProject() from within Admin.php?

How does one go about using one class inside another?

For example, building a class that does some series of functions, and uses a db abstraction layer class in the process?

I do know how to do this but I am curious about whether or not there is a "preferred" way to do this. I know there are a couple ways to use a class (I'll call Alpha_Class) within another class (I'll class Beta_Class)

Let's say we have this simple class (Beta_Class):

class beta {
    function foo(){
    
    }
}


If I wanted to use the Alpha Class within the Beta Class, I could any number of things. For example:

class beta {
    function foo(){
        $this->alpha = new alpha;
        //$this->alpha->bar();
    }
}


Or you could simply use the $GLOBALS array to store instantiated objects in:

$GLOBALS['alpha'] = new alpha;
class beta {
    function foo(){
        //GLOBALS['alpha']->bar();
    }
}


You could even declare Alpha_Class as a static class and thus would not need to be instantiated:

static class alpha {
    static function bar(){}
}

class beta {
    function foo(){
        //alpha::bar();
    }
}


Those are the only ways I can think of right now. Are there any other ways to accomplish this? I was wondering which way is the best in terms of readability and maintainability.

I have a class in which I have a function called connection. I am now trying to call this function from another class, but it will not work. It works if I put the code in from the other function rather than calling it but that defeats the purpous.

class locationbox

{
   function location()
   {
   
   
   $databaseconnect = new databaseconnect();
         $databaseconnect -> connection();{

$result = mysql_query("SELECT * FROM locations");

while($row = mysql_fetch_array($result)) // line that now gets the error, mysql_fetch_array() expects parameter 1 to be resource, boolean given //in
  {
  echo "<option>" . $row['location'] . "</option>";
    }
   
}
}}

Hi all,

I have two classes. Registration and Connection.

Inside a registration.php I include my header.php, which then includes my connection.php...

So all the classes should be declared when the page is loaded.

This is my code:


registration.php:

<?php include ('assets/header.php'); ?> 
        
    <?php
        class registration{                    
            public $fields = array("username", "email", "password");
            public $data = array();
            public $table = "users";
            public $dateTime = "";
            public $datePos = 0;
            public $dateEntryName = "date";
            
            function timeStamp(){
                return($this->dateTime = date("Y-m-d H:i:s"));
            }
            
            function insertRow($data, $table){      
                    
                    foreach($this->fields as $key => $value){
                        mysql_query("INSERT INTO graphs ($this->fields)
                        VALUES ('$data[$key]')");
                    }
                    
                    mysql_close($connection->connect);
            }
            
            function validateFields(){
            
                $connection = new connection(); 
                $connection->connect();
                        
                foreach($this->fields as $key => $value){
                    array_push($this->data, $_POST[$this->fields[$key]]);
                }
                $this->dateTime = $this->timeStamp();
                array_unshift($this->data, $this->dateTime);                
                array_unshift($this->fields, $this->dateEntryName);   
                
                foreach($this->data as $value){
                    echo "$value";
                }
                
                $this->insertRow($this->data, $this->table);
            }
        }
        
        $registration = new registration();
        $registration->validateFields();
    ?>

<?php include ('assets/footer.php'); ?>



At this point I cannot find my connection class defined on another included/included page.



                $connection = new connection(); 
                $connection->connect;





config.php (included within header.php)

<?
    class connection{ 
        public $dbname = '**';   
        public $dbHost = '**';
        public $dbUser = '**';
        public $dbPass = '**';
        public $connect;
        
        function connect(){
            $this->connect = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass) or die ('Error connecting to mysql');
            mysql_select_db($this->dbname, $this->connect);
        }
    }
?>



Any ideas how to call it properly?

I'm trying to find the write coding to pull the First and Second words from the 2nd line and the entire 3rd line from this file and have them as $subject1 and $subject2  And I have no php background.


http://www.weatherserver.net/text/CWTO/WOCN11.txt

so $subject1 = WOCN11 CWTO
and $subject2 = SPECIAL WEATHER STATEMENT

Hey guys i have a contact form for my site working fine but when i receive the emails i get some unwanted texts after the email section.
 here they r :

name1: ryan

number: 343244

message1: hey

email: ss@yahoo.com

clearField: [type Function]

label1: NAME

label2: E-MAIL

label3: PHONE

label5: MESSAGE

countField: 5

arrayLabel: undefined,NAME,E-MAIL,PHONE,undefined,MESSAGE

i: 6

txtField: _level0.topmenu.page.pages.contactform.txtField5

_request: contact/email.php

the script

Code: [Select]
<?php

/***************************************************\

 * PHP 4.1.0+ version of email script. For more

 * information on the mail() function for PHP, see

 * http://www.php.net/manual/en/function.mail.php

\***************************************************/





// First, set up some variables to serve you in

// getting an email.  This includes the email this is

// sent to (yours) and what the subject of this email

// should be.  It's a good idea to choose your own

// subject instead of allowing the user to.  This will

// help prevent spam filters from snatching this email

// out from under your nose when something unusual is put.



$sendTo = "hey@email.com";

$subject = "helloy";



// variables are sent to this PHP page through

// the POST method.  $_POST is a global associative array

// of variables passed through this method.  From that, we

// can get the values sent to this page from Flash and

// assign them to appropriate variables which can be used

// in the PHP mail() function.





// header information not including sendTo and Subject

// these all go in one variable.  First, include From:

$headers = "From: " . $_POST["firstName"] ." ". $_POST["lastname"] . "<" . $_POST["email"] .">\r\n";

// next include a replyto

$headers .= "Reply-To: " . $_POST["email"] . "\r\n";

// often email servers won't allow emails to be sent to

// domains other than their own.  The return path here will

// often lift that restriction so, for instance, you could send

// email to a hotmail account. (hosting provider settings may vary)

// technically bounced email is supposed to go to the return-path email

$headers .= "Return-path: " . $_POST["email"];



// now we can add the content of the message to a body variable

$message = $_POST['message'];

$message = ""; 
foreach($_POST as $key=>$value) 
{ 
$message .= $key.": ".$value."\n\r"; 
} 





// once the variables have been defined, they can be included

// in the mail function call which will send you an email

mail($sendTo, $subject, $message, $headers);



?>

can some1 suggest me something iam a complete noob !

echo "<tr>
<td class='trow2' align='center' valign='center' width='1'></td>
<td class='trow2' valign='center'>
<strong><a href='server.php?view=details&id=" . $list['id'] . "'>" . capitalizeFirstCharacter($list['servername']) . "</a></strong>
<div class=\"stat2\">
<div class=\"stat\">
if(!$sock=@fsockopen($list_f['serverip'],$list_f['serverport'], $num, $error, 1)) {
echo "<font color='red'><b>Offline</b></font>";
} else {
echo "<font color='green'><b>Online</b></font>";
}
</div>
</div>
<div class='smalltext'>" . $list['shortdescription'] . "</div>
</td>
<td class='trow1' valign='middle' align='left' style='white-space: nowrap'><span class='smalltext'>" . $list['revision'] . "</span></td>
<td class='trow2' valign='middle' align='right' style='white-space: nowrap'><font size='4px'>" . $voteAmount . " Votes</font></td>
</tr>";

How can I make this echo code work?

Okay, I am writing a new form validation script that also keeps the data so it can re-populate the fields the user already filled out if there is an error on the page so they do not have to fill it out again.

Here is an example of the code I am using in the HTML part of the form input elements.


<input name="name" type="text" id="name" value="<?php=$fields['name']?>">


Now, the problem I am getting is the <?php=$fields['name']?> code is being physically displayed within the form field at all times. How would I go about having it not display this line of code in the field?

Thanks!!

This topic has been moved to PHP Freelancing.

http://www.phpfreaks.com/forums/index.php?topic=348574.0

Okay, let's say I have  a block of text like so;


00000000 00000000
00000000 00000000
00000000 00000000
00000000 00000000
00000000 00000000
00000000 00000000


I need to be able to add more/less digits to the text.

Like so;

0x00000000 0x00000000
0x00000000 0x00000000
0x00000000 0x00000000
0x00000000 0x00000000
0x00000000 0x00000000

etc

Also if it's greater than a certain number, to subtract. :3

How would I go about doing that?


Thank you,

Doctor

<?php
// SQL Connection
$username="root"; $password=""; $database="mydb";
$connection = mysql_connect("localhost", $username, $password) 
or die("Connection Failure to Database");
// Select Database
mysql_select_db($database, $connection) or die ($database . "No Database" . $username);

$id = $_GET['id'];
$MyQuery = "SELECT * FROM bookings WHERE id = '$id'";
$retrieve = mysql_query($MyQuery) or die(mysql_error());
if(mysql_num_rows($retrieve) != 0):
$row = mysql_fetch_assoc($retrieve);
endif;

$idX = ($row['id']);
echo $idX;

if(mysql_num_rows($retrieve) == 0)
{ echo '<blink><font color="red"><strong>No Booking Found</strong></font></blink>'; }
else
{ echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">';
echo '<table width="350">';
echo ' <tr>';
echo ' <td width="100">Full Name</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['fullname']) . '" type="text" name="fullname"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Address</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['address']) . '" type="text" name="address"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">City</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['city']) . '" type="text" name="city"></td>';
echo ' <tr>';
echo ' <td width="100">Postcode</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['postcode']) . '" type="text" name="postcode"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Country</td>';
echo ' <td width="100"><select style="width: 235px" name="country">';
echo ' <option value="' . ($row['country']) . '">' . ($row['country']) . '</option>';
echo ' <option></option><option value="Abkhazia">Abkhazia</option><option value="Afghanistan">Afghanistan</option><option value="Aland">Aland</option><option value="Albania">Albania</option><option value="Algeria">Algeria</option><option value="American Samoa">American Samoa</option><option value="Andorra">Andorra</option><option value="Angola">Angola</option><option value="Anguilla">Anguilla</option><option value="Antarctica">Antarctica</option><option value="Antigua and Barbuda">Antigua and Barbuda</option><option value="Argentina">Argentina</option><option value="Armenia">Armenia</option><option value="Aruba">Aruba</option><option value="Ascension">Ascension</option><option value="Ashmore and Cartier Islands">Ashmore and Cartier Islands</option><option value="Australia">Australia</option><option value="Australian Antarctic Territory">Australian Antarctic Territory</option><option value="Austria">Austria</option><option value="Azerbaijan">Azerbaijan</option><option value="Bahamas, The">Bahamas, The</option><option value="Bahrain">Bahrain</option><option value="Baker Island">Baker Island</option><option value="Bangladesh">Bangladesh</option><option value="Barbados">Barbados</option><option value="Belarus">Belarus</option><option value="Belgium">Belgium</option><option value="Belize">Belize</option><option value="Benin">Benin</option><option value="Bermuda">Bermuda</option><option value="Bhutan">Bhutan</option><option value="Bolivia">Bolivia</option><option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option><option value="Botswana">Botswana</option><option value="Bouvet Island">Bouvet Island</option><option value="Brazil">Brazil</option><option value="British Antarctic Territory">British Antarctic Territory</option><option value="British Indian Ocean Territory">British Indian Ocean Territory</option><option value="British Sovereign Base Areas">British Sovereign Base Areas</option><option value="British Virgin Islands">British Virgin Islands</option><option value="Brunei">Brunei</option><option value="Bulgaria">Bulgaria</option><option value="Burkina Faso">Burkina Faso</option><option value="Burundi">Burundi</option><option value="Cambodia">Cambodia</option><option value="Cameroon">Cameroon</option><option value="Canada">Canada</option><option value="Cape Verde">Cape Verde</option><option value="Cayman Islands">Cayman Islands</option><option value="Central African Republic">Central African Republic</option><option value="Chad">Chad</option><option value="Chile">Chile</option><option value="China, Peoples Republic of">China, Peoples Republic of</option><option value="China, Republic of (Taiwan)">China, Republic of (Taiwan)</option><option value="Christmas Island">Christmas Island</option><option value="Clipperton Island">Clipperton Island</option><option value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option><option value="Colombia">Colombia</option><option value="Comoros">Comoros</option><option value="Congo, Democratic Republic of the (Congo  Kinshasa)">Congo, Democratic Republic of the (Congo  Kinshasa)</option><option value="Congo, Republic of the (Congo  Brazzaville)">Congo, Republic of the (Congo  Brazzaville)</option><option value="Cook Islands">Cook Islands</option><option value="Coral Sea Islands">Coral Sea Islands</option><option value="Costa Rica">Costa Rica</option><option value="Cote dIvoire (Ivory Coast)">Cote dIvoire (Ivory Coast)</option><option value="Croatia">Croatia</option><option value="Cuba">Cuba</option><option value="Cyprus">Cyprus</option><option value="Czech Republic">Czech Republic</option><option value="Denmark">Denmark</option><option value="Djibouti">Djibouti</option><option value="Dominica">Dominica</option><option value="Dominican Republic">Dominican Republic</option><option value="Ecuador">Ecuador</option><option value="Egypt">Egypt</option><option value="El Salvador">El Salvador</option><option value="Equatorial Guinea">Equatorial Guinea</option><option value="Eritrea">Eritrea</option><option value="Estonia">Estonia</option><option value="Ethiopia">Ethiopia</option><option value="Falkland Islands (Islas Malvinas)">Falkland Islands (Islas Malvinas)</option><option value="Faroe Islands">Faroe Islands</option><option value="Fiji">Fiji</option><option value="Finland">Finland</option><option value="France">France</option><option value="French Guiana">French Guiana</option><option value="French Polynesia">French Polynesia</option><option value="French Scattered Islands in the Indian Ocean">French Scattered Islands in the Indian Ocean</option><option value="French Southern and Antarctic Lands">French Southern and Antarctic Lands</option><option value="Gabon">Gabon</option><option value="Gambia, The">Gambia, The</option><option value="Georgia">Georgia</option><option value="Germany">Germany</option><option value="Ghana">Ghana</option><option value="Gibraltar">Gibraltar</option><option value="Greece">Greece</option><option value="Greenland">Greenland</option><option value="Grenada">Grenada</option><option value="Guadeloupe">Guadeloupe</option><option value="Guam">Guam</option><option value="Guatemala">Guatemala</option><option value="Guernsey">Guernsey</option><option value="Guinea">Guinea</option><option value="Guinea-Bissau">Guinea-Bissau</option><option value="Guyana">Guyana</option><option value="Haiti">Haiti</option><option value="Heard Island and McDonald Islands">Heard Island and McDonald Islands</option><option value="Honduras">Honduras</option><option value="Hong Kong">Hong Kong</option><option value="Howland Island">Howland Island</option><option value="Hungary">Hungary</option><option value="Iceland">Iceland</option><option value="India">India</option><option value="Indonesia">Indonesia</option><option value="Iran">Iran</option><option value="Iraq">Iraq</option><option value="Ireland">Ireland</option><option value="Isle of Man">Isle of Man</option><option value="Israel">Israel</option><option value="Italy">Italy</option><option value="Jamaica">Jamaica</option><option value="Japan">Japan</option><option value="Jarvis Island">Jarvis Island</option><option value="Jersey">Jersey</option><option value="Johnston Atoll">Johnston Atoll</option><option value="Jordan">Jordan</option><option value="Kazakhstan">Kazakhstan</option><option value="Kenya">Kenya</option><option value="Kingman Reef">Kingman Reef</option><option value="Kiribati">Kiribati</option><option value="Korea, Democratic Peoples Republic of (North Korea)">Korea, Democratic Peoples Republic of (North Korea)</option><option value="Korea, Republic of  (South Korea)">Korea, Republic of  (South Korea)</option><option value="Kosovo">Kosovo</option><option value="Kuwait">Kuwait</option><option value="Kyrgyzstan">Kyrgyzstan</option><option value="Laos">Laos</option><option value="Latvia">Latvia</option><option value="Lebanon">Lebanon</option><option value="Lesotho">Lesotho</option><option value="Liberia">Liberia</option><option value="Libya">Libya</option><option value="Liechtenstein">Liechtenstein</option><option value="Lithuania">Lithuania</option><option value="Luxembourg">Luxembourg</option><option value="Macau">Macau</option><option value="Macedonia">Macedonia</option><option value="Madagascar">Madagascar</option><option value="Malawi">Malawi</option><option value="Malaysia">Malaysia</option><option value="Maldives">Maldives</option><option value="Mali">Mali</option><option value="Malta">Malta</option><option value="Marshall Islands">Marshall Islands</option><option value="Martinique">Martinique</option><option value="Mauritania">Mauritania</option><option value="Mauritius">Mauritius</option><option value="Mayotte">Mayotte</option><option value="Mexico">Mexico</option><option value="Micronesia">Micronesia</option><option value="Midway Islands">Midway Islands</option><option value="Moldova">Moldova</option><option value="Monaco">Monaco</option><option value="Mongolia">Mongolia</option><option value="Montenegro">Montenegro</option><option value="Montserrat">Montserrat</option><option value="Morocco">Morocco</option><option value="Mozambique">Mozambique</option><option value="Myanmar (Burma)">Myanmar (Burma)</option><option value="Nagorno-Karabakh">Nagorno-Karabakh</option><option value="Namibia">Namibia</option><option value="Nauru">Nauru</option><option value="Navassa Island">Navassa Island</option><option value="Nepal">Nepal</option><option value="Netherlands">Netherlands</option><option value="Netherlands Antilles">Netherlands Antilles</option><option value="New Caledonia">New Caledonia</option><option value="New Zealand">New Zealand</option><option value="Nicaragua">Nicaragua</option><option value="Niger">Niger</option><option value="Nigeria">Nigeria</option><option value="Niue">Niue</option><option value="Norfolk Island">Norfolk Island</option><option value="Northern Cyprus">Northern Cyprus</option><option value="Northern Mariana Islands">Northern Mariana Islands</option><option value="Norway">Norway</option><option value="Oman">Oman</option><option value="Pakistan">Pakistan</option><option value="Palau">Palau</option><option value="Palestine">Palestine</option><option value="Palmyra Atoll">Palmyra Atoll</option><option value="Panama">Panama</option><option value="Papua New Guinea">Papua New Guinea</option><option value="Paraguay">Paraguay</option><option value="Peru">Peru</option><option value="Peter I Island">Peter I Island</option><option value="Philippines">Philippines</option><option value="Pitcairn Islands">Pitcairn Islands</option><option value="Poland">Poland</option><option value="Portugal">Portugal</option><option value="Pridnestrovie (Transnistria)">Pridnestrovie (Transnistria)</option><option value="Puerto Rico">Puerto Rico</option><option value="Qatar">Qatar</option><option value="Queen Maud Land">Queen Maud Land</option><option value="Reunion">Reunion</option><option value="Romania">Romania</option><option value="Ross Dependency">Ross Dependency</option><option value="Russia">Russia</option><option value="Rwanda">Rwanda</option><option value="Saint Helena">Saint Helena</option><option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option><option value="Saint Lucia">Saint Lucia</option><option value="Saint Pierre and Miquelon">Saint Pierre and Miquelon</option><option value="Saint Vincent and the Grenadines">Saint Vincent and the Grenadines</option><option value="Samoa">Samoa</option><option value="San Marino">San Marino</option><option value="Sao Tome and Principe">Sao Tome and Principe</option><option value="Saudi Arabia">Saudi Arabia</option><option value="Senegal">Senegal</option><option value="Serbia">Serbia</option><option value="Seychelles">Seychelles</option><option value="Sierra Leone">Sierra Leone</option><option value="Singapore">Singapore</option><option value="Slovakia">Slovakia</option><option value="Slovenia">Slovenia</option><option value="Solomon Islands">Solomon Islands</option><option value="Somalia">Somalia</option><option value="Somaliland">Somaliland</option><option value="South Africa">South Africa</option><option value="South Georgia and the South Sandwich Islands">South Georgia and the South Sandwich Islands</option><option value="South Ossetia">South Ossetia</option><option value="Spain">Spain</option><option value="Sri Lanka">Sri Lanka</option><option value="Sudan">Sudan</option><option value="Suriname">Suriname</option><option value="Svalbard">Svalbard</option><option value="Swaziland">Swaziland</option><option value="Sweden">Sweden</option><option value="Switzerland">Switzerland</option><option value="Syria">Syria</option><option value="Tajikistan">Tajikistan</option><option value="Tanzania">Tanzania</option><option value="Thailand">Thailand</option><option value="Timor-Leste (East Timor)">Timor-Leste (East Timor)</option><option value="Togo">Togo</option><option value="Tokelau">Tokelau</option><option value="Tonga">Tonga</option><option value="Trinidad and Tobago">Trinidad and Tobago</option><option value="Tristan da Cunha">Tristan da Cunha</option><option value="Tunisia">Tunisia</option><option value="Turkey">Turkey</option><option value="Turkmenistan">Turkmenistan</option><option value="Turks and Caicos Islands">Turks and Caicos Islands</option><option value="Tuvalu">Tuvalu</option><option value="U.S. Virgin Islands">U.S. Virgin Islands</option><option value="Uganda">Uganda</option><option value="Ukraine">Ukraine</option><option value="United Arab Emirates">United Arab Emirates</option><option value="United Kingdom">United Kingdom</option><option value="United States">United States</option><option value="Uruguay">Uruguay</option><option value="Uzbekistan">Uzbekistan</option><option value="Vanuatu">Vanuatu</option><option value="Vatican City">Vatican City</option><option value="Venezuela">Venezuela</option><option value="Viet Nam">Viet Nam</option><option value="Wake Island">Wake Island</option><option value="Wallis and Futuna">Wallis and Futuna</option><option value="Western Sahara">Western Sahara</option><option value="Yemen">Yemen</option><option value="Zambia">Zambia</option><option value="Zimbabwe">Zimbabwe</option></SELECT></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Tel</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['tel']) . '" type="text" name="tel"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Email</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['email']) . '" type="text" name="email"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Info</td>';
echo ' <td width="100"><input style="width: 235px" value="' . ($row['info']) . '" type="text" name="info"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Checkin Date</td>';
echo ' <td width="100"><input style="width: 70px" value="' . ($row['checkin']) . '" type="text" name="checkin"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100">Checkout Date</td>';
echo ' <td width="100"><input style="width: 70px" value="' . ($row['checkout']) . '" type="text" name="checkout"></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td width="100"></td>';
echo ' <td width="100"><input type="submit" name="editbooking" value="Update Booking"></td>';
echo ' </tr>';
echo '</table>';
echo '<input type="hidden" name="source">';
echo '</form>'; } 

if (isset($_POST['editbooking'])) {

$fullname = $_POST['fullname'];
$address = $_POST['address'];
$city = $_POST['city'];
$postcode = $_POST['postcode'];
$country = $_POST['country'];
$tel = $_POST['tel'];
$email = $_POST['email'];
$info = $_POST['info'];
$checkin = $_POST['checkin'];
$checkout = $_POST['checkout'];
$source = 'Manual Add';

$id_update = ($row['id']);

$SQL = "UPDATE bookings SET fullname = '$fullname', address = '$address', city = '$city', postcode = '$postcode', country = '$country', tel = '$tel', email = '$email', info = '$info', checkin = '$checkin', checkout = '$checkout', source = '$source' WHERE id = '$id_update'";

error_reporting(0);
$result = mysql_db_query($database,"$SQL");
header("location:index.php#bookings");
}
?>

Where am I going wrong here? It simply won't update the query but if I change $id to 27 for example it will edit it??

it says i have an error in in line 23 which is

i cant seem to find it
Code: [Select]
<?php

if($_POST['loginbtn']){

require "scripts/connect.php";

$email = mysql_real_escape_string($_POST['email']);
$password = mysql_real_escape_string($_POST['password']);

if($email && $password){

$password = md5("$password");

$query = mysql_query("SELECT * FROM ezadmin WHERE email = '$email'");
$numrows = mysql_num_rows($query);

if($numrows != 0){

                $row = mysql_fetch_assoc($query); //line 23

$dbemail = $row ['email'];
$dbpassword = $row ['password'];

if($dbemail === $email && $dbpassword === $password){

$_SESSION['email'] = $dbemail;
header("location: adminpanel");
exit();

}else
    $msg = "PLEASE CHECK YOU EMAIL OR PASSWORD!";
}else
    $msg = "PERSON DOES NO EXSIT!";
}else
    $msg = "YOU MUST FILL IN ALL FIELDS!";
 
    mysql_close();
}
?>