PHP - Pdo/oop Execute Sql File

Or is it all pieced together into one file then executed?

I ask because I'm thinking of a weird way to handle errors on my site that would integrate with the interface smoothly without much work on my part.

Every page on my site requires template_top.php at the start of the script and template_bottom.php at the bottom. I believe this is a pretty common thing to do, and it standardizes all my menus and interfaces and whatever else, plus it gives me a nice place to deliver messages to the user. What I want to do is something like this simplified example:

template_top.php:
<?php
// layout stuff here
try
{
?>

index.php:
<?php
require_once('template_top.php');
// a wild error appears!
throw new Exception('oh no!');
require_once('template_bottom.php');
?>

template_bottom.php:
<?php
}
catch (Exception $e)
{
   echo 'An error occured! Message: ' . $e->getMessage();
}
// layout stuff here
?>

So that's where my question comes in. Both template files contain code that, if executed on it's own, is invalid. Pieced together in my pages though, it forms correct code. I'd really like to do this since all I'd have to do if my script encounters a problem is throw an Exception and everything is instantly handled without me having to fight with display issues. If this isn't possible, does anybody have any better suggestions?

Hi Guys,

how to execute batch file in wamp server php code.

Could you please help on that.

 

Not sure if this is possible I am trying to do a multi delete:

Code: [Select]

<form name="form1" method="post" action="">
<table>
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
</tr>
<?php
}
?>


// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}
<tr><td>
<select name="dropdown">
<option value="option1">Choose an action...</option>
<option value="edit">Edit</option>
<option value="delete">Delete</option>
</select>
<a class="button" href="#">Apply to selected</a>


if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=nameslist.php\">";
}
}
mysql_close();

hi,

I am having problems setting a session from a SQL query, please help... here is my code:

Code: [Select]
$query1 = "SELECT * FROM members_copy WHERE rsUser = '$username' AND rsPass = '$password'";
$result1 = mysql_query($query1);
echo "<br>".$result1['USERID'];


 $_SESSION['s_logged_n'] = 'true';
 $_SESSION['s_username'] = $username;
 $_SESSION['USERID']=$result1['USERID'];
$_SESSION['RSTOWN']=$result1['RSTOWN'];
$_SESSION['RSEMAIL']=$result1['RSEMAIL'];
$_SESSION['RSUSER']=$result1['RSUSER'];

no sessions are currently being set?!
 

Hi,   I have a cron job that executes this script every 2 minutes:

<?php

// LOAD WP-LOAD.PHP

require('/opt/bitnami/apps/wordpress/htdocs/wp-load.php');

// INCLUDE AND EXECUTE SCHEDULER.PHP

include('/opt/bitnami/apps/wordpress/htdocs/wp-content/themes/yeelloe/scheduler.php');

?>

When I try to include; /opt/bitnami/apps/wordpress/htdocs/wp-content/themes/yeelloe/scheduler.php:

<?php

// EXPLODE AND PARSE WP-CONTENT; FUNCTIONS.PHP

 $parse_uri = explode( '/opt/bitnami/apps/wordpress/htdocs/wp-content', $_SERVER['SCRIPT_FILENAME'] );

// LOAD WP-LOAD.PHP

require_once( $parse_uri[0] . '/opt/bitnami/apps/wordpress/htdocs/wp-load.php' );

// LOAD TEMPLATE FUNCTION

CheckFunction();

?>

Hi,

Below i have some sample code and am confused over execute(), i have the code below in a try and catch block, in the catch block i call a function i created to log any error that is caught in catch block to a .txt file.

I then looked online and it seems that i should do an if statement check on execute to ensure it executed the query, the part that confuses me if the execute failed i thought it would be caught in the catch block but it seems that is not the case.

To explain better i have commented the code in depth on the area that i am confused about.

Any help in making me understand would be great. I have not included all code above try and catch to keep things simple

Code: [Select]
<?php

try {
// connect to database
$dbh = sql_con();

// checke if username exists on users table or users banlist table
$stmt = $dbh->prepare("
SELECT
  users.user_login
FROM
  users
WHERE
  users.user_login = ?
UNION ALL
SELECT
  users_banlist.user_banlist
FROM
  users_banlist
WHERE
  users_banlist.user_banlist = ?");

// this is the part i am confused with, why is it i would use an if statement on execute() ?
// i thought using a try and catch block any errors would be caught in the catch block.
// using an if statement to check if execute() worked, i thought if execute failed it would
// be handled by the catch block, i mean in my exmaple code here, what could cause the execute to fail ?
// and why if execute failed it would not be caught by catch block ?
// i am looing at exmaple online and i am reading different things and its all confusing me


// execute query
if(!$stmt->execute(array($username, $username))){
echo 'something went wrong .. ';
} else {
// execute worked
}
} // if any errors found log them  in my ExceptionErrorHandler() function and display friendly message
catch (PDOException $e) {
// this function catches an error and logs them to file
ExceptionErrorHandler($e);
require_once($footer_inc);
exit;
}
}

