elliottdan

if…else if…PHP SQL Insert into tbl based on conditions

elliottdan replied to elliottdan's topic in PHP Coding Help

Thank you all for your help I fond the leading cause of my issue. I was indeed able to get it to work. Simply was missing a variable.

if…else if…PHP SQL Insert into tbl based on conditions

elliottdan replied to elliottdan's topic in PHP Coding Help

Let me clarify the table for you, mind you this is a temp table as well. The table is set up as 01-52 being the weeks of the year. I want to dump the info in, and than turn right back around and pull the info back out, based on the current week of the year and the next 7 weeks. The concept is I have 6 people and I want to see a forecast chart of what their next 8 weeks of working hours looks like. For example. This Weeks number = 44 Next Weeks number = 45 Week 3 number = 46 Week 4 number = 47 Week 5 number = 48 Week 6 number = 49 Week 7 number = 50 Week 8 number = 51 I do not care about weeks 01-43 or week 52 the table will show null for all of those weeks. Don't be sorry this was just an idea to see if its even possible. I'm simply trying to avoid creating more variables just to be able to chart out the data I'm after. Every thing you see will be deleted and cleaned up this is more of just a concept idea ruff sketch if you will. All of the echo's and fonts are simply there for debugging purpose.

if…else if…PHP SQL Insert into tbl based on conditions

elliottdan posted a topic in PHP Coding Help

