Jim R

Evidently mixing name and positional placeholders is frowned upon. Sitting now with this code: $pid = $con->prepare("SELECT id FROM a_players WHERE nameFirst = ? AND nameLast = ? AND schoolID = ?"); $pid->bindparam($fname,$lname,$schoolID); <-- line 59 With $pid->execute(); in the FOREACH loop Getting this error:

It is, but it has been working for other queries/prepares. Everything has worked up to this point. I can set up a PDO connection if you think it will matter. $player = $con->prepare("INSERT INTO a_players(schoolID,nameFirst,nameLast,feet,inches,grade,position,varsity) VALUES (?,?,?,?,?,?,?,?)"); $player->bind_param('ssssssss',$schoolID,$fname,$lname,$feet,$inches,$grade,$position,$varsity); $pid = $con->query("SELECT id FROM a_players WHERE nameFirst = :fname AND nameLast = :lname AND schoolID = :schoolID"); $roster = $con->prepare("INSERT INTO a_rosters(schoolID, playerID, uniform, varsity, season) VALUES (?,?,?,?,?)"); $roster->bind_param('sssss', $schoolID, $playerID, $uniform, $varsity, $season); $player and $roster work for how they're currently written. Just need to get the playerID out of $player to use in $roster. Remember, I had it working to get the most recently added ID. I had the wrong command but was close.

The above is just in lieu of a subquery in the $player statement.

I"m not really throwing code. That's just going back to what was working...before I realized I needed to playerID of previously entered players and not just the new ones. I've tried the $con->query version. I've tried a lot. Not sure why the query isn't providing a value. Earlier, I accidentally echoed the SELECT with the variables $fname, $lname and $schoolID, and it echoed the correct values. It literally printed "SELECT id FROM a_players WHERE nameFirst = 'Joe' AND nameLast = 'Smith' and schoolID = 44" Right now I have this: boolean error.

This didn't insert any data, and those variables have been up there the whole time. Check page 2. include("/path/to/con.php"); if(isset($_POST['submit'])) { $schoolID = $_POST['school']; $varsity = $_POST['varsity']; $season = $_POST['season']; // This uploads it into the Rosters table $player="INSERT IGNORE INTO a_players (nameFirst,nameLast,feet,inches,schoolID,grade,varsity) SELECT nameFirst , nameLast , feet , inches , school_id , grade , varsity FROM temp_csv"; $roster="INSERT IGNORE INTO a_rosters(schoolID, playerID, uniform, varsity, season) SELECT t.schoolID, p.playerID t.uniform, t.varsity, t.season FROM temp_csv t JOIN a_players p ON t.nameFirst = p.nameFirst AND t.nameLast = p.nameLast AND t.schoolID = p.schoolID";

So this works with one exception. It doesn't get the playerID as needed. $player = $con->prepare("INSERT INTO a_players(schoolID,nameFirst,nameLast,feet,inches,grade,position,varsity) VALUES (?,?,?,?,?,?,?,?)"); $player->bind_param('ssssssss',$schoolID,$fname,$lname,$feet,$inches,$grade,$position,$varsity); $roster = $con->prepare("INSERT INTO a_rosters(schoolID, playerID, uniform, varsity, season) VALUES (?,?,?,?,?)"); $roster->bind_param('sssss', $schoolID, $playerID, $uniform, $varsity, $season); foreach ($_POST['uniform'] as $k => $uniform) { $fname = $_POST['nameFirst'][$k]; $lname = $_POST['nameLast'][$k]; $feet = $_POST['feet'][$k]; $inches = $_POST['inches'][$k]; $grade = $_POST['grade'][$k]; $position = $_POST['position'][$k]; $name = "$fname $lname"; $slug = strtolower("$fname-$lname"); $taxonomy = "post_tag"; $player->execute(); $roster->execute(); echo $playerID; <-- just to check as we go Need to figure out $playerID

I had to change columns to fit, table names. You said it wasn't what you sent instead of just showing me I had a t instead of a p. So I stripped out other code and just applied what you typed. I don't know why you went away from what was working, when what I need instead of insert_id was any id. Even when this method wasn't throwing an error, it wasn't inserting the rows. So I stripped it back just what you typed outside of changing the table names and getting rid of the column level.

