Advertisement
sanjiisan

Untitled

Apr 14th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. <?php
  2. $query = "CREATE TABLE opinions (id int AUTO_INCREMENT, product_id int NOT NULL, description varchar(70), PRIMARY KEY(id), FOREIGN KEY(product_id) REFERENCES products(id));";
  3.  
  4. //poniżej zapisz zapytania dodające rekordy do tabeli
  5. $queryProduct1Opinion1 = "insert into opinions values(null, 8, \'Text\');";
  6. $queryProduct1Opinion2 = "insert into opinions values(null, 8, 'Text');";
  7. $queryProduct1Opinion3 = "insert into opinions values(null, 8, 'Text');";
  8. $queryProduct1Opinion4 = "insert into opinions values(null, 8, 'Text');";
  9. $queryProduct1Opinion5 = "insert into opinions values(null, 8, 'Text');";
  10.  
  11. $queryProduct2Opinion1 = "insert into opinions values(null, 8, 'Text');";
  12. $queryProduct2Opinion2 = "insert into opinions values(null, 8, 'Text');";
  13. $queryProduct2Opinion3 = "insert into opinions values(null, 8, 'Text');";
  14. $queryProduct2Opinion4 = "insert into opinions values(null, 8, 'Text');";
  15. $queryProduct2Opinion5 = "insert into opinions values(null, 8, 'Text');";
  16.  
  17. $queryProduct3Opinion1 = "insert into opinions values(null, 8, 'Text');";
  18. $queryProduct3Opinion2 = "insert into opinions values(null, 8, 'Text');";
  19. $queryProduct31Opinion3 = "insert into opinions values(null, 8, 'Text');";
  20. $queryProduct3Opinion4 = "insert into opinions values(null, 8, 'Text');";
  21. $queryProduct3Opinion5 = "insert into opinions values(null, 8, 'Text');";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement