如果我在CodeIgniter中使用函数或类来生成用于存储用户信息的表，那么它是安全的还是可能的？

Question

I'm try to create my own algorithm to generate table rather than insert their data into existing table in database. I'm using WAMP Server with latest PHP, Mysql, Apache version to store my employer and employee information specially they will have one table to store Jobs information and I want to use CodeIgniter class to generate it(table) for each user (employee, employer) when their click generate their table for their job information after that their can input,update,delete, as they want to post their jobs in its table'row or cell or column.

Should I build table generator to create one table for each user to store their jobs information that is avoid Database slow down when my job table got more than 5000 rows or more than this in only one table?

Should I store my information if I need more than 5000 rows of my data into only on table in Mysql Db?

Answer 1

Generally speaking it's not good practice to dynamically create tables with PHP. Your tables will be hard to maintain in the long run. There are reasons other than security to avoid this, but yes, it is possible.

Instead of creating a new jobs table for each user, why not just create a single jobs table with a user_id row so you know which jobs belong to which users.