I have a feeling that I am going about this all wrong. I am trying to insert different values into the table based on different criteria. if(!$currentWeekNumber<$a AND $EngReleaseDate == NULL){ $sql = "INSERT INTO `$tbl` (`UnitID`, `$a`, `$c`, `$d`) VALUES ('$UnitID', '$WeeklyHours', '$WeeklyHours', '$WeeklyHours')"; $conn->query($sql); echo $sql; echo " "; echo " "; var_dump($conn); echo " "; echo " "; print_r($conn); echo " "; echo " "; } else if ($currentWeekNumber>$a AND $EngReleaseDate == NULL){ $sql = "INSERT INTO `$tbl` (`UnitID`, `$b`, `$e`, `$f`) VALUES ('$UnitID', '$WeeklyHours', '$WeeklyHours', '$WeeklyHours')"; $conn->query($sql); echo $sql; echo " "; echo " "; var_dump($conn); echo " "; echo " "; print_r($conn); echo " "; echo " "; } else if ($EngReleaseDate > NULL){ $sql = "INSERT INTO `$tbl` (`UnitID`, `$EngReleaseWeek`) VALUES ('$UnitID', '$WeeklyHours')"; $conn->query($sql); echo $sql; echo " "; echo " "; var_dump($conn); echo " "; echo " "; print_r($conn); echo " "; echo " "; } The issue I am having is. It gets to the if, enters the first variable right place and skips the rest of the UnitID's . The sql is echoed correctly for the rest of the variables, for the else if's. They are just not being inserted into the table. The over all reason for this is I'm trying to create variables to be able to enter into a graph. With that said is it possible to create variables based off of an if...else if...instead of inserting them into a table, just to pull right back out, to use in the graph. Below is the overall code for the project. The only reason I am echoing everything out is to make sure it is working as it should. Thank you for any and all help and direction. This one truly has me scratching my head. { include_once('pmconnect.php'); $sql = "SELECT tblJobMaster.Engineer, tblJobMaster.SalesHandOffDate,tblUnitMaster.EngReleaseDate, tblUnitMaster.SubmittalPromise, tblUnitMaster.HandoffReply, tblUnitMaster.SubmittalComplete, tblUnitMaster.UnitID, tblUnitMaster.Hours, tblUnitMaster.EngOpsEstHours, tblUnitMaster.JobNumber, tblJobMaster.JobNumber FROM tblJobMaster LEFT JOIN tblUnitMaster ON tblJobMaster.JobNumber = tblUnitMaster.JobNumber WHERE tblJobMaster.Engineer = 'JBL' "; $result=$conn->query($sql); if ($result->num_rows==0) { echo "User not found. "; die(0); } while($row=$result->fetch_array()) { $Engineer=$row[0]; $SalesHandOffDate=$row[1]; $EngReleaseDate=$row[2]; $SubmittalPromise=$row[3]; $HandoffReply=$row[4]; $SubmittalComplete=$row[5]; $UnitID=$row[6]; $Hours=$row[7]; $EngOpsEstHours=$row[8]; echo $UnitID; echo " "; echo $Engineer; echo " "; echo "Submittal Hours = " . $Hours; echo " "; echo "Eng Ops Hours = " . $EngOpsEstHours; echo " "; $SchedOffSet = 9; echo "8 Weeks from this week = " . $SchedOffSet; echo " "; $CloseSchedOffSet = 3; echo "3 Weeks from this week = " . $CloseSchedOffSet; echo " "; echo " "; echo "Sales Hand Off = " . $SalesHandOffDate; echo " "; echo "Eng Release = " . $EngReleaseDate; echo " "; echo "Submittal Promise = " . $SubmittalPromise; echo " "; echo "Reply to sales = " . $HandoffReply; echo " "; echo "Engineer Complete = " . $SubmittalComplete; echo " "; echo " "; //Figure out the week of the year $SalesHandOffWeek = date("W ", strtotime($SalesHandOffDate)); echo "Sales HandOff Week = " . $SalesHandOffWeek; echo " "; $EngReleaseWeek = date("W ", strtotime($EngReleaseDate)); echo "Eng Release Week = " . $EngReleaseWeek; echo " "; $SubmittalPromiseWeek = date("W ", strtotime($SubmittalPromise)); echo "Submittal Promise Week = " . $SubmittalPromiseWeek; echo " "; $HandoffReplyWeek = date("W ", strtotime($HandoffReply)); echo "HandOff Reply Week = " . $HandoffReplyWeek; echo " "; $SubmittalCompleteWeek = date("W ", strtotime($SubmittalComplete)); echo "Engineer Complete Week = " . $SubmittalCompleteWeek; echo " "; echo " "; //Figure out the day of the week $SalesHandOffDayNumber = date('N', strtotime($SalesHandOffDate)); echo "SalesHandOff Day Number = " . $SalesHandOffDayNumber; echo " "; $EngReleaseDayNumber = date('N', strtotime($EngReleaseDate)); echo "EngRelease Day Number = " . $EngReleaseDayNumber; echo " "; $SubmittalPromiseDayNumber = date('N', strtotime($SubmittalPromise)); echo "SubmittalPromise Day Number = " . $SubmittalPromiseDayNumber; echo " "; $HandoffReplyDayNumber = date('N', strtotime($HandoffReply)); echo "HandoffReply Day Number = " . $HandoffReplyDayNumber; echo " "; $SubmittalCompleteDayNumber = date('N', strtotime($SubmittalComplete)); echo "Engineer Complete Day Number = " . $SubmittalCompleteDayNumber; echo " "; echo " "; //Figure out Curent week's $currentWeekNumber = date('W'); echo "This Weeks number = " . $currentWeekNumber; echo " "; $NextWeekNumber = date('W', strtotime(' + 7days')); echo "Next Weeks number = " . $NextWeekNumber; echo " "; $Week3Number = date('W', strtotime(' + 14days')); echo "Week 3 number = " . $Week3Number; echo " "; $Week4Number = date('W', strtotime(' + 21days')); echo "Week 4 number = " . $Week4Number; echo " "; $Week5Number = date('W', strtotime(' + 28days')); echo "Week 5 number = " . $Week5Number; echo " "; $Week6Number = date('W', strtotime(' + 35days')); echo "Week 6 number = " . $Week6Number; echo " "; $Week7Number = date('W', strtotime(' + 42days')); echo "Week 7 number = " . $Week7Number; echo " "; $Week8Number = date('W', strtotime(' + 49days')); echo "Week 8 number = " . $Week8Number; echo " "; echo " "; $WorkingHours = $EngOpsEstHours - $Hours; $a = $SubmittalPromiseWeek + $SchedOffSet; $b = $currentWeekNumber + $CloseSchedOffSet; $c = $SubmittalPromiseWeek + $SchedOffSet + 1; $d = $SubmittalPromiseWeek + $SchedOffSet + 2; $e = $currentWeekNumber + $CloseSchedOffSet + 1; $f = $currentWeekNumber + $CloseSchedOffSet + 2; $x=3; $WeeklyHours = $WorkingHours/$x; $tbl= "tbl".$Engineer."hours"; echo $tbl; echo " "; if(!$currentWeekNumber<$a AND $EngReleaseDate == NULL){ $sql = "INSERT INTO `$tbl` (`UnitID`, `$a`, `$c`, `$d`) VALUES ('$UnitID', '$WeeklyHours', '$WeeklyHours', '$WeeklyHours')"; $conn->query($sql); $query = $conn->query($sql); echo $sql; echo " "; echo " "; var_dump($query); echo " "; echo " "; print_r($query); echo " "; echo " "; } else if ($currentWeekNumber>$a AND $EngReleaseDate == NULL){ $sql = "INSERT INTO `$tbl` (`UnitID`, `$b`, `$e`, `$f`) VALUES ('$UnitID', '$WeeklyHours', '$WeeklyHours', '$WeeklyHours')"; $conn->query($sql); $query = $conn->query($sql); echo $sql; echo " "; echo " "; var_dump($query); echo " "; echo " "; print_r($query); echo " "; echo " "; } else if ($EngReleaseDate > NULL){ $sql = "INSERT INTO `$tbl` (`UnitID`, `$EngReleaseWeek`) VALUES ('$UnitID', '$WeeklyHours')"; $conn->query($sql); $query = $conn->query($sql); echo $sql; echo " "; echo " "; var_dump($query); echo " "; echo " "; print_r($query); echo " "; echo " "; }

Sign In

Posts

Joined

Last visited

elliottdan's Achievements

Newbie (1/5)

Reputation

if…else if…PHP SQL Insert into tbl based on conditions

if…else if…PHP SQL Insert into tbl based on conditions

if…else if…PHP SQL Insert into tbl based on conditions

Browse

Activity

Important Information