PHP - Execute Sql And Set A Session

Evening!

I've been iffing and ahhing over this and well im not too sure, hence the post.

Code: [Select]
// Redirects if there is no session id selected and echos the error on the previous page
if(!isset($_GET['get']) || ($_GET['getget'])){
header("Location: #.php?error");
}
So it should simply check if get is set if it isnt then see if getget is set?

If not redirect and show the error.

Now ive tried it and even when get/getget is set it still redirects, probably something silly. Care to share anyone?

Harry.

Just curious how other people feel about this.  I am working on an application where a lot of info is pulled from MySQL and needed on multiple pages.     Would it make more sense to...   1.  Pull all data ONCE and store it in SESSION variables to use on other pages    2.  Pull the data from the database on each new page that needs it   I assume the preferred method is #1, but maybe there is some downside to using SESSION variables "too much"?   Side question that's kind of related:  As far as URLs, is it preferable to have data stored in them (i.e. domain.com/somepage.php?somedata=something&otherdata=thisdata) or use SESSION variables to store that data so the URLs can stay general/clean (i.e. domain.com/somepage.php)?   Both are probably loaded questions but any possible insight would be appreciated.   Thanks! Greg
Edited by galvin, 04 November 2014 - 10:30 AM.

I have written a Validation class that checks to see if a file being uploaded to the server meets certain conditions. That works a treat. The next step is to actually upload it to the server and I have an Upload class that can do that. Again, that works perfectly fine.

Once the file uploads, I am passing the $location of that of that file to my DB class. The DB class is full of methods that prepare and then execute strings that are SQL queries that are required in other areas of my application. Nothing I have at the moment is suitable for just running an SQL file so I don't know what to do now..

My procedural code, that works, looks like this;

$dbh2 = new PDO("mysql:host=localhost;dbname=DB360transfer", $login_user, 
$login_password);
$sql = 
file_get_contents($path.$new_file_name);
$qr = $dbh2->exec($sql);

I'm not sure how to replicate this up in a PDO/OOP application.

My DB Class script is attached. The run_from_file code starts on line 98. I've left in the other stuff as I suspect the answer has something to do with using the $this or the self:: - but really I have no idea.   So my question is, what is the correct syntax for executing a file in OOP?   Attached Files  DB.php   2.92KB   6 downloads

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?

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,   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();

?>

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>

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

 

 

 

 

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?

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 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

I'm looking to get php to write to file when someone visits one of my sites without javascript.   From the research I've done, it seems that an css hidden, iframe within the noscript tag would work, and the php file would then write to a log.   I just want a simple tick log that increments by 1, but perhaps also lists the user-agent.   My one concern is that I want to include this same code on multiple sites, all of which could be trying to access, and write a tick to the same "no JS log". Is that going to cause problems the way php writes to files?   Can someone help me create the code that will write to this log file, that won't cause errors or problems when multiple sites/visitors could be making writes to the log?   I'm a php noob, so while I can research how to get php to write to a file and save, most of the tutorials don't mention if it would be a safe method to use, if multiple domains were trying to write to that same file, at the same time, and trying to add their own "tick" to increment the number within the flat file.   Extended help that I'm looking for is getting ticks per user-agent/search bot, so bots/web users that visit my pages, that don't run JS, could have ticks by them. eg:   Google Bot: 3 Mozilla Firefox 31.0: 15   Any help on this would be appreciated, or any flaws that you see in this type of tracking, thanks!

<?php

error_reporting(E_ALL);

$psPath = "powershell.exe";
$psDir = "C:\\wamp\\www\\ps\\";
$psScript = "SampleHTML.ps1";
$runScript = $psDir. $psScript;
$prem = "-Action enable";
$runCMD = $psPath. " " .$runScript. " " .$prem;

//var_dump($runCMD);
$output = exec($runCMD);
echo $output;

?>

Hello,   I am working on a small project to get results from powershell script by using PHP. For some reason in PHP logs I get Exec unable to fork. Above is the script I wrote to execute powershell script within php. My webserver is IIS 7, and app pool is using a domain user that has full rights for Powershell to execute and get remote server results.          

PHP is owner of image directory with "permissions 660."
Why can't PHP write to it? (a "permission denied" error is generated.)
But if I allow execute permission ("760") then it works.
Why??

My script is:

$imagePath = '../imageDirectory/'.gif';
$image = imagecreatefromstring(base64_decode($raw_image_data));
$rotate = imagerotate($image,-90,0);
imagegif($rotate,'../imageDirectory/'.gif');

Is it because the imagerotate and imagegif functions need the execute requirements to be able to monkey with the image?

Thank you.

Sub question (maybe more important than the first question):
PHP is configured to run as "user = www-data" and "group = www-data"
I am also a member of the group "www-data."
For me to be able to read and delete files in that aforementioned imageDirectory, should the imageDirectory be chown www-data:www-data ?? or chown myself:www-data ??
(both styles work)

Thank you.

How can i run this javascript command show_seasons(some_value), in php code, i mean without any action ?
I have this php code:
if ($sid == $s_id) {
   javascript:show_seasons($sid);
}
How to do that?
Thanks..