michaelk46

Can't believe I missed that... Thanks

I am getting this error: Parse error: syntax error, unexpected '[', expecting ')' in C:\xampp\htdocs\Work\Store\store.php on line 154 when I run the following code: function categorySearch($sql) { $res = mysqli_query($this->conn,$sql); $this->results='<table>'; while($cRow = mysqli_fetch_array($res)) { function getCategoryName($cRow[0]) $this->results .= '<tr><td style="border: thin solid #000000;">' . $this->cat_str . '</td></tr>'; } $this->results.='</table>'; return $this->results; } Line 154 refers to this line: function getCategoryName($cRow[0]) Can anyone see what the problem is?

Thanks... I can't believe I missed that...

I am working on getting prepare and bind working and I get this error "Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\CMS\new\cms.php on line 84" when I run the following code... private function bindParameters(&$stmt, &$value_arr) { call_user_func_array('mysqli_stmt_bind_param', array_merge (array($stmt, $types), $value_arr); } Line 84 refers to the line that starts with call_user_func_array Anyone know what would be causing this problem?

Try this... echo the search string from the variable and do the search directly at the command prompt while logged in to the MySQL server. Do you get the information that you expect to get displayed on the screen? That way you know whether it's a PHP issue or a MySQL issue.

One thing I was thinking of was... The code for the form is posted below. <form enctype="multipart/form-data" action="index.php" method="post"> <div> <label for="upload">File to Be Uploaded:</label> <input name="upload" type="file" size="45"/> </div> <p></p> <div> <input type="submit" name="file_upload" value="Upload File"/> </div> </form> I originally had this script just merging the data with the database and it worked... which is why this is so frustrating. At that time, the input type was 'text'. I then modified it to move the file to a folder depending on the type of file it was. TO do that I changed the input type to 'file' along with a couple other changes. I am thinking that's the reason why this is not working currently. Is there a way to assign both text and file to the input type?

You are correct... I did a test while trying to figure this out and posted the wrong code... Here's the right code case 'csv': $destfile='C:\wamp\www\Test\Upload\Files\csv\\' . basename($_FILES['upload']['name']); $ret = move_uploaded_file($_FILES['upload']['tmp_name'], $destfile); switch ($ret) { case false: echo htmlspecialchars('Unable to move file', ENT_QUOTES, 'utf-8'); break; default: $sql="LOAD DATA LOCAL INFILE '" . $destfile . "' INTO TABLE page FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (id, caption)"; echo ($sql); mysqli_query ($link, $sql); include 'upload.html.php'; echo htmlspecialchars('File uploaded successfully', ENT_QUOTES, 'utf-8'); break; } break;

Sorry, I posted to thread....I wasn't sure how to delete this reply...

I am not sure if this is a PHP or MySQL issue so I apologize if it's in the wrong forum. I am trying to merge the data from a csv file to a MySQL Database after the file is uploaded to the server. It uploads and moves the file to the correct directory, but it just won't merge the data... Here's the code case 'csv': $destfile='C:\wamp\www\Test\Upload\Files\csv\\' . basename($_FILES['upload']['name']); $ret = move_uploaded_file($_FILES['upload']['tmp_name'], $destfile); switch ($ret) { case false: echo htmlspecialchars('Unable to move file', ENT_QUOTES, 'utf-8'); break; default: $sql="LOAD DATA LOCAL INFILE '" . ($_FILES['upload']['name']) . "' INTO TABLE page FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (id, caption)"; echo ($sql); mysqli_query ($link, $sql); include 'upload.html.php'; echo htmlspecialchars('File uploaded successfully', ENT_QUOTES, 'utf-8'); break; } break; Any help is greatly appreciated...

Again, Thank You very much... This problem and the one you helped me with before have been baffling me for a while... I knew this had to be something small... Thanks again

I am getting an error... It seems like the script is completely ignoring IF statements... When I hit submit on the search page, I get "SELECT * FROM pages WHERE searchid = and pagename = " in $sql Now if there are terms in one or both search fields, it enters the data into the correct part of the string, but it should only add "pagename =" if the pagename search field has search terms in it and "searchid =" should only come up when search terms are in Search ID field when the submit button is hit and 'and' should only come up if both search fields are populated. If there is nothing in either it should have "You must enter search terms" in $sql but I am getting the above string instead. I am not sure why...something tells me, I am missing something very small. Please help... if ($_SERVER['REQUEST_METHOD'] != "POST") { include "search.html.php"; } else { if(isset($_POST['searchid']) || (isset($_POST['pagename']))) { $sql = "SELECT * FROM pages WHERE "; if(isset($_POST['searchid'])) { $sql .= "searchid = ".$_POST['searchid'].""; } if(isset($_POST['searchid']) && (isset($_POST['pagename']))) { $sql .= " and "; } if(isset($_POST['pagename'])) { $sql .= "pagename = ".$_POST['pagename']." "; } } else{ $sql .= "You must enter search terms"; } include "searchres.html.php"; }

Thank You very much, that fixed it...

Can't figure this out... I keep getting this error: "Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\wamp\www\Work\Storage\index.php on line 36" Line 36 is $sql .= "'searchid' = ($_POST['searchid'])"; Anyone have any ideas why? if ($_SERVER['REQUEST_METHOD'] != "POST") { include "search.html.php"; } else { if(isset($_POST['searchid']) || (isset($_POST['pagename']))) { $sql = "SELECT * FROM `pages` WHERE "; } if(isset($_POST['searchid'])) { $sql .= "'searchid' = ($_POST['searchid'])"; } if(isset($_POST['searchid']),(isset($_POST['pagename'])) { $sql .= " and "; } if(isset($_POST['pagename'])) { $sql .= "'pagename' = ($_POST['pagename']) "; } else{ $sql .= "You must enter search terms"; } include "searchres.html.php"; }

I had a similar problem and it turned out to be a issue with where dreamweaver thought the file was regardless of where it actually was. I ended Up having to move the files into a seperate folder inside Dreamweaver and letting it update the pointers and then I moved back updating the pointers again, then it worked fine. Hope this helps...

Sorry to take so long to respond... I had another PHP server problem to troubleshoot. THis helped out a lot Thank You for your explanation

Hey all, I am still fairly new to PHP programming and I am trying to put together a page where you select search terms from a drop down menu and it keeps the menu at your search choice in the menu after the search. Here is the code I was suggested to use, but I am having problems understanding how it keeps the choice in the menu. I can almost understand how it works, but I need a little push to grasp it. Here is the code: foreach($options as $key => $content) { if ($key == $value) $select = ' selected="selected"'; else $select = NULL; $html .= '<option value="' . htmlspecialchars($key) . '"' . $select . '>' . htmlspecialchars($content) . '</option>' . "\n"; } Now I understand how to walk through the code, but I am having trouble understanding how it holds over the choice. THanks in advance for the help...