PHP - Action File Executing In Browser

Hello Friends...

I am creating a HTML webpage and connecting with MYSQL.

If the client will check the conditions, it will pass it to PHP and get values from MYSQL and print it in the webpage as a HTML table format.

Now i want to create a SAVE button and save the HTML TAble values as TXT tab demilited file.

I tried of creating a TXT file by using fopen() and write the values by using fwrite() function. But it is working only in the putty. While running the program from the browser, its not working.

Will somebody help me to solve this prob?

I also was searched for creating a TXT file from HTML table. But i wouldnt get any codes reg this....

Thanks
Rose

Hi there,

Can anybody help me to write php/javascript code which will allow users to open files directly from web browser into desktop application? Here is the specification:

I have a photo editing business with many people working in Photoshop. I am currently developing a web based application (joblist) using Javascript and PHP which should allow the photoshop designers to browse and open files/images directly from joblist/web browser into photoshop. The reason I want this instead of browsing folder is that I have a database where I store who worked on which file, when and how long it took.

The concept is that, designers will select a file and click on start, as soon as they click on start the original file will open in Photoshop and there will be an entry into database (using PHP). Once they finish the task they will close the file and click on Finish button.

My joblist application will be published in a local server and the file will be open on a local network, so when they save the file it will be saved where the source file is located in (local server). The application should work in both PC and Mac.

I have already done all other part of the application except file opening directly from browser to desktop application functionality.

Anybody can help me to write the code (PHP or Javascript) which can open the file from browser (local server) directly into desktop application e.g. PHotoshop or Illustrator?

Thank you very much I look forward to someone's real help!

Best regards
Mr. Sumon

I'm tired and want to sleep so my mistakes are getting lots now. Anybody awake that can explain my problem with the code below. 

<?

function directoryToArray($directory, $recursive) {
        $array_items = array();
        $i = "0";
        if ($handle = opendir($directory)) {
                while (false !== ($file = readdir($handle)) && $i < "3") {
                        if ($file != "." && $file != "..") {
                                if (is_dir($directory. "/" . $file)) {
                                        if($recursive) {
                                                $array_items = array_merge($array_items, directoryToArray($directory. "/" . $file, $recursive));
                                        }
                        } else {
                                        $file = $directory . "/" . $file;
                                        $array_items[] = preg_replace("/\/\//si", "/", $file);
                                        $i++;
                                }
                        }
                }
                closedir($handle);
        }
        natsort($array_items);
        return array_reverse($array_items);
}
$data = directoryToArray('images/screenshot/', TRUE);
print_r($data);
?>


What I want is for the while loop to stop after 4 hits and exit and give me the return results. But now it continue until readdir end.

I am trying to use some php code inside of an html document and it does not work. I have a script.php file that executes perfectly when I try and use it. Here is the code I am currently using:

Code: [Select]
<?php
 echo "<title>";
 echo "the Homepage!";
 echo "</title>";
?>
Any suggestions would be great.

I have the following query where $userid is about 100,000 userids separated by commas.

Code: [Select]
<?
$getpostid=mysql_query("SELECT DISTINCT post.username,post.threadid,thread.threadid,thread.forumid from post,thread WHERE post.username='$username' AND post.threadid=thread.threadid AND post.userid IN ($userid) AND thread.forumid IN ($forumids)") or die (mysql_error());
?>can i just print all the usernames from above result separated by ';' without looping it multiple times?
 
Could someone help me out how to do above in an efficient manner?

OK, so I have the following file that has database functions:

<?php

function dbDelete($param){
$conDelete = mysql_connect($url,'username','password',true);
mysql_select_db('my_db',$conDelete);
mysql_query($param,$conDelete);
mysql_close();
   if(isset($conDelete)){
   mysql_close($conDelete);
   }
}
?>

I include the above file in a session handling file.  But for some reason the new file can't call the above function as follows:
<?php
include_once 'the above stated file';
function timeOut(){
        dbDelete("DELETE FROM acctussessi WHERE acctussessi_usid = '$sessius[0]'");
   $_SESSION = array();
   setcookie(session_name(),'',time()-4200);
   session_destroy();
}
//CHECK FOR TIMEOUT REQUEST
switch($_GET['xyz']){
   case 'timeout':
   timeOut();
   header("Location: /?xyz=timedout");
   break;
   case 'logout':
   timeOut();
   header("Location: /?xyz=loggedout");   
   break;
   case 'refresh':
   dbUpdate("UPDATE acctussessi SET acctussessi_time = ".time()." WHERE acctussessi_unid ='".$token."'");   
   break;
}
?>

dbDelete isn't being called inside of the TimeOut() function.  The only way it works is by doing the following:

