API or script for generate result from DATABASE

Yupwork

Power Member
Joined
Jan 1, 2019
Messages
516
Reaction score
235
I have database and I don't know how to show it on my WP website I don't know from where to start or how to connect this data with a table on my website
I want to create a table that show this data when a visitor click on generate, like when you search for a KW on Semrush or Moz...
The Idea is to give my visitor the ability to search into this DATABASE

I search for API that provide this service but not and also I'm searching for script that can help with it.
Any suggest guys??
 

Johnik

Jr. VIP
Jr. VIP
Joined
Sep 3, 2019
Messages
322
Reaction score
403
Website
www.tokencreator.net
I am afraid you can't do it yourself unless you can code. You will need a programmer to do such a job. Hire someone from BHW. I am sure someone can do it cheaply.
 

FatBee

Elite Member
Joined
Apr 4, 2015
Messages
3,024
Reaction score
2,917
Website
optimizewp.net
Convert is in to csv, than use any table plugin and csv importer to show it on your WP website.
That will be the easy way around.

Other than that, a custom solution is always an option, but it will take time and money.
 

Yupwork

Power Member
Joined
Jan 1, 2019
Messages
516
Reaction score
235
Convert is in to csv, than use any table plugin and csv importer to show it on your WP website.
That will be the easy way around.

Other than that, a custom solution is always an option, but it will take time and money.
You're right, I uploaded csv file to table by using premium plugin call wpDataTables and it's working but only on the desktop cause the table is big and didn't appears on the center of the page, and I'm trying to center it using CSS.
 

Yupwork

Power Member
Joined
Jan 1, 2019
Messages
516
Reaction score
235
I am afraid you can't do it yourself unless you can code. You will need a programmer to do such a job. Hire someone from BHW. I am sure someone can do it cheaply.
Yes I did and I'm afraid to tell you until this hour the cheapest price that I got is from programmer offer 100$/Hour and he estimates the whole project takes 24H from him.
 

Ran_

Junior Member
Joined
May 15, 2017
Messages
132
Reaction score
60
Yes I did and I'm afraid to tell you until this hour the cheapest price that I got is from programmer offer 100$/Hour and he estimates the whole project takes 24H from him.
$100 per hour is really expensive its not worth it. You can try searching on youtube for tutorials.
 

Yupwork

Power Member
Joined
Jan 1, 2019
Messages
516
Reaction score
235
$100 per hour is really expensive its not worth it. You can try searching on youtube for tutorials.
photo_2022-02-05_15-13-29.jpg


Can you recommend me any tutorial from Youtube??
 

Blue Panda

Jr. VIP
Jr. VIP
Joined
Jul 18, 2020
Messages
632
Reaction score
645
It doesnt take much longer than 24h for a php dev.

But 100$ per hour is crazy. Like, really crazy!

How often does the data change?
Did you look at the Jquery Datatable?

Can the users edit the data or just search inside of a table?
 

Yupwork

Power Member
Joined
Jan 1, 2019
Messages
516
Reaction score
235
How often does the data change?
Scrape data from some website to generate it
Did you look at the Jquery Datatable?
To be honest I don't know how or what kind of process of this project. all I know it's like Weather website they scrape data and save and analyze it " I THINK" next they show it on they website by using API.
Can the users edit the data or just search inside of a table?
They just can search inside of table.
 

Blue Panda

Jr. VIP
Jr. VIP
Joined
Jul 18, 2020
Messages
632
Reaction score
645
But can we use the api to get the datas?

If yes, thats fairly easy. I could do this if you open a haf. I would take 25$ per hour (thats a lot too, but i work quickly).

We have multiple ways to gather the data, but thats going to wait till you decide if you really need a freelancer or if you can handle that by yourself!

Cheers
 

Ran_

Junior Member
Joined
May 15, 2017
Messages
132
Reaction score
60
View attachment 201217

Can you recommend me any tutorial from Youtube??
Oh thats why the rates are outrageous. I believe they are working with a senior developer. You can easily ask for a lower price on free lance website, I would suggest hiring a programmer on a tier 3 country.
As a student on the IT field this is fairly easy to do. I can recommend you some videos but I think you need to have some basic understanding on databases and node js.
 

mussymmfh01

Newbie
Joined
Feb 11, 2022
Messages
2
Reaction score
0
But can we use the api to get the datas?

If yes, thats fairly easy. I could do this if you open a haf. I would take 25$ per hour (thats a lot too, but i work quickly).

We have multiple ways to gather the data, but thats going to wait till you decide if you really need a freelancer or if you can handle that by yourself!

Cheers
Hello need to talk to you privately @Blue Panda
 

luvguru69

Newbie
Joined
Dec 11, 2020
Messages
17
Reaction score
10
You need to have a full understanding of what data you want to be showed on your wordpress site. You say you want it to be displayed as a table. Is there a 1:1 correlation between the presentation table and your database table? Do you have to do some filtering on values of the table? Are you doing any aggregations? Is your api only retrieving data or do you expect to handle updates and deletes.

If you know what you want, then you can understand how many endpoints that you need. This number of endpoints should give you a better estimate for how much work is involved. The person that you talked to realizes that you have little understanding about your requirements and is throwing out huge numbers. Once you have an understanding of what you're building you'll have much better success price and product wise.
 
Top