Setting up MySql data base with hyperlinks in data fields
Autor: Derek K.
Visited 1230,
Followers 1,
Udostępniony 0
I am trying to build a data base in order to compare service levels and service costs. Cannot find anything already built that would allow me to do what I want so I was thinking of MySql and using the data base viewer in WebsiteX5 Pro. The issue is that I can build the comparative table but the software provided by my host company doesn't seem to allow me to import data from a CSV file and add a hyperling to a field. Does anyone have a solution for this.
Thanks
Derek
Posted on the
You can always do it manually.
You can add links, images and so.
What software do you have for the database?
Who is your provider?
Would it be possible for you to have ODBC connection to your database?
You could also use a csv-viewer that is able to show links.
An example here : http://derekeder.github.io/csv-to-html-table/
The viewer can easily be integrated in X5 - example here : http://eksempelsite.dk/sparta02/bullet-list---kopier4.html#Anchor03
Or yoy could use a database tool - but that will maybe be some over the top.
Autor
i am using the data base software from Ionos and phpMy Admin. I am not into programming as such and really struggling with phpMyAdmin. Is there easier software out there that will do what I want.
Thanks
Derek
With phpMyAdmin it should be possible to make an import. And the import could be from a csv file.
Autor
Thanks John. Your second answer seems to provide the solution, I just need to do some reading and see if I can work it out. I have imported a CSV into phpMyAdmin but I cannot see how you can put any hyperlinks into a table.
Thanks
Derek
You make the link by putting in something like this :
<a href="url">link text</a>
The field with the link should be of type varchar and the length should be long enough to hold the full content.
If you could have very long url's you could set the length to 500.
Try to make an import - be sure that the target field can hold the values from the source fields.
You could eventually try with a simple import ( without links ).
When you have this to function you could manually make a link in one of the records.
When you have this to function you could import a file in which tere is links.
If you are having big troubles with this, then I will suggest the csv-viewer. If you want me to make a test for you, then you can contact me here : http://calendarforum.dk/contact.html
I will then tell what is needed - I think only a csv-file will be needed.
If you have a varchar field with a length more than 60 then try to put this in the field :
<a href="http://calendarforum.dk">Good webcalendar</a>
You should then see a clickable link. The text for the link will be : Good webcalendar
Autor
John you are a star. I will have a play around with your ideas later this week when I have enough time to dedicate to the project.
>> >> CSV Viewer
>> example >> CSV + link >> topic
.
Autor
Thanks KolAsim but I need a search function which I get with data base viewer but not with csv viewer
... sorry, the CSV Viewer is limited ... hi ...