<?php
function timeOut(){
   $_SESSION = array();
   setcookie(session_name(),'',time()-4200);
   session_destroy();
}
//CHECK FOR TIMEOUT REQUEST
switch($_GET['xyz']){
   case 'timeout':
      dbDelete("DELETE FROM acctussessi WHERE acctussessi_usid = '$sessius[0]'");
   timeOut();
   header("Location: /?xyz=timedout");
   break;
   case 'logout':
      dbDelete("DELETE FROM acctussessi WHERE acctussessi_usid = '$sessius[0]'");
   timeOut();
   header("Location: /?xyz=loggedout");   
   break;
   case 'refresh':
      dbUpdate("UPDATE acctussessi SET acctussessi_time = ".time()." WHERE acctussessi_unid ='".$token."'");   
   break;
}
?>
But this is annoying and repetitive.  What is going on?

Thanks in advance.

Hello,

PowerShell script stored locally can never be executed after I click on button:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Testing PowerShell</title>
</head>
<body>
<?php
 
// If there was no submit variable passed to the script (i.e. user has visited the page without clicking submit), display the form:
if(!isset($_POST["submit"]))
{
    ?>
    <form name="testForm" id="testForm" action="get-process.php" method="post" />
        Your name: <input type="text" name="username" id="username" maxlength="20" /><br />
        <input type="submit" name="submit" id="submit" value="Do stuff NowNew" />
    </form>
    <?php    
}
// Else if submit was pressed, check if all of the required variables have a value:
elseif((isset($_POST["submit"])) && (!empty($_POST["username"])))
{
   // Display the alert box 
   echo '<script>alert("Welcome to Geeks for Geeks")</script>';
   
   // Get the variables submitted by POST in order to pass them to the PowerShell script:
    $username = $_POST["username"];
    // Best practice tip: We run out POST data through a custom regex function to clean any unwanted characters, e.g.:
    // $username = cleanData($_POST["username"]);
         

$psPath = "C:\\Windows\\SysWOW64\WindowsPowerShell\\v1.0\\powershell.exe";
$psDIR = "C:\\TestNew\\";
$psScript = "pscripta.ps1";
$runScript = $psDIR. $psScript;
$runCMD = $psPath." ".$runScript." 2>&1"; 

echo "\$psPath  $psPath <br>";
echo "\$psDIR  $psDIR <br>";
echo "\$psScript  $psScript <br>";
echo "\$runScript  $runScript <br>";
echo "\$runCMD   $runCMD  <br>";

exec( $runCMD,$out,$ret);

echo "<pre>";
print_r($out);
print_r($ret);
echo "</pre>";

}
// Else the user hit submit without all required fields being filled out:
else
{
    echo "Sorry, you did not complete all required fields. Please go back and try again.";
}
?>
</body>
</html>

 

Thank you for your help!

I am playing around with php but the script doesnt execute to the last point and with no error... 

 

What i am trying to do is checking the input of the user and comparing it what is in db and then applying conditions. So i have 2 files. update.php and home.php. 

home.php is my html form page and i included 'update.php' in it

In my update.php, i have these codes

 

<?php

error_reporting(E_ALL);


include_once('database.php');

if(isset($_POST['submit']))

{

$q = $_GET['q'];

$next = $q + 1;

if($q == 26)
{
echo '<h2>You have Completed the Exam.Congrats!!</h2>';


}
elseif($q <= 25){
    
$sql = "SELECT * FROM Students WHERE Email=?";
$stmt = $conn->prepare($sql); 
$stmt->bind_param('s', $_SESSION['login']);
$stmt->execute();
$result = $stmt->get_result(); $row = $result->fetch_assoc();

$Mark = $row['Mark'];


$Correct = $Mark + 1;


$Fail = $Mark + 0;

  
$sqlb = "SELECT * FROM Answers WHERE qid = ?";
$stmtb = $conn->prepare($sqlb); 
$stmtb->bind_param('s', $q);
$stmtb->execute();
$resultb = $stmtb->get_result();

$rowb = $resultb->fetch_assoc();

$Answer = $rowb['Answer'];

$Pick = $_POST['ans'];

if($Pick ==  $Answer)

{
  
  
    
  $sqld = "UPDATE Students SET Mark=? WHERE Email = ?";
$stmtd = $conn->prepare($sqld); 
$stmtd->bind_param('ss', $Correct,$_SESSION['login']);
$stmtd->execute();
$resultd = $stmtd->get_result();  


   echo "correct" ;
}

}
else

{
    
    echo 'Ate';
echo "<script type='text/javascript'>document.location.href='home.php?q='.$next.';</script>";
}

}//post submit

?>

The else statement doesnt run. so it keeps reloading the same page.   

  Also i want to ask why i keep getting the value of 2 for my $Correct variable stored on the database into column Mark for a single correct question instead of 1. What could be wrong?

Lastly, i dont want the script to run if the browser is edited by the user by changing the value of $q from the browser, because i am using get method, is there a way to do that.

Please be nice with your comments. Thanks in advance.!!!

Hey there, I recently started working on a PHP calculator, I tryed testing it out and the script is not executing... *NOTE* I found the error, I forgot to assign values to the options, all is good now

Code: [Select]
<?php
/*
Script Created by: Far Cry
Started: August 20th, 2010 10:51 PM PST
Completed
*/

$title = "Calculator";

$form = "<form action='calculator.php' method='POST'>
<table> 
    <tr>
    <td><input name='firstnumber' type='text'></td>
</tr>