?>

Thanks or any help!

Hi Guys,

I have the following script which works fine for GoogleMaps
Code: [Select]
<?php
require'EasyGoogleMap.class.php';
$gm = & new EasyGoogleMap("rYvyXhRFPYW5tkV_IE5hWxecUidHAYjJhBSp59xzQuNZcoxNYCiaum4_Xb66Fw");
$gm->SetMarkerIconStyle('STAR');
$gm->SetMapZoom(10);
$gm->SetAddress("10 market st, san francisco");
$gm->SetInfoWindowText("This is the address # 1.");

$gm->SetAddress("Manila, Philippines");
$gm->SetInfoWindowText("This is Philippine Country.");
$gm->SetSideClick('Philippines');

?>
<html>
<head>
<title>EasyGoogleMap</title>
<?php echo $gm->GmapsKey(); ?>
</head>
<body>
<?php echo $gm->MapHolder(); ?>
<?php echo $gm->InitJs(); ?>
<?php echo $gm->GetSideClick(); ?>
<?php echo $gm->UnloadMap(); ?>
</body>
</html>

I've now coded that static page to take the following, and within the GoogleMaps database field entered in exactly the following $gm->SetAddress("10 market st, san francisco");
$gm->SetInfoWindowText("This is the address # 1.");

$gm->SetAddress("Manila, Philippines");
$gm->SetInfoWindowText("This is Philippine Country.");
$gm->SetSideClick('Philippines');


Code: [Select]

<?php

$maps_find = $OO_Open->newFindCommand('Maps');
$maps_find->AddFindCriterion('AccountName','xx');
$maps_result = $maps_find->execute(); 
$maps_row = current($maps_result->getRecords());
$Gdata = $maps_row->getField('GoogleMaps');

//echo $Gdata;
//exit;


?>

<?php
require'EasyGoogleMap.class.php';
$gm = & new EasyGoogleMap("my key");
$gm->SetMarkerIconStyle('GT_FLAT');
$gm->SetMapZoom(10);
$gm->SetMapWidth(1080); # default = 300
$gm->SetMapHeight(550); # default = 300

echo $maps_row->getField('GoogleMaps');
//eval("\$Gdata = \"$Gdata\";");

?>


<html>
<head>
<title>EasyGoogleMap</title>
<?php echo $gm->GmapsKey(); ?>
</head>
<body>
<?php echo $gm->MapHolder(); ?>
<?php echo $gm->InitJs(); ?>
<?php echo $gm->GetSideClick(); ?>
<?php echo $gm->UnloadMap(); ?>
</body>
</html>



Is there way of getting the $maps_row->getField('GoogleMaps'); command to behave as if it was php (when I echo it, it does display the code as text). I'm not using the FileMaker db to store the code, I thought eval function was the answer but not had much luck.

Many Thanks for the advice

Jalz

How can I get this form to execute?  Do I need to use a hidden input or something?

Code: [Select]
<form action="partnerRequest.php" method="post">
<a href="" title="Become Associates" id="becomeassoc" class="mll">
<span class="f_right">Become Associates</span><img src="../assets/img/becomeassoc.jpg" class="mrs vmiddle" alt="Become Associates" />
</a>
</form>

I need to execute a program in the command prompt in windows using php, which php functions would be best to do this? and would i need to set any type of permissions to be able to use them?

Hello, I've been assigned the task of creating an internal site for our office that has links to all the websites we use as well as the applications we use.

I'm very comfortable using php with mysql for handling forms and displaying database information but I'm not sure how to go about this.

So my question is, is there anyway I can use php to open an exe file?

Hi,

I am trying to create a PHP script ("repair-correct.php") in order to run some CLI commands without using PuTTy - The CLI commands are needed to repair/correct the execution of a web application named Mautic.

Shared web host account with PHP 7.0

URL: https://www.myserver.com

Mautic directory: https://www.myserver.com/mautic

 

What I want to do is:

Step1: Change ownership of files and folders
The files and folders could be owned by the wrong user. Thus I continue to experience errors even with the correct file and folder permissions. This is because the user may not have the permission (as they are not the owner of the files/folders) that is required.

To find out which user Apache is running as, I want to execute the following command and take note of the first entry in the line which is returned:

ps aux | grep apache2

I want to use this information to find the groups with the following command

groups apache_user

