PHP - Help Working Out How To Process Data

Hello there,

I have a script which uses the LOAD DATA LOCAL INFILE command see below:

<?php

//connect to your database
mysql_connect("localhost", "xxx", "xxx"); //(host, username, password)

//specify database 
mysql_select_db("xxx") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "LOAD DATA INFILE  '/public_html/admin/files/test-jp-stock.csv' INTO TABLE 'jpaero_stocksearch' FIELDS TERMINATED BY  ',' LINES TERMINATED BY  '\r\n' IGNORE 1 LINES";
     
if(mysql_query($query)){

echo ">> New Stock Data has now been uploaded. Database is now live and searchable.";}
else{

echo "Upload failed. Please contact support.";}

?> 

Initially I uploaded the csv file through phpmyadmin and everything worked fine - so I then used the SQL generated inside my script, changing the location to where the file actually is - however now nothing happens at all.

Any ideas on whats gone wrong, gratefully received!

Thanks,

Hey guys,

New to the forum and a newer user of PHP / MySQL.  I am having trouble with some code I've written up.  I don't seem to get any errors when running it, but it's not updating my database the way that it should.  hopefully a simple fix.  I am thinking that it must be on the MySQL side of things. 

Couple of things to start. 

My html form is comprised completely of drop down list inputs.  I'm the only user so I thought this would be the easiest approach.

Because of that I've made my PHP as follows:

Code: [Select]
<?php

