This is a WordPress forum and your question does not seem to have anything to do with WP.
WordPress does use MySQL as the MySQL database is automatically set up for you when you install it on a server that supports PHP and MySQL. Like Leo said, I don’t see how your question exactly pertains to WordPress.
Hi – I’m not sure how else to describe it. I have a WP site. I need to add a function where I can enter property details into a form – on submitting the form it adds the data to a table in a database. I have another page ( on my WordPress site) that has a ‘search for property’ form. On submitting the query, the results are posted to a “results’ page on my WP site.
I know WP runs on a MySQL db but how do I set up this function? I can’t be the only person wanting to do this – Is there a plugin that people use?
Thanks
Jim
I could point you several ways to do this, but all will require that you have some programming knowledge.
Plugin not know state.
Well, one possibility is to create a table in the database and use the $ wpdb to insert and search data. Another possibility would be to create a unique CPT for these data, using wp_insert_post () to insert the data submitted by the form in CPT and use WordPress for search queries.
As I said, there is more than one way, and I have named above two which I think would attend, but you need a little knowledge of web development.
If you want to use basic form functionality then just use a form plugin such as Ninja Forms or Gravity Forms.