Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
First website
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...- LWolf
- Thread
- Replies: 2
- Forum: Linux (server)
-
Syntax?
...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 idEmployees = $id AND rDate =... -
Syntax?
...$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 * FROM `Requests` WHERE idEmployees = $id AND rDate = '$rMon'"; ...prints out this error "Catchable fatal error: Object of class PDOStatement could... -
Syntax?
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(); -
Syntax?
...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. SELECT * FROM `Requests` WHERE idEmployees = 14 AND rDate = '2015-09-07' Catchable fatal error: Object of class PDOStatement could not be converted to... -
Syntax?
...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 simply echoing a string. Why is the code stopping the iteration? This "echo"... -
Syntax?
...The question I have is does this code have a syntax error because I cannot determine the issue even when just displaying a string. echo "SELECT * FROM `Requests` WHERE idEmployees = $id AND rDate = '$rMon'"; // bombs out // above line displays this... SELECT * FROM `Requests` WHERE... -
Can't get session variable
That fixed it. I did not know you needed that on each page. Thank you. -
Can't get session variable
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... -
IE not compatible
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.- LWolf
- Post #3
- Forum: Javascript
-
IE not compatible
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...- LWolf
- Thread
- Replies: 3
- Forum: Javascript
-
Delete not working
...to get the recordset, nothing is coming back from the db. I removed both params and still get no results with... $ps2 = $pdo->prepare("SELECT * FROM Schedule2"); $ps2->execute(); $results = $ps2->rowCount(); echo "RESULTS=" . $ps2->rowCount(); There is currently 1 record in there. Why... -
Delete not working
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 =... -
Page blanks after simple elseif
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! -
Page blanks after simple elseif
...this error when running it from the host... "Fatal error: Call to a member function prepare() on a non-object in..." The code line that it is referencing is... $rows= $pdo->query("Select * From Employees"); Is there a setting on the host or does this line act differently when not run... -
Page blanks after simple elseif
It does. if () { do things... } elseif () { screen goes blank } -
Page blanks after simple elseif
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...