(where apache_user is the user I identified from the first step above)

To reset the ownership of files and folders, I want to use the following command (ensuring that I replace apache_user and apache_group with the values identified in the steps above):

sudo chown -R apache_user:apache_group

With this command I want to change ownership, using the -R flag which means recursively - including all files/folders within that location.

 

Step 2: Reset the file and folder permissions
Some of the file and folder permissions are incorrect, I want to run the following commands to reset them

find . -type f -not -perm 644 -exec chmod 644 {} +
find . -type d -not -perm 644 -exec chmod 755 {} +
chmod -R g+w app/cache/ app/logs/ app/config/
chmod -R g+w media/files/ media/images/ translations/
rm -rf app/cache/*

 

Thanks so much for your help in solving this problem!

 

Best,

Tony

 

 

 

 

Hi,
Im starting to write a simple (so I thought! ) project at work, I have no problems with the HTML, CSS or even the php mysql setup, but I am struggling with a simple piece of code!

I have a list box, that populates from a table column using the following code:

Code: [Select]
<?php
function select(){
    $query="SELECT appname FROM kpe_apps";
    $result = mysql_query($query);
    echo '<select name="item" onchange="this.form.submit()">';
    while($nt=mysql_fetch_array($result)){
         echo '<option value="' . $nt['id'] . '">' . $nt['appname'] . '</option>';
    }
    echo '</select>';
}
?>

I then called the function on the page I needed. which works fine,
now all I need is whatever is selected in the listbox other columns in the same table relating to the selected item are seen.

I just cant seem to do it, loads of people are using jquery and other code, surely this can be done in php?

any help would really be appreciated..
Many Thanks

MOD EDIT: code tags fixed, linefeeds and indenting added.

I am running Apache with the PHP module installed on Debian Linux.  My goal is to launch a binary in a background process and then feed it commands via fifo.

The binary I need to launch has a config file which lives in the home directory of the apache user (in my case the user name apache is started with is www-data). www-data's home dir was the web root so I changed it to /home/www-data.  I also change the shell from /bin/sh to /bin/bash for www-data.

Neither of these changes are present when I load a php file from a browser.

This script:

Code: [Select]
<?php
echo "User: " . exec('whoami') . "<br>";
echo "Shell: " . exec('ps -p $$ | grep sh') . "<br>";
?>
Outputs this:

Code: [Select]
User: www-data
Shell: 9179 ? 00:00:00 sh
Also if I execute the binary it does seem to read the config file which is in the www-data users directory.  I have set the home dir and the web root to be owned by www-data and it's read and writeable.

How do I get php to execute the binary so it has access to the users home directory and uses the bash shell?
Are there any other ways to launch and control a binary on a unix system via php?

   private function _authenticate()
   {
      // if there's already an auth error
      if ( $this->_checkForMessageType('auth') )
      {
         $this->_addMessage('auth', 3);
         self::__destruct();
         return false;
      }
      $stmt = $this->_dbh->prepare("SELECT shopID FROM api_users WHERE shopID = ? AND API_key = ? LIMIT 1");
      
      var_dump($stmt->execute(array($this->_shopID, $this->_key)));
      echo $stmt->rowCount();
      // authenticate key / shop id
      if ( !$stmt->rowCount() )
      {
         $this->_addMessage('auth', 3);
         self::__destruct();
         return false;
      }
      $this->_addMessage('auth', 4);
   }


I am using PDO with MySQL driver and ATTR_EMULATE_PREPARES => true, however, when I run this code I get the output: Code: [Select]
bool(false) 0{"auth":{"3":""}}

Any ideas why PDOStatement::execute is returning false? I get no connection errors, no PDOExceptions, the db structure is correct, and there is valid data in the database.

Any help appreciated, thanks.

Hi.
I have a query that determines if user is online/offline. Works perfectly when page loads. I want to change to auto run query every X seconds.
NOTES:
- The query is on a .php page with multiple other queries.
-IF it is possible to still run the query with-in this page? or make a separate file and include in an iframe? i would like to avoid the iframe and just $output the result of query every X seconds.

Here is my $query code:

      $query = "SELECT `manager_id` FROM #__profiles_xref WHERE profileid = '$profid'";
      $onofflineid=doSelectSql($query,1);
      foreach ($onofflineid as $isonoffline){
      $profmanagerid=$isonoffline->manager_id;
      }
      
      $query = "SELECT `session_id` FROM table_session WHERE userid = '$propmanagerid'";
      $onofflinestatus=doSelectSql($query,1);
      if (count($onofflinestatus)>0)
         {
         $output['PROPSTATUS']='Online';
      } else {
         $output['PROPSTATUS']='Offline';
         }