Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `proposals` (
- `id` int(11) NOT NULL,
- `email` varchar(200) NOT NULL,
- `item` int(11) NOT NULL,
- `desc` varchar(100) NOT NULL,
- `sess` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `bids` (
- `id` int(11) NOT NULL,
- `proposal_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `amount` double NOT NULL,
- `session_code` varchar(255) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- CREATE TABLE `users` (
- `id` int(11) NOT NULL,
- `First_Name` varchar(200) DEFAULT NULL,
- `Last_Name` varchar(200) DEFAULT NULL,
- `role` varchar(200) NOT NULL,
- `Mobile_No` int(11) DEFAULT NULL,
- `Membership_Start` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `Address` varchar(255) DEFAULT NULL,
- `Post_Code` varchar(255) DEFAULT NULL,
- `email` varchar(50) DEFAULT NULL,
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `drivers` (
- `id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `verified` varchar(255) NOT NULL,
- `dealno` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- $query = $this->Bids->find()
- ->contain([
- "Users",
- "Drivers",
- "Proposals"
- ])
- ->matching("Proposals", function($q){
- return $q->where(["proposals.id" => $id ]);
- });
- $bid = $this->paginate($query);
Add Comment
Please, Sign In to add comment