include("/path/to/con.php"); if(isset($_POST['submit'])) { $schoolID = $_POST['school']; $varsity = $_POST['varsity']; $season = $_POST['season']; // This uploads it into the Rosters table INSERT IGNORE INTO a_players (nameFirst,nameLast,feet,inches,schoolID,grade,varsity) SELECT nameFirst , nameLast , feet , inches , school_id , grade , varsity FROM temp_csv; INSERT IGNORE INTO a_rosters(schoolID, playerID, uniform, varsity, season) SELECT t.schoolID, p.playerID t.uniform, t.varsity, t.season FROM temp_csv t JOIN a_players p ON t.nameFirst = p.nameFirst AND t.nameLast = p.nameLast AND t.schoolID = p.schoolID; }

I see now, but that doesn't address the error I received and still received after changing the t to p.

I had to alter the table names, remove the level column. INSERT IGNORE INTO a_players (nameFirst,nameLast,feet,inches,schoolID,grade,varsity) SELECT nameFirst , nameLast , feet , inches , school_id , grade , varsity FROM temp_csv; INSERT IGNORE INTO a_rosters(schoolID, playerID, uniform, varsity, season) SELECT t.schoolID, t.playerID t.uniform, t.varsity, t.season FROM temp_csv t JOIN a_players p ON t.nameFirst = p.nameFirst AND t.nameLast = p.nameLast AND t.schoolID = p.schoolID;

This is what I had for what you posted, but it didn't insert the data: (you originally had level and varsity as columns. It's just varsity. I changed level to varsity to avoid a future issue) $players = " INSERT IGNORE INTO a_players (nameFirst,nameLast,feet,inches,schoolID,grade,varsity) SELECT nameFirst , nameLast , feet , inches , school_id , grade , varsity FROM temp_csv;"; $roster = "INSERT INTO a_rosters(schoolID, playerID, uniform, varsity, season) SELECT t.schoolID, t.playerID t.uniform, t.varsity, t.season FROM temp_csv t JOIN a_players p ON t.nameFirst = p.nameFirst AND t.nameLast = p.nameLast AND t.schoolID = p.schoolID";

Getting this error now: Current code: $player = $con->prepare("INSERT INTO a_players(schoolID,nameFirst,nameLast,feet,inches,grade,position,varsity) VALUES (?,?,?,?,?,?,?,?)"); $player->bind_param('ssssssss',$schoolID,$fname,$lname,$feet,$inches,$grade,$position,$varsity); $playerID = $con->prepare("SELECT id FROM a_players WHERE nameFirst = '" .$fname. "' AND nameLast = '" .$lname. "' AND schoolID = " .$schoolID. ""); $roster = $con->prepare("INSERT INTO a_rosters(schoolID, playerID, uniform, varsity, season) VALUES (?,?,?,?,?)"); $roster->bind_param('sssss', $schoolID, $playerID, $uniform, $varsity, $season); This is in the FOREACH LOOP: $player->execute(); $playerID->execute(); $roster->execute(); <-- line 90

But it didn't insert any rows.

I tried this: $playerID = $con->prepare("SELECT id FROM a_players WHERE p.nameFirst = :fname AND p.nameLast = :lname AND schoolID = :schoolID"); $playerID->execute(['fname' => $fname, 'lname' => $lname, 'schoolID' => $schoolID]); $playerIDget = $playerID->fetch(); Same error. Does the boolean aspect of that error mean I'm not getting any results? I know it's recognizing the variables because I'm echoing them out.

I also tried adding fetch(): $playerID = $con->query("SELECT id FROM a_players WHERE p.nameFirst = '" .$fname. "' AND p.nameLast = '" .$lname. "' AND schoolID = " .$schoolID. "")->fetch(); But it threw an error.

I'm saying when I figured out I was missing how to get the playerID of previously entered players, I was looking at subqueries and trying to figure out how to do that in what you provided earlier, which was otherwise working very well. I was trying this: $player->execute(); $playerID = $con->query("SELECT id FROM a_players WHERE p.nameFirst = '" .$fname. "' AND p.nameLast = '" .$lname. "' AND schoolID = " .$schoolID. ""); $roster->execute(); echo $playerID; <-- this is here just to see if playerID is being passed. So far, no. I'm not getting any errors. 🙃

That would be this code: $roster = $con->prepare("INSERT INTO a_rosters(schoolID, playerID, uniform, varsity, season) VALUES (?,?,?,?,?)"); $roster->bind_param('sssss', $schoolID, $playerID, $uniform, $varsity, $season);

What we had before was working, other than not getting the playerID of players already entered in a_players. I didn't necessarily know how to make the insert / select query align with the bind_param.

$players = " INSERT IGNORE INTO a_players (nameFirst,nameLast,feet,inches,schoolID,grade,level,varsity) SELECT nameFirst , nameLast , feet , inches , school_id , grade , level , varsity FROM temp_csv;"; $roster = "INSERT INTO a_rosters(schoolID, playerID, uniform, varsity, season) SELECT t.schoolID, t.playerID t.uniform, t.varsity, t.season FROM temp_csv t JOIN a_players p ON t.nameFirst = p.nameFirst AND t.nameLast = p.nameLast AND t.schoolID = p.schoolID"; This is what I have, just renaming the table names. It didn't input the single entry I submitted.

This isn't working on what is coming from the form. I don't see how it could, since I'm not uploading a .csv file.

How does that handle the arrays being created?

I still don't see how it handles the array, and it won't add duplicates the Player Table anyway, because I have a duplicate key set up. The issue was just getting the playerID from the players already in the Player Table vs. insert_id. It was inserting the player to the Roster Table, but it was passing the playerID as 0 since insert_id wasn't 'used' on that row, and I didn't have anything in there to go get it. Changing gears on how to handle it isn't my strong suit. 😉

Get rid of the $player = $con->prepare and $player->bind_param lines? I'm thoroughly confused as to how it will handle the arrays being sent.

I have to do a separate INSERT from from temp_csv to Player Table, right? Especially since (from what I've read) the load data local infile doesn't input directly into multiple tables.

I have to do a separate INSERT from from temp_csv to Player Table, right? Especially since (from what I've read) the load data local infile doesn't input directly into multiple tables.