PHP - Alternative For .php Tag?

Hi all - I have a PHP form which allows users to submit data multiple times - in other words then can submit multiple records into the database using the same form over and over again.  So currently how it works is once they've entered data and hit submit, the form refreshes and all fields get emptied, allowing the user to again enter more info.  My client wants some sort of confirmation that data has been entered.  I originally thought a simple pop-up/alert box saying 'Your data has been successfully entered' would do the trick since the user could then click 'ok', closing the pop-up to go about entering more data.  However I hear a lot of disagreement on using javascript pop-ups due to pop-up blockers, javascript being turned off, etc.  What alternatives exist to notify the user that their data has been submitted, while also allowing them to then continue entering more data?

thanks!
Steve
 

Is there a function which will allow me to throw the values into an array and post them into the DB as separate records? If so a little help would be appreciated!
Code: [Select]
if(empty($row))
{
//Need a better way.
$sql = "INSERT INTO phpbb_user_items
VALUES
(13, '$user_id', '0'),
(12, '$user_id', '0'),
(11, '$user_id', '0'),
(9, '$user_id', '0'),
(27, '$user_id', '0'),
(15, '$user_id', '0'),
(16, '$user_id', '0'),
(22, '$user_id', '0'),
(21, '$user_id', '0'),
(23, '$user_id', '0'),
(24, '$user_id', '0'),
(26, '$user_id', '0'),
(29, '$user_id', '0'),
(30, '$user_id', '0'),
(31, '$user_id', '0'),
(32, '$user_id', '0'),
(33, '$user_id', '0')
";
$result = $db->sql_query($sql);
}

Hey everyone,

So I'm a complete PHP noob and have very basic knowledge of PHP - everything I learn is from tutorials online. I created a website which monitors Stock Exchange data for a particular stock exchange by downloading a CSV file from the Stock Exchange's website containing all the stock data - as this is the only way this particular exchange provides its data to 3rd parties. Now, my PHP system takes this CSV file, reads it and inserts the data into a MySQL database. Then, the function of my site is that users can create alerts for particular stocks that they are watching, and my website will send them an email when the stock price of the stock that they are watching goes above or below a particular value that they specify. Simple!

However, since my MySQL database always needs the most recent version of the stock prices, the way I did this in the past was by using Cron every minute to download the file off the exchange's website, and insert the data into my database. I realise that this is quite inefficient, but my main problem is actually that the only way I can do cron every minute is by paying for my own Virtual Dedicated Server as normal shared hosting won't let me run a script that frequently.

What I am here to ask is if any of you know an alternative way that I can constantly update the price data in my database i.e. an alternative to cron. I hear that you can run PHP scripts as 'daemons' but I'm not sure how this works nor whether I can do this with normal shared hosting. I cannot afford a Virtual Dedicated server any longer and so need a solution which is compatible with normal, cheap shared hosting. Any help would be much appreciated!

So to stop third-party traffic on certain media files my site does, I did a download.php type script that just took in the media id, and found the filename and did a readfile on it for the user.

The problem is that when you start doing massive amounts of traffic with it, I think the readfile stream is taking up a lot of cpu. Is there any alternative to readfile that creates a direct link between the user and the file, instead of it having to go through the php?

I'm afraid that this is something I need to do on the server end, and not in PHP, but I figured I'd ask.

I am running a script that uses curl to fetch an image and then pass it through to a user.  It works well but  is consuming a large amount of bandwidth.

Is there another way that I could pass the url to the user directly, bypassing my host? 

I want to encode a long string, and wish to make it shorter. base64_encode is very handy but it makes the string length longer. Is there an alternative to do the encoding/decoding with shorter encoded string length? 

Is there a call_user_func_array() alternative other than eval()? With the shear genius of some of the individuals on this forum, I'd expect that if there is an alternative, someone here would know it. Any tips or insight greatly appreciated. Thanks

Background (blah blah blah)
I'm being kinda picky on efficiency and performance since I will be looking at possible hundreds of executions a request... so I'd like to avoid using the above mentioned functions since they take ~3x and ~10x longer (according to a this comment).