$season = $_POST['season'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$time = $_POST['time'];
$event = $_POST['event'];
$game = $_POST['game'];
$buyin = $_POST['buyin'];

$connect = mysql_connect('localhost','root','') or die('can not connect');

if ($connect)
{
    echo "connected to database";
}

$db = mysql_select_db('dpl') or die('can not find database');

if ($db)
{
    echo "DPL Selected";
}

$query = sprintf("INSERT INTO events (season , month , day , year , time , event , game , buyin)
    VALUES ('%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s')",
       $season ,
       $month ,
       $day ,
       $year ,
       $time ,
       $event ,
       $game ,
       $buyin
       );

if ($query)
{
    echo "Your event has been added";
}

?>
My connection is working, my database is selected and I'm even now getting confirmation that my query is working, but when i go to check my database there are no entries in it?

any thoughts?

I've tried the drop down variables as both VARCHAR and TEXT inputs in MySQL, but I can't seem to get it to work.

Any help is greatly appreciated.

i have a form for which the data is sent to a process page via jquery like so:

Code: [Select]
jQuery.post('<?php echo $this->site_root; ?>/modules/new_post_process.php',{
        message:jQuery("#message_contents").val() } ,function(data)
        {etc...

new_post_process checks the contents of message like so:


if (empty($message) && empty($error))
    {
        $is_error = true;
        $error = 'Please Enter A Message';
    }


the problem is that it always throws this message even when the textarea isnt empty. however after the error has appeared if i submit again it goes through fine. I suppressed the error and tried and the database gets populated with an empty value which means it is indeed empty. so why does it work on the second time around? I am using CKEditor for the textarea. everything else gets submitted normally but this textarea. heres the full code:


the textarea:

Code: [Select]
<textarea cols="80" rows="10" id="message_contents"></textarea> Code: [Select]
jQuery("#new_post_form").submit(function()
    {
jQuery.post('<?php echo $this->site_root; ?>/modules/new_post_process.php',{
        user_name:jQuery("#user_name").val(),
        redirect_url:jQuery("#redirect_url").val(),
        subject:jQuery("#subject_field").val(),
        forum_id:jQuery("#fid").val(),
        topic_id:jQuery("#tid").val(),
        method:jQuery("#method").val(),
        message:jQuery("#message_contents").val() } ,function(data)
        {
            if (data == 1)
                {
                    jQuery("#process_info").removeClass().addClass("subject_okay").html("<img src=\"<?php echo $this->template_path; ?>icons/small_tick.png\" alt=\"icon\" />Redirecting...").fadeIn("slow");
                    var URL = jQuery("#redirect_url").val();
                    document.location = URL;
                }
                else
                {
                    jQuery("#reply_btn").css("visibility", "visible");
                    jQuery("#draft_btn").css("visibility", "visible");
                    jQuery("#process_info").removeClass().addClass("subject_error").html('<img src="<?php echo $this->template_path; ?>icons/small_error.png" alt="icon" /> ' + data).fadeIn("slow");
                }
        });

and the process page:


if (isset($_POST['subject']))
{
$message = $_POST['message'];

if (empty($message) && empty($error))
    {
        $is_error = true;
        $error = 'Please Enter A Message';
    }
if (empty($error) && $is_error == false)
    {
        $query = $link->prepare("INSERT INTO 
                ".TBL_PREFIX."posts
                (p_fid, p_tid, p_poster, p_name,
                p_content, p_time_posted)
                VALUES
                ('$forum_id', '$topic_id', '$user_name',
                '$subject', '$message', '".$config['time_now']."')
                ") or die(print_link_error());

echo "1";
    }
    else
    {
        echo $error.'-'.$message;
    }

Hey guys, I've hit a huge obstacle in my coding process of a script I am writing.

It is basically an uploading interface script and it works like this. I have files on my server and I want a user to click a button which fires a php script which in turn fires a bash script which IN TURN fires the uploading program (plowshare).

So to make it simple: user logs in, sees upload button. Clicks it, file starts uploading. I then want the user to see "upload initiated" and that's it. The problem is that with what I have now, the script just won't finish loading until the file has been uploaded and as a matter of fact I don't even think it is uploading anything :S

Here are the scripts:

PHP interface to call the bash script:
Code: [Select]
<?php

error_reporting(E_ALL);

function run_in_background($Command, $Priority = 0) {
if ($Priority)
$PID = shell_exec("nohup nice -n $Priority $Command 2> /dev/null & echo $!");
else
$PID = shell_exec("nohup $Command 2> /dev/null & echo $!");
return($PID);
}

function is_process_running($PID) {
exec("ps $PID", $ProcessState);
return(count($ProcessState) >= 2);
}

$file = $_GET['file'];
// Location of file relative to the index
$where = $_GET['where'];
// Absolute index location
$absolute = '/var/www/vhosts/animekyun.com/httpdocs/icarus/';
$where = $absolute . $where;
//$outfile ='log';
echo $where . $file . '<br>';

echo "<h2>The upload has been initiated!</h2>";

$ps = run_in_background("/bin/sh uploadparser.sh $file $where > $outfile");
while(is_process_running($ps))
//echo $output;
?>

Bash script to call uploading program:
Code: [Select]
#!/bin/sh
{
FILE=$1
WHERE=$2
FILENAME="/var/www/vhosts/animekyun.com/httpdocs/icarus/debug/debug_mu_$FILE"
FILENAME2="/var/www/vhosts/animekyun.com/httpdocs/icarus/debug/debug_multi_$FILE"
/usr/local/bin/plowup megaupload "$WHERE$FILE" >> "$FILENAME".txt 2>&1
/usr/local/bin/plowup multiupload "$WHERE$FILE" >> "$FILENAME2".txt 2>&1
} &

this works fine when I pass the variables as arguments in CLI

I hope i have been clear enough, it does seem rather confusing

I have a full working order form in PHP.  I process it and display it with a process page called "process.php."  Whenever this information is displayed on the web page "process.php" I also want it to send me an e-mail with all of the information that it just processed.  i.e. Checked checkboxes, text entered, etc. Whenever I try to send the contents of "process.php" to an email $message = include 'process.php';  the process page just goes through an infinite loop displaying itself over and over again instead of sending itself in an email.
Edited by AP_King7, 20 August 2014 - 10:51 AM.

I have this code:
$shell = new COM('WScript.Shell');
$shell->Run("C:\WINDOWS\system32\cmd.exe /K ".$ini['indexer']['command'], 0, false);

When it runs, it opens the command line, but then when it is done, it leaves the process open. How can I close it when the process is complete?

I have been trying to figure out how this is done?  One php file and all that changes is the name of the brand and the logo.  This has to be clickable from a menu and also if a user changes the brand name it changes to the appropriate name and logo.  Any ideas as to how this is done?  If you can guide me in the right direction or give me an example of how this is done would be greatly appreciated.  Thanks.


http://www.drivermanager.com/en/download-confirmation.php?brand=compaq&logo=

hi, is there a way to tell php to do a process again?
example:

Code: [Select]
$draft_number=rand(1, 15);

if($draft_number == 5){
START OVER AT TOP
} else {
$sql1 = "UPDATE names SET draft = '$draft_number' WHERE id = '$uid'";
$result1 = mysql_query($sql1) or die('Error, Check you fields and try again.');
}

Hi guys,

I want my application to run a triggered process based on time to execute some tasks, what is the best approach?

Thanks

This may spill over into java, just not quite sure yet!

Basically what I am trying to do, is fill a box with text, click a button which runs a function which send the text in the box via a JSON request to an external server.

The JSON works fine, I just want a way of submitting the string which hopefully doesnt involve a form, but its the only way I can think of!

Any other ideas?

I had this working, but when I try and get fancy and use AJAX the data doesn't display. I think this is a PHP problem though.

My code for the select form including AJAX code

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-GB">
<head>
<title>AJAX Example</title>
<link rel="stylesheet" type="text/css" href="Form.css" media="screen" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript">
 $(document).ready(function(){
 $("tr:odd").addClass("odd");
 });
</script>
<script type="text/javascript">
function showPlayers(str)
{
var xmlhttp;
if (str=="")
  {
  document.getElementById("DataDisplay").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
else
  {// code for IE6, IE5
  }
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("DataDisplay").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","Query.php?category_id="+str,true);
xmlhttp.send();
}
</script>
        </head>

<body>

<h1">AJAX Example</h1>

<?php
#connect to MySQL
$conn = @mysql_connect( "localhost","username","pw")
or die( "You did not successfully connect to the DB!" );

#select the specified database
$rs = @mysql_SELECT_DB ("MyDB", $conn )
or die ( "Error connecting to the database test!");
?>
<form name="sports" id="sports">
<legend>Select a Sport</legend>
<select name="category_id" onChange="showPlayers(this.value)">
<option value="">Select a Sport:</option>
<?php
$sql = "SELECT category_id, sport FROM sports ".
"ORDER BY sport";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['category_id']."\">".$row['sport']."</option>\n  ";
}
?>
</select>

</form>
<br />
<div id="DataDisplay"></div>

</body>
</html>


             
                       
 
Query.php


<?php
#get the id
$id=$_GET["category_id"];

#connect to MySQL
$conn = @mysql_connect( "localhost","username","pw")
or die( "Error connecting to MySQL" );

#select the specified database
$rs = @mysql_SELECT_DB ("MyDB", $conn )
or die ( "Could not select that particular Database");
#$id="category_id";
#create the query
$sql ="SELECT *
FROM sports
INNER JOIN players ON sports.category_id = players.category_id
WHERE players.category_id = '".$id."'";


echo $sql;

#execute the query
$rs = mysql_query($sql,$conn);
#start the table code
echo "<table><tr><th>Category ID</th><th>Sport</th><th>First Name</th><th>Last Name</th></tr>";
#write the data
while( $row = mysql_fetch_array( $rs) )
{
echo ("<tr><td>");
echo ($row["category_id"] );
echo ("</td>");
echo ("<td>");
echo ($row["sport"]);
echo ("</td>");

echo ("<td>");
echo ($row["first_name"]);
echo ("</td>");

echo ("<td>");
echo ($row["last_name"]);
echo ("</td></tr>");
}
echo "</tr></table>";
mysql_close($conn);
?>


I think the problem is either with this part in the AJAX
Code: [Select]
xmlhttp.open("GET","Query.php?category_id="+str,true);

or most likely in my Query.php code

when I wasn't using AJAX and using POST it worked fine, but adding the AJAX stuff and GET it doesn't work.

When I echo out the SQL the result is

Code: [Select]
SELECT * FROM sports INNER JOIN players ON sports.category_id = players.category_id WHERE players.category_id = ''

so the category_id is not being selected properly and that is the primary key/foreign key in the MySQL table which connects the JOIN.

I have this 3 tables users (id_user) music_styles (id_style, style) ex. (1) - (Blues) user_styles (id_user, id_style) I'm trying to create a form in which the user ($user = $_SESSION['id_user']) chooses through a multiple select the styles of preference to store them in the database using mysqli statements. If the styles prefered are selected they should be displayed in the select input later, how can i accomplish this? Thanks.

Hi all,

Newb here with a few months of PHP experience.

I'm working on a project where if a web user signs up for a 30-day trial, they need to be notified near the end of that trial--let's say 25 days--that the trial is expiring. So I need some kind of batch process that runs in the background, perhaps every night at 1am, that looks at the signup date for all trial users and compares that date to the current date. If the difference is 5 days, then that user should be sent an email.

Does anyone know how to set up a nightly batch process that like this? I'm not concerned so much with the date comparison as I am with getting a daily process to run in the background. Coldfusion has something called a Scheduled Task, but being new to PHP, I don't know what would be comparable.

Any help welcome!

Thanks...

hello,

I have this problem in running a specific command after using shell_exec or exec to execute a certain process.

The process I am running is unimrcpclient, after initialization, it expects some command to be entered in order to communicate with the mrcp server. however, passing the command as an attribute is not an option. Is there a way in PHP to execute a process, wait for initialization and then pass the command automatically?

thank you.

this retrieves data from a webservice at Library of Congress
for example this here
http://www.loc.gov/standards/sru/simple.html

What I want to do is process the XML? into a string of usable text to put in a mysql database
Am I getting XML back or what?
save it and run it to see. In firefox, it shows xml headers, in chrome just the text elements.
<?PHP
//from here http://www.devshed.com/c/a/PHP/Fetching-Search-Results-as-Serialized-Arrays-with-Yahoo-Web-Services-and-PHP-5/1/
//http://php.net/manual/en/book.simplexml.php
// example using LOC SRU Search Web Service - search results are displayed in raw XML format

try{

$request='http://z3950.loc.gov:7090/voyager?version=1.1&operation=searchRetrieve&query=dinosaur&startRecord=2&maximumRecords=5';

// trigger the http request

if(!$results=file_get_contents($request)){throw new Exception('Error requesting LOC SRU Web service');}

// display the results in XML format

header('Content-type:text/xml;charset=iso-8859-1');
echo $results;

}//end of try

catch(Exception $e){echo $e->getMessage();exit();}

$xml = simplexml_load_string($result);

print_r($xml);
//print_r ($xmlarray);

?>