Hello,
I have a wordpress instalation that i would like to modify but i don't know how.
Basicaly is a wordpress instalation that i want to use the internal search engine to query a mySQL or MariaDB database and show results to the user. This database needs a importation of a sql file and an excel formated file. I want to import those 2 databases to the main database from wordpress and make them accessible on the search engine format.
Does it require much work or can it be done instantly?
Thanks for all...
Adding data for searching in a database using Wordpress
Moderator: General Moderators
Re: Adding data for searching in a database using Wordpress
excel formatted data is not in the database so using example.com/s="find it" will not catch it
Hardcore Games™ Legendary is the Only Way to Play™
My site is powered by LAMP
My site is powered by LAMP
Re: Adding data for searching in a database using Wordpress
You seem to be an expert on the subject can you provide with a "how to"?
Re: Adding data for searching in a database using Wordpress
My file is in the following format
name
ip
How can i import to SQL?
table "wp_posts"
The method that did convert was changing the : to , and then convert with https://sqlizer.io/
But the wp install corrupted.
Any solutions?
name
How can i import to SQL?
table "wp_posts"
The method that did convert was changing the : to , and then convert with https://sqlizer.io/
But the wp install corrupted.
Any solutions?
Re: Adding data for searching in a database using Wordpress
if you convert the excel data into some table and import it into a table on WP, then the database can find the details.
Excel can also be embedded into a WP article, but the search capability is limited to text with the embedded object
https://linux-guru.azurewebsites.net/ha ... -survival/
at the bottom of the article there are 3 posts with embedded excel charts, linked from a bulleted list
Excel can also be embedded into a WP article, but the search capability is limited to text with the embedded object
https://linux-guru.azurewebsites.net/ha ... -survival/
at the bottom of the article there are 3 posts with embedded excel charts, linked from a bulleted list
Hardcore Games™ Legendary is the Only Way to Play™
My site is powered by LAMP
My site is powered by LAMP
Re: Adding data for searching in a database using Wordpress
I don't know that you want that data in wp_posts. It's not a WordPress post. Give it a dedicated table.sjuaq wrote:My file is in the following format
name:email:ip
How can i import to SQL?
table "wp_posts"
Re: Adding data for searching in a database using Wordpress
Adding a new table doesn't reach the scope of the search...