PHP - Execute Script When Anchor Tag Is Clicked?

Hi guys,

I am new here, and I am a bit stuck with doing something unusual.

I want to create a script that can turn on a program (dynamips and dynagen). So far, I have tried 'exec' and 'shell_exec'. Soon I realized that apache runs the commands as 'www-data' user (apache2 in ubuntu) and it's very limited on what you can execute.

Is there any way to do that at all? What would be the best practice? I am not concerned about security as this is not a production environment...

Thanks

Hi    I've been stuck trying to execute a script for a few weeks now and I really need help.   The script is supposed to schedule social media posts via functions.php and wp-load.php but I get errors.   Can someone do me a favour?   Drop your email and I'll send you the details to connect to my database.   Thanks

Hello,
I had a web page which had sharing (share issue on facebook, twitter....) and I want to record what each user had shared. So, they will click on alink to share it. I want to call a php function when the user click on a link, whats the best method to do this?
Thanks in advance

Hi everyone, i'm trying to get it so when i visit my webpage called start.php it executes the command (/bigbrotherbot start) in the terminal which then should start the process on my linux machine.

I'm currently using this code

Code: [Select]
<?php
shell_exec('sudo /bigbrotherbot start');
?>
This script doesn't appear to do anything though. I'm very new to php and would really appreciate the help.

P.S the file bigbrotherbot is the bash script which works if i actually go to the terminal myself and type /bigbrotherbot start yet when i try to make the php do it it doesnt do anything.

any ideas?

Hi,   In reference to my first attached image, I have a form which displays two SELECT/drop-down fields (labeled "Store Name" and "Item Description".....and both of which pull-in values from two separate lookup/master tables, in addition to providing an additional option each for "NEW STORE" and "NEW ITEM").   Now, when first-run, and/or if "NEW STORE" and "NEW ITEM" are not selected from the drop-down's then the two fields in green ("New Store Name" and "New Item Name" are hidden, by means of the following code:  

<div class="new-store-container" id="new-store-container" name="new-store-container" style="display:none;">
    <div class="control-group">
        <div class="other-store" id="new_store_name">
            <?php echo standardInputField('New Store Name', 'new_store_name', '', $errors); ?>
        </div>
    </div>
</div>

  Conversely, if "NEW STORE" and/or "NEW ITEM" are selected from the two drop-down's then one (or both) of the "New Name" fields are unhidden by means of the following two pieces of code, one PHP and the second JS:    

<select class="store-name" name="store_id" id="store_id" onclick="toggle_visibility('store_id','new-store-container')">
    <?php echo $store_options; ?>
                            
    <?php
        if($values['store_id'] == "OTH")
            {
                echo "<option value='OTH' selected> <<<--- NEW STORE --->>> </option>";
            }
        else
            {
                echo '<OPTION VALUE="OTH"> <<<--- NEW STORE --->>> </OPTION>';
            }
    ?>
</select>

 

function toggle_visibility(fieldName, containerName)
{
    var e = document.getElementById(fieldName);
    var g = document.getElementById(containerName);
            
    if (e.value == 'OTH')
        {
            if(g.style.display == 'none')
                g.style.display = 'block';
            else
                g.style.display = 'none';
        }
}

  All  of that is working just fine. The problem I'm having is that when I click the "Create" button, after having left any one of the form fields blank, the two "New Name" fields are hidden again, which I don't want to happen i.e. I want them to remain visible (since the values of "store_id" and/or "item_id" are "OTH"), so that the user can enter values into one or both of them, without havng to click on the drop-down a second time in order to execute the "on-click" code.   The second attached image shows how the fields are hidden, after clicking "Create".   How can I achieve that? It would be greate if someone could cobble-up the required code and provide it to me, since I'm relatively new to this.   Thanks much.    Snap1.png   26.14KB   0 downloads    Snap2.png   149.47KB   0 downloads      

I feel like a moron asking this question as it seems to be one of the most common things done with php but I cannot find a tutorial (probably because I don't know the correct wording to search under) on this specific thing..

Anyhow.

I'm spitting out a list of the Titles of my test table like so (and its working as expected):

<?php
$posting_sql = "SELECT * FROM postings";
$posting_results = (mysqli_query($cxn, $posting_sql)) or die("Was not able to grab the Postings!");
while($posting_row = mysqli_fetch_array($posting_results)) {
echo "<li><a href='posting_details.php'>$posting_row[title]</a></li>";
}
?>

Now as you can see: <a href='posting_details.php'> I am calling a new page, and that page contains this:

<h2><?php echo "$posting_row[title]"; ?></h2>

<p><?php echo "$posting_row[description]"; ?></p>

It's no surprise it's not working (with many variations etc), but I am only familiar with using <form> GET or POST, and these of course are not form elements, so I cant seem to call them the same way.

My suspicion (and from the research data I could find) is that I need to pass values in my link: <a href='posting_details.php'> ...

I could not get it to work, but I was trying variations like: <a href='posting_details.php?get[title&get[description]]'> but it seems like I am screwing things up even more by doing this..

Anyhow. If anyone could show me a tutorial that covers this specifically or some suggestions on the best approach to this would be much appreciated..

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

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!

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

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,

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

 

 

 

 

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

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

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?