PHP - Include Path Is Driving Me Crazy

I'm trying to setup my database class so that by default it will create all of the tables and triggers required for my application to run. I've got everything working except for it adding the trigger. Here's the relevant code (slightly obfuscated for security reasons):

    private function check_consistency()
    {

        $database_query = <<<QUERY
CREATE TABLE IF NOT EXISTS d2b_users (

    id INT NOT NULL AUTO_INCREMENT,
    obfuscated INT NOT NULL,
    obfuscated VARCHAR(50) NOT NULL,
    obfuscated VARCHAR(32) NOT NULL,
    obfuscated VARCHAR(32) NOT NULL,
    obfuscated VARCHAR(32) NOT NULL,
    obfuscated BOOL NOT NULL DEFAULT '1',
    UNIQUE KEY(id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS d2b_statistics (

    id INT NOT NULL,
    obfuscated BIGINT NOT NULL DEFAULT '0',
    UNIQUE KEY(id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

delimiter |

CREATE TRIGGER d2b_auto_statistics AFTER INSERT ON d2b_users
  FOR EACH ROW BEGIN
    INSERT INTO d2b_statistics SET id = NEW.id;
END;

|

delimiter ;

QUERY;
        
        if(!$consistency = $this->link->multi_query($database_query))
        {

            die("Failed to create/verify the default database tables.");

        }

        return true;

    }

I've also tried removing the delimiter and the colon after the INSERT line in the trigger and I still can't get it to add properly. What's annoying is that I'm able to take the code for the trigger from above and go into phpmyadmin and paste it into the SQL and it will add and work correctly. However, I'm trying to get my class to do that automatically so the php application automatically installs itself on other servers.

What am I doing wrong?

Hello,
   If anyone can help please let me know. The 2 files below are what's used to render the "Frickster's ListRave Posts" at the following URL http://www.listrave.com/member/profile.php?id=24. You can see that under Antiques it lists the same ads under both York and Altoona. The script is identifying all ads posted by User ID 24 but I don't know why it is duplicating those ads in the 2 different cities. There should actually be 2 ads for York and one for Altoona. The code is below. Again, please help

Here's the code to pull the info from the data base (called memberall_listings.php)

$conn = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die ('Error connecting to mysql');
   mysql_select_db($dbname1) or die('Could not connect: ' . mysql_error());

   $tables = mysql_list_tables($dbname1);
       
   while (list($table) = mysql_fetch_row($tables)) {
      $site["tablename"][] = $table;
      
   }

   
   if($_REQUEST["id"]!='')
      $getmemberId  = $_REQUEST["id"];
   else
      $getmemberId  = $_SESSION["memberid"];
   //$x = getTableDetailsByTableName1("");
//   echo count($site["tablename"]);
   $zz=-1;
   for($ww=0;$ww<count($site["tablename"]);$ww++) {
      
      $ValidTable = array("baltperm4w", "balt_yellowpages","boats");

      if(!in_array($site["tablename"][$ww],$ValidTable)) {

         if (count(getTableDetailsByTableName2($site["tablename"][$ww])) >0)
               $zz++;
               
         for($kk=0;$kk<count(getTableDetailsByTableName2($site["tablename"][$ww]));$kk++) {
               //   echo $site["tablename"][$zz]."<br></br>";
                  
         $getTableDetails   = getTableDetailsByTableName($site["tablename"][$ww],$kk);
         //echo $getTableDetails["city"];
         if ($kk > 0)
         if ($getTableDetails['city']==$lastcity && $getTableDetails['state']==$laststate) {

            continue;
         }
            
            
         $getAllArray[$zz][$kk]["Titlename"]      = "<a href='http://www.listrave.com'>ListRave</a> --> <a href=".$getTableDetails["stateurl"].">".$getTableDetails["state"]."</a> --> <a href=".$getTableDetails["cityurl"].">".mysql_real_escape_string($getTableDetails["city"])."</a> --> <a href=".$getTableDetails["maincaturl"].">".$getTableDetails["maincat"]."</a> --> <a href=".$getTableDetails["caturl"].">".$getTableDetails["cat"]."</a>";
         $getAllArray[$zz][$kk]["PostURL"]        = $getTableDetails["SitePostUrl"];
         $getAllArray[$zz][$kk]["AgeFormat"]        = $getTableDetails["DisplayFormat"];
         $getAllArray[$zz][$kk]["TableName"]        = $site["tablename"][$ww];
         $getAllArray[$zz][$kk]["SiteRealPath"]   = $getTableDetails["SiteRealPath"];
         
      $lastcity =  $getTableDetails["city"];
         $laststate =  $getTableDetails["state"];
         
         $GetAdlists[$zz]["MainArray"] = GetMemberAdLists($site["tablename"][$ww],$getmemberId);
         
         if($GetAdlists[$zz]["MainArray"]!=""){
            $getAllArray[$zz][$kk]["ArrayExist"]     = "Yes";
         }else{
            $getAllArray[$zz][$kk]["ArrayExist"]     = "No";
         }
         
         for($k=0;$k<count($GetAdlists[$zz]["MainArray"]);$k++) {
            $getdate               = explode(",",$GetAdlists[$zz]["MainArray"][$k]["Posted_date"]);
            $getAllArray[$zz][$kk][$k]['day']     = date("l",strtotime($getdate[0]));
            $getAllArray[$zz][$kk][$k]['month']   = date("F",strtotime($getdate[0]));
            $getAllArray[$zz][$kk][$k]['date']    = date("d",strtotime($getdate[0]));
            $getAllArray[$zz][$kk][$k]['ListArray']  = getMemberAddetails($getdate[0],$site["tablename"][$ww],$getmemberId, $getTableDetails["city"], $getTableDetails["state"]);

                for($mn=0;$mn<count($getAllArray[$zz][$kk][$k]['ListArray']);$mn++) {
               if($getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture0"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture1"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture2"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture3"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture4"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture5"]!='')
                  $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["ImageArray"]  = 'Yes';
               else
                  $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["ImageArray"]  = 'No';
           }
         }   
   
            }
          }
   }
   
      
   /* if($_SERVER['REMOTE_ADDR'] = '122.165.56.46') {
      printArray($getAllArray);
      exit;   
   }     */
   
   
   
   
   function SelectQry1($Qry) {
      $result = mysql_query($Qry) or die ("QUERY Error:".$Qry."<br>".mysql_error());
      $numrows = mysql_num_rows($result);      
      if ($numrows == 0){         
         return;
      } else {
         $row = array();
         $record = array();
         while ($row = mysql_fetch_array($result)){
         $record[] = $row;
         }      
      }      
      return $record;
   }
   
   function getTableDetailsByTableName($tablename, $kk) {
      global $global_config;
         $Qry = "select * FROM ".$tablename."";
         $getListingdetail = SelectQry1($Qry);
         return $getListingdetail[$kk];
   }
   
   
   function getTableDetailsByTableName2($tablename) {
      global $global_config;
         $Qry = "select * FROM ".$tablename."";
         $getListingdetail = SelectQry1($Qry);
         return $getListingdetail;
   }
   
       

   function GetMemberAdLists($tablename,$getmemberId) {
      global $global_config;
         $Qry = "select Posted_date FROM ".$tablename." where memberid='".$getmemberId."' group by SUBSTRING_INDEX(Posted_date,',',1) Order by Posted_date DESC";
         $getimagedetail = SelectQry1($Qry);
         return $getimagedetail;
   }
   
   function getMemberAddetails($date,$tablename,$getmemberId) {
      global $global_config;
         $Qry = "select *  from ".$tablename." WHERE `Posted_date` like '%".$date."%' AND ActivationStatus = 'Active' AND PublishedStatus='Active' AND memberid='".$getmemberId."'  group by Posted_date Order by Ident DESC";
         $getimagedetail = SelectQry1($Qry);
         return $getimagedetail;
   }

     
?>



Here's the code to display it. Remember, this is just for "Frickster's ListRave Posts"

<?php
// start session
ob_start();
session_start();
include "../includes/config.php";

//include('incsec/inccheckifadmin.php');
include ('incsec/incconn.php');
include ('incsec/incsettings.php');
include ('incfunctions.php');



   if($_REQUEST["id"]!='')
      $ActiveMemberID = $_REQUEST["id"];
   else
      $ActiveMemberID = $_SESSION["memberid"];
      

   $query="SELECT * FROM tblmembers where memberid = '".$ActiveMemberID."'";
   $result11 = mysql_query($query,$dbconnection);
   $members = mysql_fetch_array($result11);   
        $pagetitle = 'ListRave - '.$members["username"]." 's".' Profile Page';


   include("memberall_business.php");
 
        include('memberall_listings.php');

       

       
   //printArray($getAllArray);
   //exit;

 ?>


<?php include('header_member2.php') ?>
<div style="height:50px;"> </div>
<table border="0" cellpadding="2" cellspacing="0" width="80%" align="center">
   <tr>
      <td valign="top" width="30%" align="left">
         <table border="0" cellpadding="0" cellspacing="0" width="100%">
            <tr>
               <td valign="top" align="left">
                  <table width="100%">

<tr>
<td valign = "top" style="text-align: center;">
<?php
include ('incsec/incconn.php');
$dbconnection = mysql_connect($dbhost,$dbusername,$dbpassword);
mysql_select_db($database,$dbconnection);

$query="SELECT * FROM tblmembers where memberid = '".$ActiveMemberID."'";
$result = mysql_query($query,$dbconnection);
$numrecs=mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$currentmemberid = $myrow['memberid'];

$qry="SELECT * FROM tbl_listrave_ad where memberid = '".$ActiveMemberID."' and PublishedStatus='Active'";
$result1 = mysql_query($qry,$dbconnection);
$getcnt =mysql_num_rows($result1);


?>
<?php if($numrecs!=0) { ?>
<table height="100" width="90%" border="0" cellpadding="6" cellspacing="0" align="center">
   <tr>
      <td valign="top">
         <table width="100%" border="0" cellpadding="0" cellspacing="0" style="border:1px solid #0166FF;">
   <tr>
   <td align="left" class="profilefheader" width="100%" colspan="2" style="padding-left:5px; padding-top:0px; height:20px; line-height:20px;" valign="middle"><?php echo $myrow["username"];  ?>'s Profile</td>
   </tr>
   <tr>
      <td align="left" valign="top">
         <table width="100%" border="0" cellpadding="10" cellspacing="0" id="profilecontainer" align="left" style="margin-left: 10%">
            <tr>
               <td valign = "top" width="10%">
                  <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
                        <tr>
                           <td width="20%" align="left" valign="top" style="padding-right:35px">
                           <?php if($myrow["memberphoto"]!='') { ?>
                              <a target="_blank" href="imageview.php?id=<?php echo $myrow["memberid"]; ?>">
                                 <img width="180" height="180" class="Imageborder" src="<?php echo $config["sitepath"]."memberphotos/".$myrow["memberphoto"].""; ?>">
                              </a>
                              <?php } else { ?>   
                                 <img src="no-image.gif" border="0" width="180" height="180" class="Imageborder"  />          
                              <?php } ?>   
                           </td>
                        </tr>
                        <tr>
                           <td height="30">
                           </td>
                        </tr>
                        <?php /*?><tr>   
                           <td width="80%" align="center" valign="top">
                           <?php if($myrow["memberphoto"]!='') { ?>
                              <img src="upload.gif" border="0" />    
                           <?php } else { ?>      
                              <img src="change-photo.gif" border="0" />    
                           <?php } ?>   
                          </td>
                        </tr><?php */?><tr valign="bottom"><td>&nbsp;</td></tr><tr><td align="left"><img src="addcontact.gif" alt="Add This Member To Your Contacts" /></td></tr></table>
               </td>   
               <td valign = "top">
                  <table width="90%" border="0" cellpadding="6" cellspacing="0" align="left">
                        <tr>
                           <td align="left" valign="top" colspan="2">
                              <table width="90%" border="0" cellpadding="0" cellspacing="0">
                                 <tr>
                                    <td valign="top" width="15%" nowrap="nowrap">
                                       <span id="profilecontainer">Personal Information&nbsp;&nbsp;&nbsp;</span>
                                    </td>
                                    <td width="88%" valign="top">
                                       <div style="border-top: #CCCCCC  solid 1px; position:relative; top:7px;">&nbsp;</div>
                                   </td>
                                 </tr>
                              </table>
                              
                           </td>
                        </tr>
                        <?php if($myrow["firstname"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                                 <strong>First Name</strong>
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["firstname"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["othernames"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Last Name</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["othernames"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["gender"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Gender</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["gender"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["age"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Age</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["age"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                                                               
                                                                <?php if($myrow["pobox"]!='') { ?>
                                                <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Location</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["pobox"];  ?>
                           </td>
                        </tr>
                     <?php } ?>
                        
                        <?php if($myrow["relationship_status"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Relationship Status</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["relationship_status"];  ?>
                           </td>
                        </tr>   
                        <?php } ?>
                        
                                                                <?php if($myrow["registrationdate"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Member Since</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo date('M d, Y', strtotime($myrow["registrationdate"]));  ?>
                           </td>
                        </tr>
                        <?php } ?>

                        <?php if($myrow["username"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>User Name</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["username"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["about_me"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>About me</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["about_me"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["hobbies"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Hobbies</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["hobbies"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                                                                <?php if($myrow["movies"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Favorite Movies</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["movies"];  ?>
                           </td>
                        </tr>
                        <?php } ?>

                                                                <?php if($myrow["music"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Favorite Music</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["music"];  ?>
                           </td>
                        </tr>
                        <?php } ?>

                                                                <?php if($myrow["books"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Favorite Books</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["books"];  ?>
                           </td>
                        </tr>
                        <?php } ?>

                        <tr>
                           <td height="15">
                           </td>
                        </tr>
                        <tr>
                           <td align="left" valign="top" colspan="2">
                              <table width="90%" border="0" cellpadding="0" cellspacing="0" >
                                 <tr>
                                    <td valign="top" width="15%" nowrap="nowrap" >
                                       <span id="profilecontainer">Contact Information&nbsp;&nbsp;&nbsp;</span>
                                    </td>
                                    <td width="88%" valign="top">
                                       <div style="border-top: #CCCCCC  solid 1px; position:relative; top:7px;">&nbsp;</div>
                                   </td>
                                 </tr>
                              </table>
                              
                           </td>
                        </tr>
                        <?php if($myrow["emailaddress"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                                 <strong>Email</strong>
                           </td>
                           <td align="left" valign="top">
                                    <?php echo $myrow["emailaddress"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["phonenumber"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Mobile Number</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["phonenumber"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
           &

hi guys

when a match is over, two result fields have to be edited

the first update goes well
but the second one is failing, not allways, sometimes it gives the loser xp, but not the winner (with two players)

the script should give the winner 100 xp
second 95, third 90,...

only the first two controls at the end are working
the thirth one is not, and its being used to make the first two
so it is doing its job there ...

<?php

include("./includes/egl_inc.php");
$secure = new secure();
$secure->secureGlobals();
page_protect();

global $config;

$matchidcheck = $_SESSION['matchid'];
$maks = '100';

$players=mysql_query("SELECT playerid FROM ffa_points WHERE matchid='$matchidcheck' order by killsdeaths DESC");
         while(list($playerid)=mysql_fetch_array($players))
         {
         
            $playerspoints=mysql_query("SELECT points FROM members WHERE id='$playerid'");
            while(list($points)=mysql_fetch_row($playerspoints))
            {
            $userpoints = $points;
            }
            $newpoints = $userpoints + $maks;
            mysql_query("UPDATE members SET points = $newpoints
            WHERE id='$playerid'");
            mysql_query("UPDATE ffa_points SET xppoints = $maks
            WHERE id='$playerid' and matchid='$matchidcheck'");
            if ($totalxp > 51)
            {
            $maks = $maks - 5;
            }
            
         }

                             $mes="$newpoints $points $maks All Results have been stored succesfully !! Thank You !";
               return success($mes,'./ffamatchesarchive.php');

include("$config");
?>

any help would be greatly appreciated

thanks

Hi People.

I am trying to insert data from a form into my database.

Now I have the following code to connect to the DB to update a table so I know that I can connect to the DB ok

Code: [Select]
<?php 
// this code I got from the new boston, PHP tutorial 25 in selecting a mysql db
// opens connection to mysql server
$dbc = mysql_connect('localhost', 'VinnyG', 'thepassword');
if (!$dbc) {
die("Not Connected:" . mysql_error ());
}
// select database
$db_selected = mysql_select_db ("sitename",$dbc);
if(!$db_selected)
{
die("can not connect:" . mysql_error ());

}
// testing code

$query="UPDATE users SET username = 'testing testing' WHERE user_id = '2'";
$result=mysql_query($query);


?>

Now here is the code from my form.

Code: [Select]
</head>

<body>
<?php
//include "connection_file.php" 
//include "config01.php"

$username = "username";
$height_above = "height_above";
$mb_diff = "mb_diff";
$alternative = "alternative"; 

?>

<form name = 'form1' method = 'post' action='config01.php'>
<table width="700" border="1" cellspacing="5" cellpadding="5">
  <caption>
    Submit Your Airfield Details
  </caption>
  <tr>
    <td width="100">&nbsp;</td>
    <td width="200">Your Name</td>
    <td width="200"><input type='text' name='username' maxlength='30'></td>
    <td width="100">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Height Above MSL</td>
    <td><input type='text' name='height_above'maxlength= '30'></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Mb Difference</td>
    <td><input type='text' name='mb_diff'maxlength='40'></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Alternative Airfield</td>
    <td><input type='text' name='alternative' maxlength='30'></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><input type='submit' name='submit' value='post' /></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>
<?php
$sql01 = "INSERT INTO users SET user_id = '', username = '$username',height_above = '$height_above', mb_diff = $mb_diff, alternative = $alternative";
$result=mysql_query($sql01);
?>

</body>
</html>

here is the config01.php that the form refers to in the 'action' above.

Code: [Select]
<?php
$host = 'localhost';
$username = 'VinnyG';
$password = 'thepassword';
$db_name = 'sitename';

//connect to database
mysql_connect ("$host","$username","password")or die ("cannot connect to server");
mysql_select_db ("db_name") or die ("cannot select DB");

?>
Please could someone look at the above code and tell me where I'm going wrong.  I can connect to the DB and update using the top script but I can't submit the form for some reason.  I get a "cannot connect to server" message.

Please someone help.  It's been driving me crazy for the past two days.

Regards
VinceG
http://www.microlightforum.com

I have a simply script like this:

$fh = fopen("test/test.js", 'w+') or die("can't open file");
fwrite($fh, $output);
fclose($fh);


It ONLY works if the "test" directory has a 777 permissions. Works like a charm then, but the moment it goes to even 775, I get this:

Warning: fopen(test/test.js) [function.fopen]: failed to open stream: Permission denied in /var/www/vhosts/mydomain.com/httpdocs/f.php on line 42


Any thoughts? I don't want this folder to remain 777

Thanks