06-13-2017, 12:42 PM
What is and is not working? Your insert query to table 1 is put your query to table 2 isn't? Is it just missing some of the columns? You could set all of your columns to default of NULL so the insert won't fail and you can find out possibly where the query is going wrong.
If your table 2 query is not working, I am wondering if this is the issue: $pro_id = Input::get('newProId');
You've already defined a variable as newProId, and then you are doing it again, personally I would bypass this as you are just making more work for your script.
And updating - is this separate page, same? Is everything going to be inserted already? If so - check out the DB Class documentation in the update section:
https://userspice.com/documentation-db-class/
Best of luck and let me know if you need anything else, I will do the best I can to help!
If your table 2 query is not working, I am wondering if this is the issue: $pro_id = Input::get('newProId');
You've already defined a variable as newProId, and then you are doing it again, personally I would bypass this as you are just making more work for your script.
And updating - is this separate page, same? Is everything going to be inserted already? If so - check out the DB Class documentation in the update section:
https://userspice.com/documentation-db-class/
Best of luck and let me know if you need anything else, I will do the best I can to help!