<tr>
   <td><input name='secondnumber' type='text'></td>
</tr>

<tr>
   <td><select name='operation'>
       <option name='multiply'>*</option>
   </select></td>
</tr>

<tr>
<td><input name='submitbtn' type='submit' value='Calculate!'></td>
</tr>
</table>
</form>";


if ($_POST['submitbtn']){

$first = ($_POST['firstnumber']);
$last = ($_POST['secondnumber']);
$operation = ($_POST['operation']); 
}
if ($operation == 'multiply'){
echo"The answer is " . $first * $last . $form;
}
echo $form;
?>
Thanks in advance.

   In my php web program I'm trying to execute a bash shell script on the web server passing to it some parameters gathered within the program.  Ideally I wouldl ike to run this script as another user.  However, I get only a return code of "1" and no other error messages that I can see.

I tried using system and passthru as well and I'm sure the script is executable by anyone.  I've also tried the sticky bit on the target shell script.

Can someone/anyone please provide some gotcha pointers about doing this?  As can be expected, after playing with this for a week now I'm extremely frustrated and nearly exhausted my resources (except for this forum).

Ideas/suggestions please?

Thanks 

Hello all, I have been working with PHP for almost a year now, so somewhat still new to it all.

OK, this may be an Apache issue, but this involves a php script I wrote that tries to execute on pages that do NOT call it (via the include command).

So, here is a little info on how I have set things up.

I use WAMP Server to test php and MySQL code for myself (for fun and for practice) and for clients and their web sites. I run WAMP Server off of my laptop, so I can code on the go and because it is on my laptop, I decided to create a PHP & MySQL user authentication setup to keep out unwanted visitors, but allow trusted friends and fellow developers to view my work on client web sites. Let's say the authentication script is called "auth.php" and for all of the pages I want private, I include that script at the top of those pages, if the visitor is not logged in, redirect them to the login page, otherwise, let them view the page (provided their permission level is adequate).

Now, for the client web sites that I am working on, I do not call auth.php anywhere on those pages. Now, the problem I notice is that when I visited a client's web site that I am working on (on my WAMP Server), I reviewed my Apache error log and it gave me a PHP error stating the following:

Code: [Select]
Maximum execution time of 60 seconds exceeded in E:\\wamp\\www\\assets\\auth.php on line 3, referer: http://192.168.1.4/Web_Projects/NCCCLP/home.php
Of course I am able to view the client web site pages without having to login, however, the auth.php script tries to run nonetheless.

So my question is, does anyone know why this is happening and if and how I can stop it? This is not a serious (urgent) issue, but it does clog up my error logs and so forth and I prefer to have as few errors as possible. Plus, I would just like to know why and how it is running without being called.

Any and all help is greatly appreciated and if I need to provide anymore details or be more specific, please let me know.
Also, if an issue like this has already been solved and I missed that thread, please let me know and have my apologies.

Thanks in advance.

hey guys im sure this is possible im wondering how a user can execute a mysql query by a click of a button but without the page reloading...thanks guys

Hi,

I am using cpanel, where i am want to run a php file, to delete the old records,

i used cronjob in cpanel to do this.

In time columns i have made : * * * * * to execute each and every minute the script..

In the command textbox i have made: /home/server25/public_html/auto_cancel.php


in the email box: admin_email@gmail.com


I am getting Permission denied to my email address:
The error report am getting is :

/bin/sh: /home/server25/public_html/auto_cancel.php: Permission denied

Please help me to solve this.
Thanks,

[About the code]
Basically what I have is a web page that de-codes a complex XML document, and displays it as a table.
This is working successfully.
One of the columns in the tables displays a "rank" of an object as a number (0-9).
This is working successfully.
What I did was write a code that would translate that rank number into a specified text, depending what number it was.

[The Code]
(This is only the partial code with the problem in it, the entire code of the page is very extensive.)
Code: [Select]
$RankNum = "{$Member->Rank}";
// {$Member->Rank} successfully displays the rank number on it's own. Below 'should' translate that number into the name of the rank.

if('$RankNum' == 0) { echo('test1');};
if('$RankNum' == 1) { echo('test2');};
if('$RankNum' == 2) { echo('test3');};
if('$RankNum' == 3) { echo('test4');};
if('$RankNum' == 4) { echo('test5');};



[The Problem]
All this code keeps displaying "test1" for every value in the entire column, regardless if it equaled 1 or 2 or higher... I know this has to be some simple coding mistake, but I've been sitting here for an hour trying to figure out what I had done wrong.

Thanks in advance :)

In a PHP file [php_one.php], I wrote some PHP code that contained a form.  I used ECHO to write the HTML inside of the PHP tags.

On another PHP page [php_two.php], I wanted to show the code that was used to create the first page [php_one.php].

My first effort provided an interesting result, since the PHP code was readable.  However, all HTML code was visible in its executed form.

There was an actual input field and a submit button (not the code used to produce them) in the context of my coding.

I have tried using:

file_get_contents("FILE")
$array = file("FILE")
readfile("FILE")

All results were similar and carried the same problem.

How can I view code so that even the HTML is visible as code?