luminous

Sorry to be a pain perhaps you can help me further as this problem is slightly more puzzling then i first thought. Basically I run a script that makes a CSV file. Once created it returns the CSV file in the form of a header: if(!is_null($file_name)) $file_name = date('Y-m-d'); // set content type and file name then output csv content header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=\"$file_name.csv\""); echo $csv; but I just want it to save the CSV file to a disclosed location. I'm using FOPEN at the moment but this is creating a blank file: if(is_null($file_name)) $file_name = date('Y-m-d'); // set content type and file name then output csv content $date = date('M-Y'); $orderDate = 'Orders '.$date; if(!file_exists($orderDate)) { mkdir($orderDate); fopen ($orderDate.'/'.$file_name.'.csv', 'x'); }else{ fopen ($orderDate.'/'.$file_name.'.csv', 'x'); } How could I resolve this?

I've got a script that generates a a file based on data that is being updated in the database. For the sake of an example everytime the database is updated, a new file is created with the new data. Is it possible with fopen or another function to create new files with different file names from scratch?

I've been battling installing Pear on using a 2.0 Build of WAMP server with PHP 5.3.0 , Winows XP. I've managed to actually install PEAR but when I try to see if it's working (as per this link http://pear.php.net/manual/en/installation.checking.php) I get the following output : Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 650 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 697 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 757 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 786 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 914 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 1577 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 1607 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 2034 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 2087 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Registry.php on line 322 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Registry.php on line 1425 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Registry.php on line 1433 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Frontend.php on line 91 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Command.php on line 137 Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Command.php on line 154 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: honorsbaseinstall in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 180 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: installable in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 145 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: phpfile in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 212 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Notice: Undefined index: config_vars in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Installer\Role.php on line 49 Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 1026 Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\wamp\bin\php\php5.3.0\PEAR\PEAR\Config.php on line 1033 Fatal error: Class 'Console_Getopt' not found in C:\wamp\bin\php\php5.3.0\PEAR\System.php on line 76 here is the file I'm launching: <?php require_once 'System.php'; var_dump(class_exists('System')); ?> I've read the notice warnings can be solved by turning off the error reporting which means that it can't be the problem. But what I think the cause is: Fatal error: Class 'Console_Getopt' not found in C:\wamp\bin\php\php5.3.0\PEAR\System.php on line 76 I've tried to install the 'Console_Getopt' from the PEAR CLI but it tells me it's already installed... Anyone else had any trouble with this? Maybe there's a certain PHP extension I need turned on? Please help me out or I'm going to end up going into cardiac arrest !

thankyou!

Just a quick one: I have a php class that has an array in it, how do i access the values of the array inside the object? I can't seem to get a result with either echo or print_r on: $this->$arrayName[0]; Thanks in advance!

Nevermind SELECT * , ABS( DATEDIFF( NOW( ) , exhibitions.startdate ) ) AS daysDifference FROM exhibitions WHERE exhibitions.startdate > NOW( ) ORDER BY daysDifference LIMIT 1 seems to have done the jobs. Thanks for the help!

Hey Keith, That seems to of done it! Just wondering quickly would it be easy to implement so it only matches the nearest too current event with multiple dates in the future?

Hi, I have a single table which contains a value of 'startdate' how do I return a value which the startdate is closest to the current date past or future? I've tried: SELECT * FROM exhibitions WHERE (UNIX_TIMESTAMP('CURDATE')=UNIX_TIMESTAMP(exhibitions.startdate)) But this seems to return all fields with the same year. The type in the table for startdate is 'date' Thanks!

ahhh my saviour! I don't know how I didn't see that it's been a long day! Many thanks!

Here you go: Array ( [post] => Array ( [exhibitioname] => Test [startdate] => 2009-11-09 [enddate] => 2009-11-09 [Year] => 2009 [address] => Adress Test [details] => This is a test ) )

I'm passing some values into a function in the form of an array. The values pass into the function fine (i've checked this with a print_r inside the function, the values are set so I know they're being passed into the function) however when I move these values into the query they don't seem to show up // function..... $params is array being passed in function new_exhibition($params) { /// database connection... db_connect(); // print_r on $params, the array is full of values set outside the function.... print_r($params); // the query... $query = sprintf("INSERT INTO exhibitions SET exhibitioname = '%s', startdate = '%s', enddate = '%s', Year = '%s', details = '%s', address= '%s' ", mysql_real_escape_string($params['exhibitioname']), mysql_real_escape_string($params['startdate']), mysql_real_escape_string($params['enddate']), mysql_real_escape_string($params['Year']), mysql_real_escape_string($params['details']), mysql_real_escape_string($params['address'])); Each time I get back "Undefined index" error for the escaped values. I've tried printing the query string and it's empty each time so I'm at a loss to know what's going on here. Please help!

I think I worked it out! Simply use the return array then load it up with both the result value and num posts value!

Hi, I'm trying to set up a simple pagination script to display one image on the screen at a time. Basically I have a function that queries the database and returns the result after checking if mysql_num_rows == 0. I need this mysql_num_rows value to use in my pagination script to set a limit for the 'next' button. however i'm also returning a result from the same function as an array. I've tried to return the mysql_num_rows as a variable and test it outside the function (everything is routed and included correctly) but I get false with the the isset(); function everytime. What am i doing wrong?

