Browser Inside Excel to PHP

[MagixIlussions]

Hi there,

 

I'm new here and php/sql/wordpress too. Well, i wanna know if there is a way to show a browser inside Excel in a web. I've an excel file with a database and browser, and i want people can search what they need into a database (Excel), but i've no idea about how to do this.

 

I dont want all the code, but if you can give me some ideas xD.

 

Regards

[kicken]

I'm not sure what you're asking for. Do you have an excel file and want to use that as your database? In other words create a PHP script to allow people to search your excel file for information?

 

If that is what you want, it could be done but you'd be better off moving that data into a real database instead.

[MagixIlussions]

Hi,

 

Thanks. Yes, thats what i want. You can see a demo file here milamundial.org/uploads/browser.xlsx. The browser show the info by ID, and its what i want to show only to allow people to search.

 

What means real database? SQL?. Should i export excel file to sql or csv and create a PHP script?.

 

Thank you.

Edited January 17, 2014 by MagixIlussions

[KaiSheng]

Real database is a place where data is stored in your localhost or on a domain.

The information is kept inside a SQL file.

You should export to SQL file, and import into the database localhost or onto your domain.

Followed by creating a php script to search or view the information. (It is way much easier and simpler this way.)

[MagixIlussions]

Hi,

 

Watching and reading a bit, i did, but damn it. I lost mysql db config (Tables n Prefix) n really dont forgot all what i did. No log or screens caps.

 

When i want to import excel file, i get the following message.

 

Warning: PDOStatement::execute(): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'codify_nube.search_users' doesn't exist in/home/codify/public_html/jimenezdavilayasociadas.com.mx/wp-content/themes/onedevmx/none/import/index.php on line 66

 

I know i created this and tables, but i dont remember where, any help?.

 

Thank you

 

[MagixIlussions]

Hi,

 

It works. But now, we are unable to create new columns. It was for 6 columns, i dunno where to add new columns :S

 

 

Here is the script http://jimenezdavilayasociadas.com.mx/wp-content/themes/onedevmx/map/Database.zip

[QuickOldCar]

Do you use phpmyadmin at all?

 

It's too hard to tell you an exact command with the little information, can follow this video tutorial which can show where to add it in phpmyadmin.

http://www.youtube.com/watch?v=jZ72GCGWPQg

 

 

If doing direct from command line with mysql:

Need to use your values everything that is colored in red.

 

I used VARCHAR(60) as data type because do not know what you need.

http://dev.mysql.com/doc/refman/5.7/en/data-types.html

 

mysql -h localhost -u USERNAME -pPASSWORD DATABASENAME;

ALTER TABLE `TABLENAME` ADD COLUMN `NEW_COLUMN_NAME` VARCHAR(60) AFTER `AN_EXISTING_COLUMN_NAME`;