Novice ask PHP how to store and query string data mysql?
I have this kind of data.
Monday
Morning: Chinese
Afternoon: Math
Tuesday
Morning: English
Afternoon: Physical
Wednesday
Morning: Sports
Afternoon: Music
Thursday
Morning: Chemistry
Afternoon: Art
Friday
Morning: History
Afternoon: Politics
How to store a string in a field in a table. How do you write grammar? How do I query after storage? How do I update the morning and afternoon values?
I remember reading such an article before,
Similar to
[{Monday: Chinese, Mathematics},{Tuesday: English, Physics},]
This way, but specifically I do not know how to write, grammar and how.
Requirements: Ability to query and update.
Ask the Prawn to guide the maze. Or give me a related article that I could learn on my own.
------Solution--------------------
$arr = Array (
' Monday ' + ' Chinese, maths ',
' Tuesday ' = ' English, physics ',
' Wednesday ' = ' Sports, music ',
' Thursday ' = ' chemistry, art ',
' Friday ' = ' history, Politics '
);
$result = Json_encode ($arr);
echo $result;//Save As Database
Remove from Database
$arr = Json_decode ($result, true);
Print_r ($arr);
