Good news all. It works. Photon happily sending data to the rpi access point and storing the data in a SQL database. So no client WiFi or particle cloud server required. SQL information is then displayed in a browser through the rpi. Many thanks. Code above worked perfectly. Happy to help others with specifics should they have a similar request. Thank you Rickkas7.
For reference I used the second link: