Search results for query: *

I am setting up my first server and cannot figure out why I get "NOT FOUND. The requested URL /Mysite/login.php was not found on this server." I have the Mysite folder with 755 permissions along w/the same login.php permissions. I also have a virtual server for the folder setup and is located...

Oh crap....disregard!! It was a copy and paste error!

I was finally able to bipass the issue altogether and got through that section. However now the results are not showing correct. For example... $qTh = $pdo->prepare("SELECT * FROM Requests WHERE idEmployees = $id AND rDate = '$rThu'"); $qTh->execute(); echo "SELECT * FROM Requests WHERE...

I can remove the rDate = $rMon from the string and it does not throw an error. So if there is a value for $rMon (2015-10-05) is this not an issue of converting this string to a date (which is what the database field is)?

Sorry for the delay, life gets in the way! Ok, I have this line...304 $rMon = $startDate; which sets $rMon as a variable string. $rMon == 2015-09-28 $id == 14 (pulled from the recordset) Both $rMon and $id get displayed to the screen and neither are fields in the database. 327 echo "SELECT...

As you can see from 3 posts prior the variables are being pulled. This nested loop will iterate 7 times for the same $id.

Line 327... 327 echo "SELECT * FROM `Requests` WHERE idEmployees = $id AND rDate = '$rMon'"; That is the line I am using to error trap the code beneath it... 328 //$qMon = $pdo->prepare("SELECT * FROM `Requests` WHERE idEmployees = $id and rDate = '$rMon'"); 329 //$qMon->execute();

It is in a nested loop, the entire coding for both loops is over 200 lines. I turned on display_errors and received got an error. The first line is the sql string then the error. Oddly it appears that it is after the first iteration leading me to think that it is now the 2nd iteration...

I have a table that loops through users in a dept. Currently there are 3 users in the department giving me 3 iterations through the loop. The above string stops that loop given only 1 iteration. This is odd because echo "SELECT * FROM `Requests` WHERE idEmployees = $id AND rDate = '$rMon'" is...

I am trying to grab records from a 'Requests' table by a date using an $id and $rDate variables. When the code is commented out the program works normally without grabbing the records. The problem is once the code, even just echoing a string, stops the display halfway through another loop...

That fixed it. I did not know you needed that on each page. Thank you.

This is my first time using session variables and I thought they are accessible throughout the site if they are set. I set my $_SESSION['user'] on my login page and but cannot read it once it gets to the next main page. The program is not throwing any errors. Login_chk.php...

It was late when i was designing the section. If i change names will my code work in IE? Or do i have to change the code also? What i have works in Firefox.

I nvr use IE and do not know where the issue is coming in. The code I have all uses variable variables for form names. For example I have the user id followed by an "_" followed by something like hMon. The result is "1_hMon". When the onclick triggers the code will calculate the hours. This...

I changed the $_GET and it worked! I am missing simple things. Maybe you can help me out again :) I decided to change the table I was working with and started with copying the code to modify. I have a query that had 2 params to get the recordset, nothing is coming back from the db. I...

I have tried about 15 different ways to delete a record yet this code does not delete but also does not throw an error. if ($_GET['pg']=="staff" && $_GET['rec']=="x_del"){ $id_to_delete = $_GET['id']; $sql = "DELETE FROM `Employees` WHERE `idEmployees` = :idEmployees"; $stmt =...

Yep...I gotta stop programming late at night! My last post I discovered that the problem was in my db_include_local.php file. I forgot to remove the "_local". Thanks for the post, it reminded me of this!

It turns out that copy and paste is not all that it is cracked up to be! I had a space between my ? and the > tags. I rebuilt the section and found it. I do have a new problem...the page works locally but when I upload it to the host I get this error when running it from the host... "Fatal...

It does. if () { do things... } elseif () { screen goes blank }

My page is doing both view/edit with record maintenance at the top. Everything was fine until I started the edit section. I have basic code to set select boxes but that was it. I put in the main code and the screen goes blank. So I stripped it down to a basic elseif statement. The page...