elliotpo

And it was in fact the post_max_size. Thanks a million.

Right, thanks-- this has been helpful, I appreicate it.

Ah indeed-- it took a smaller audio file. Thanks. But do you have any idea how this could be remedied for larger files? I was only aware of the max_file_upload size line in the php.ini. There must be other places where such things are specified...? Thanks again--

When I switch the extension to .jpg nothing changes, I get the same reload. This is local. And it's true that I haven't coded any sites since re-installing my OS and the whole MAMP stack....

Apologies. I wasn't sure if this was an HTML or PHP question. The trouble is that this is the only code that is relevant-- when I say the page reloads, I mean it literally reloads and ignores any insatructions on the form-action specified page. Or never gets there. No other code comes into play. Since I can't get to any PHP I thought maybe the question belonged here.

Ah see that's the weird thing. I can't get to that point. So, let's say I have the form action directing to page X. We never get to page X: the page literally re-loads, blanking the form field in the process, and any instructions are ignored, or never found. If I then hit submit again, with the file upload form field blank, it goes to the target page and does whatever I want-- in this case giving me error 4 since there's nothing there anymore. You see what I mean? But if I go to load a JPEG, for example, it goes write to the specified page and does whatever. Hence my confusion.... Again, the max file upload size should be no trouble. I'm wondering if there's some other php.ini thing I'm neglecting, or possibly some Apache thing...? Thanks for writing.

Hi. So I've coded many a file upload form and never had any trouble. Until now. For some reason when I try to upload MP3 files, I'll hit submit and the page just reloads. Once it does so, the file upload field is once again blank. What's odd is that images and documents upload just fine. It's only audio tracks that cause the page to reload and clear. My php.ini max file upload size is at this point set to 100M, and the files I'm trying to upload are under 10M. Any ideas? Here's the form code, just to post it-- pretty basic. I'm at a loss here.... Any ideas would be appreciated. Thanks very much. <form action="test.php" enctype="multipart/form-data" method="POST"/> <input type = "file" name = "audio" /> <p><input type ="submit" name="submit" value="do it."/><p> </form>

Hi. So I've coded many a file upload form and never had any trouble. Until now. For some reason, when I try to upload MP3 files, I'll hit submit and the page just reloads. Once it does so, the file upload field is once again blank. What's odd is that images and documents upload just fine. It's only audio tracks that cause the page to reload and clear. My PHP max file upload size is at this point set to 100M, and the files I'm trying to upload are under 10M. Any ideas? Here's the form code, just to post it-- pretty basic. I'm at a loss here.... Any ideas would be appreciated. Thanks very much. <form action="test.php" enctype="multipart/form-data" method="POST"/> <input type = "file" name = "audio" /> <p><input type ="submit" name="submit" value="do it."/><p> </form>

Ah. Nevermind. Your advice was good. I didn't know how to query multiple MySQL tables at once.

Ah, I appreciate the feedback-- but the trouble is that the foreach output has to repeat X number of times. and the pic changes each time. so i'm not sure how to call items from a second array (the pics array) while the first array (the artists array) is outputting. the DIVS wind up repeating multiple times and the whole thing jumbles. the $m that's holding artist data just comes from the foreach loop instructions... Unless I'm misunderstanding your advice? Which is possible..

Hello, I can't find anything about this subject here... if I missed a relevant post, I apologize. I'm pulling search results from two MySQL tables. I then need to parse the results into a foreach loop that's also outputting DIVs Javascript-controlled DIVs. The searches are like so. find_by_sql generates an object array that aligns db table fields as values with class attributes as keys. <?php $sql = "SELECT * FROM artists ORDER BY number ASC"; $musicians = artists::find_by_sql($sql); $sql = "SELECT * FROM artistPics ORDER BY number ASC"; $mpics = artistPics::find_by_sql($sql); ?> Then the output: <div id="musicians"> <p>Musician Profiles - click to learn more</p> <div id='Accordion1' class='Accordion' tabindex='0'> <?php foreach($musicians as $m) { echo "<div class='AccordionPanel'>"; echo "<div class='AccordionPanelTab'>$m->artist_name - $m->artist_role</div>"; echo "<div class='AccordionPanelContent'><img src='' />$m->artist_bio</div>"; echo "</div>"; } ?> </div> I need to get the picture output into the img src spot. But running a foreach loop inside another screws up everything, and I can't figure any other way. I could do the processing up top and try to parse out the pics into variables I'd then just call below, but there are an indeterminate number of artists in the table at any time, and I can't figure of that's possible without knowing how many results would have to be parsed. I hope this makes some sense-- I'd appreciate any advice. Thanks so much - elliotpo

Ah I fixed it. It's embarrassing. I was trying to connect with a function __construct, and simply mistyped that method. Apologies. But thanks, since the replies were still instructive and are appreciated. Elliot

I only added the sprintf while trying to randomly trouble-shoot. But I got the same NULL error message before that. Earlier today I changed localhost to 127.0.0.1 in one of the mysql library files... I think, or one of the PHP files, I can't remember anymore; which was to address my inability to mysql to work. it fixed it-- but do i now have to change localhost in a range of other files as well? and on the page where the DB values are being given in this file structure here? does that seem like it could be relevant? thanks again

this is above the query. would this error message override the query method message if the connection was failing? or would the query message still the one to appear since that's what i called directly? sorry is these are silly questions - public function open_connection() { $this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS); if (!$this->connection) { die("databse connection failed, bzzzt " . mysql_error()); } else { $db_select = mysql_select_db(DB_NAME, $this->connection); if (!db_select) { die("database selection failed: " . mysql_error()); } } }

Hello, I'm fairly new to this, having trouble with a basic query. I can run the query in Terminal, but when I write it into PHP I get the following error message: Warning: mysql_query() expects parameter 2 to be resource, null given in (etc.) and here is the problematic line as per the error reporting: mysql_query ( 'INSERT INTO users (id, username, password, first_name, last_name) VALUES (1, \'john\', \'password\', \'john\', \'thompson\')', NULL ) it's not clear to me where that NULL is coming from. here's what i'm writing in the page i'm trying to load: $sql = sprintf("INSERT INTO users (id, username, password, first_name, last_name) VALUES (1, 'john', 'password', 'john', 'thompson')"); $result = $db->query($sql); and here's how the method is written on the page that's being included: public function query($sql) { $result = mysql_query($sql, $this->connection); $this->confirm_query($result); return $result; } Again, I can just enter the row into MySql directly and no trouble, but I can't get it to work through PHP. Any advice? I feel like something simple and glaring is at fault here, but I can't see it. Thanks so much - Elliot