Using TinyMCE my client will be able to embed images and flash videos into large columns of text which will obviously be printed out client side at a later date. What my question is that is it possible for these embedded links to be stored in a MYSQL database so when it's queries and brought up client side that they display as they should? I've been looking into BLOBS etc but I'm not sure if that's what I'm looking for! If you've had any experience with this issue or can help me think of a solution please!!!

Nevermind worked it out, thanks!

I currently have a routing system on my site which consists of an array of regex values. Some pages have sub pages e.g : page/subpage I currently have the ability to have routing for one page e.g : page/ which is simply '/^pagename/' What is the expression I would need to get a a subpage example at the top? Thanks!

Hey Jay, I really appreciate your help on this. I tried your version of the function and it works! I think I understand how it works too! Really appreciate it again! Cheers!

Is is still correct to run a for loop though? I tried parsing the if condition as ($row['Year'] != $year) within the for loop (i don't know how else i can extract the different details for the unqiue arrays) but i get returned a undefined offset error.

Hey i gave this ago just now with some better results however, I'm now only getting one result under each of the years and the year won't display less than 2008! function find_exhibitions() { $query = sprintf("SELECT * FROM EXHIBITIONS"); $result = mysql_query($query); $year = '2009'; while($row = mysql_fetch_assoc($result)) { for($i=0; $i < count($row) ; $i++) if($row[$i]['Year'] < 2009) { echo '<h2>'.$year.'</h2>'; echo $row[$i]['exhibitioname']; $year = $row[$i]['Year']; }else { return false; } } } can you tell me what i'm doing wrong?

Hi, I have a query which returns a list of results from a database. One of the values in the Array is a 'Year' value. What I'm attempting to do is I want to order the array by the year and echo it client-side but I want values with the same year to be displayed under the year just once. Example: 2009 Value Value Value with my current function(below) i'm getting. Example 2009 Value 2009 Value 2009 Value function exhibition_sort($artists) { if(!empty ($artists[0]['exhibitioname'])) { for($i=0; $i< count($artists) ; $i++) { if($artists[$i]['Year'] < 2009) { echo "<p class=\"Year\">".$artists[$i]['Year']."</p><br/>\n"; echo "<strong>".$artists[$i]['exhibitioname']."</strong><br/>\n"; echo "<strong>Start Date:</strong> ".$artists[$i]['startdate']."<br/>\n"; echo "<strong>End Date:</strong> ".$artists[$i]['enddate']."<br/>\n"; echo "<strong>End Date:</strong> ".$artists[$i]['gallery']."<br/>\n"; echo "<stong>Address:</strong>".$artists[$i]['Address']."</br>\n"; echo "<br/>\n"; }else { echo "<p class=\"Year\">".$artists[$i]['Year']."</p><br/>\n"; echo "<strong>".$artists[$i]['exhibitioname']."</strong><br/>\n"; echo "<strong>Start Date:</strong> ".$artists[$i]['startdate']."<br/>\n"; echo "<strong>End Date:</strong> ".$artists[$i]['enddate']."<br/>\n"; echo "<strong>End Date:</strong> ".$artists[$i]['gallery']."<br/>\n"; echo "<stong>Address:</strong>".$artists[$i]['Address']."</br>\n"; echo "<br/>\n"; } } }else { return false; } } How would I go about getting things working according to the first example? Thanks!

whoops! my mistake! that was from an amended version i was trying. The actual statement I'm using is: $query = sprintf("SELECT * from EXHIBITIONS, ARTISTS WHERE exhibitions.artistid = %s", mysql_real_escape_string($id)); i was thinking of trying to put a LIMIT = 1 in there? not sure how to apply that to just artists though?

sorry let me explain. For each exhibition i pull from the database, i get the entire artist profile with it. Let's say I have an artist with 10 exhibitions, with each array I get from the database filled with the exhibition details, I'll get all the rows from the artist profile aswell. So I'll have 10 unique exhibition arrays and for each of those 10 replicated artist profiles from the database, whereas I only want one. Thanks!

Hey, Basically I have a table of artist details, a table of exhibitions. One artist can be a part of many exhibitions, the exhibitions table has an 'artistid' column. I simply need to extract the exhibitions the artist is linked too. However, for every exhibition the aritst is linked too, it pulls up the artist details each time, but I only need the artist values once! Code: [select] function find_artists($id) { $query = sprintf("SELECT * from EXHIBITIONS WHERE exhibitions.artistid = %s", mysql_real_escape_string($id)); $result = mysql_query($query); $number_of_posts = mysql_num_rows($result); if($number_of_posts == 0) { return false; } $row = resultToArray($result); return $row; } function resultToArray($result) { $result_array = array(); for ($i = 0; $row = mysql_fetch_array($result) ; $i++) { $result_array[$i] = $row; } return $result_array; } $posts = find_artists(1); print_r($posts); also would i then go about printing it out to screen like <?php echo $artists[1]['exhibitionname'];?> please help!

It looks to me as if you haven't defined your $catagory_name variable anywhere so the contents of it is NULL and therefor echoing out nothing. Try replacing all instances of $catagory_name with $tags.

Nope, haven't changed anything with the db values. It's got to be something small but I just can't find it!