PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Tue Oct 17, 2017 1:28 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
PostPosted: Thu Sep 21, 2017 6:43 pm 
Offline
Forum Newbie

Joined: Thu Aug 10, 2017 4:48 pm
Posts: 17
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...


Top
 Profile  
 
PostPosted: Sat Sep 23, 2017 6:31 pm 
Offline
Forum Contributor

Joined: Fri Sep 05, 2008 3:34 pm
Posts: 486
Location: Victoria, BC
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!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system, Joomla and Drupal are some alternatives


Top
 Profile  
 
PostPosted: Sun Sep 24, 2017 3:19 pm 
Offline
Forum Newbie

Joined: Thu Aug 10, 2017 4:48 pm
Posts: 17
You seem to be an expert on the subject can you provide with a "how to"?


Top
 Profile  
 
PostPosted: Mon Sep 25, 2017 9:37 am 
Offline
Forum Newbie

Joined: Thu Aug 10, 2017 4:48 pm
Posts: 17
My file is in the following format

name:email: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?


Top
 Profile  
 
PostPosted: Mon Sep 25, 2017 2:31 pm 
Offline
Forum Contributor

Joined: Fri Sep 05, 2008 3:34 pm
Posts: 486
Location: Victoria, BC
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/hard-disk-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!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system, Joomla and Drupal are some alternatives


Top
 Profile  
 
PostPosted: Mon Sep 25, 2017 3:51 pm 
Offline
Moderator
User avatar

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6384
Location: Montreal, Canada
sjuaq wrote:
My file is in the following format

name:email:ip

How can i import to SQL?
table "wp_posts"

I don't know that you want that data in wp_posts. It's not a WordPress post. Give it a dedicated table.

_________________
Supported PHP versions No longer supported versions


Top
 Profile  
 
PostPosted: Tue Sep 26, 2017 2:21 pm 
Offline
Forum Newbie

Joined: Thu Aug 10, 2017 4:48 pm
Posts: 17
Adding a new table doesn't reach the scope of the search...


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Exabot [Bot], Google [Bot] and 16 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group