I have four check boxes that will determine how a search is conducted and I have retrieved the data through _POST[]

The problem I have is how can I act upon the data returned? Each of the four text boxes could independently start a search but if I use an If statement the first choice will block the rest of the options eg.
Code: [Select]
if ($clientValue == "on"){
echo "perform a search based on above";
}

Hi Everyone

Does anybody know if there an alternative to preg_match?

I cant get my head round regex so im having difficulty setting different preg matches.

Is there an easier alternative?

Thanks

Is there a way to do get_called_class for versions lower than php 5.3?

Hey guys.

I currently have my website set up 'generating' php pages, rather than simply getting data off the database. Which is silly. I have no rectified that issue but end up with ugly urls such as

http://www.worldwidelighthouses.com/Lighthouses/English-Lighthouses/Trinity-House-Owned/Lighthouse.php?Lighthouses=Beachy-Head

Whats the best way to translate that into

http://www.worldwidelighthouses.com/Lighthouses/English-Lighthouses/Trinity-House-Owned/Beachy-Head

Im hopeless with apaches mod_rewrite...

Many many thanks in advance.
Danny

I need to use something else than cURL to create the code to login to myspace accounts, I have to be able to enter postfields, Thanks

Hi
i need help with this
Code: [Select]
read -p "Enter a password" pass
if test "$pass" = "jerry"
then
     echo "Password verified."
else
     echo "Access denied."
fifi works in unix only. Is there an alternative for windows ?
Thanks in advance

Code: [Select]
if (isset($select_category) || isset($most_liked)) {
// ALL but NO OTHER
if (((($select_category == 'All') || (!isset($select_category)))) && (!isset($most_liked))) {

           
$query = "SELECT * FROM con, user WHERE con.user_id = user.user_id ORDER BY contribution_date DESC";

fetch_all ($dbc, $query);


// CATEGORY but NOT most_liked
} elseif (isset($select_category) && !isset($most_liked)) {

$query = "SELECT * FROM con, user WHERE con.user_id = user.user_id AND category = '$select_category' ORDER BY contribution_date DESC";

fetch_all ($dbc, $query);

// CATEGORY and MOST_LIKED
} elseif (($select_category != 'All') && (isset($select_category) && isset($most_liked))) {

$query = "SELECT * FROM con, user WHERE con.user_id = user.user_id AND category = '$select_category' ORDER BY likes DESC";

fetch_all ($dbc, $query);

// ALL or NO CATEGORY but MOST LIKED
} elseif ((($select_category == 'All') || (!isset($select_category))) && (isset($most_liked))) {

$query = "SELECT * FROM con, user WHERE con.user_id = user.user_id ORDER BY likes DESC";
fetch_all ($dbc, $query);

}

}

What I am basically trying to accomplish is, choose a category through a drop down list, select that category and then go through all the rows in the database and print the content out.

As of now it is working for me, I am also using a pagination script to print out everything in a table.

The problem I am having is that fetch_all function is also printing the query out together with the content. Any ideas why it does that?

Did I use this function the right way?

If you need more information let me know.

Hi folks,

I'm trying do a system like a queue, but doesn't work like i expected.

OS: Windows (IIS)

PHP: 5.2

So, let me tell you, what i'm doing.

1º Click in one button and insert the entry into database

$stmt = odbc_prepare($conn, 'INSERT INTO queue (ask_date, run_date, executed, user_id) VALUES (GETDATE(), NULL, 0, ?)');

2º After that i will run a script to check values executed = 0

    $handle = new COM('WScript.Shell');
    $handle->Run("php generate.php", 0, false);

3º Check values executed = 0 and update de column executed to 1 (generate.php)

    $sql = "SELECT * FROM queue WHERE executed=0;";
    $rsQueue = odbc_exec($conn, $sql);
    while (odbc_fetch_row($rsQueue )) {
    //code here
    }

My problem is, when i click in button it will open always new process (php.exe). (2 clicks - 2 processes; 3 clicks - 3 processes; etc..)

My ideia is, first button click execute the script (2º) but the other times if script is running, only add the content to queue table to be executed in current process.

Someone have any ideia?

Thank you!