I am opening an Anime video rental store in my town and will be using PHP and mySQL to handle most of the technical side.
I would like to know how I would be able to store rental information in the database.
In other words, when a person rents a video (or multiple videos), how would I store the ID numbers, rental dates, and rental types (1 night, 2 night, etc) in that renters account (each account is in a table called renterAccounts, each row being a different account).
I was thinking of storing a string of text that would be parsed with the parse_str() function, but since I can only have strings that are 255 characters long in the database, that rules that out for massive rentals.
Then I saw that crypt() function, but could not find a way to decrypt the resulting variable. (if anyone knows how to decrypt this variable, that would be greatly helpful).
My webhost does not have the major encryption functions compiled into PHP (mcrypt functions), so I can't use those.
Any help would be greatly accepted.
I would like to know how I would be able to store rental information in the database.
In other words, when a person rents a video (or multiple videos), how would I store the ID numbers, rental dates, and rental types (1 night, 2 night, etc) in that renters account (each account is in a table called renterAccounts, each row being a different account).
I was thinking of storing a string of text that would be parsed with the parse_str() function, but since I can only have strings that are 255 characters long in the database, that rules that out for massive rentals.
Then I saw that crypt() function, but could not find a way to decrypt the resulting variable. (if anyone knows how to decrypt this variable, that would be greatly helpful).
My webhost does not have the major encryption functions compiled into PHP (mcrypt functions), so I can't use those.
Any help would be greatly accepted.