Onlinestore  journey

In AD.2013

Year AD 2013, as i wrote more and more php pages, i got fed up and each time new column, i need to write another php for it.
That make me think is there advance sql in this world?. After a long search i find myself answer from SQL php admin they are using describe command each time i add new column it can query out automatically.
insearch for answer i found develpoer page in php forum and started learning how to use describe.
Not long after able to use describe command in sql i manage to implement it into product page where 10 years ago i help 1 hotmail client build an site but was later replace my power webpage builder apps.
Even client doesnt want i still love to code and m product page is now similar to php my admin page and able to get new column without rewriting php quote for each new column inserted.
so endup i make 1 customer, 1 product auto query php file and some simple add column page.

Product table

This mini iframe submit browser user agent to my database

Open in new window

Customer Table

This mini iframe show counter for 1 origin

Open in new window

 
As i went to work i stop develop and concentrate on paid job not long after i find free time to work on this online store again even if i lose to the new automatic web deployment i still keen on improving myself. like the automatic web deployment can do this how do i programme to get the same but of course payment is out of my reach so i focus on other stuff first

Account improvement

I had went to improve my account page and also learn O authorization script for facebook,microsoft and google.
I was bored so i try out hashing password and keep it in data base. But found that password verify function cannot work.
I try many things still fail and kind of lazy to learn salt and salty php new version given easy hashing function which makes me want to use it only.
Easy seems come with a bug which i search thru php manual no one mention about it.
THen i found out that when i inser that hash it is added with white space which cause password verfiy to fail. What a human mistake.

Email encryption

I manage to learn xmlhttp and i try to apply to form data and found that it is also need a trick to solve the error.
Currently i manage to send thru the data and capture in php to process normally. That tip work thanks.
I found that the return is not the same and have to use another funtion instead of readystate ? weird but since it is working well i have nothing to complaint. So next i added encryption
and a simple two step process, The message typed will be encrypted and store in sql table.
so email out will not be able to see it.
But if you paste the encrypted message into the box provided you will be able to submit to php and it will decrypt with and retrieve the correct message to be shown on webpage
But Suddenly my job caught on me and i am not free to develop it. just when i am free after few years i found my gmail is hacked as the third party password is unreliable so i stop the google third party password option and delete the access.
only today 22 mar 2024 then i recall to stop postfix from sending the email out , i totally forgot the postfix still has smtp password sending email out authorized.
i wont know what it has been hacked and keep sending out for.