|
Lines 238-250
$query = '
Link Here
|
| 238 |
INSERT INTO creator_batches |
238 |
INSERT INTO creator_batches |
| 239 |
(batch_id , item_number, borrower_number, |
239 |
(batch_id , item_number, borrower_number, |
| 240 |
timestamp, branch_code, creator) |
240 |
timestamp, branch_code, creator) |
| 241 |
VALUES (?,?,?,?,?,?)'; |
241 |
VALUES (?,?,?,NOW(),?,?)'; |
| 242 |
$insert_sth = $dbh->prepare($query); |
242 |
$insert_sth = $dbh->prepare($query); |
| 243 |
$insert_sth->execute( 11, $item_number1, $borrowernumber1, 'now()', $library1->{branchcode}, 'Labels' ); |
243 |
$insert_sth->execute( 11, $item_number1, $borrowernumber1, $library1->{branchcode}, 'Labels' ); |
| 244 |
|
244 |
|
| 245 |
$insert_sth->execute( 12, $item_number2, $borrowernumber2, 'now()', $library2->{branchcode}, 'Labels' ); |
245 |
$insert_sth->execute( 12, $item_number2, $borrowernumber2, $library2->{branchcode}, 'Labels' ); |
| 246 |
|
246 |
|
| 247 |
$insert_sth->execute( 12, $item_number3, $borrowernumber3, 'now()', $library3->{branchcode}, 'Labels' ); |
247 |
$insert_sth->execute( 12, $item_number3, $borrowernumber3, $library3->{branchcode}, 'Labels' ); |
| 248 |
|
248 |
|
| 249 |
########################################################### |
249 |
########################################################### |
| 250 |
# Testing Subs |
250 |
# Testing Subs |
| 251 |
- |
|
|