PHP, MySQL noob question

[1sikbITCH]

I don't know jack, but am trying to learn as I go. I have visited the MySQL site as well as the phpMyAdmin site but cannot find the answer. I'm still reading and searching but after several hours off and on I decided to ask here as well.

I have a newly hosted site through Telnap (thanks Devious Trap). I am creating my site with Dreamweaver. I have a prewritten PHP script I downloaded for an interactive calendar, but the site it originally came from is in French so I can't browse for questions. Actually it just occurred to me that the calendar probably is too 😱

Through phpMyAdmin I have created a new MySQL database that now needs tables to be created. This is where I am stuck. I can read how to create tables, but since I'm using a script which already has tables written into it, I am unsure of how to proceed. If I just need to create a temporary table that will allow me to install the script, I could use some tips for that.

Thanks 🙂

 

[screw3d]

I think you would just need to specify which database to use, and the script will automatically create the tables.. at least that's my experience with the majority of the scripts out there.

If you can only use a single database, you might want to use a table prefix to seperate tables from different scripts, a feature that might or might not be built-in the scripts you want to use

 

[1sikbITCH]

The problem is this. I can load the php page with the script into Dreamweaver, and I've successfully connected Dreamweaver with the SQL server, but when I try to insert the page into the database via "Insert>Application Objects>Insert Records Wizard" or even just through "Forms>Insert Record", it asks for the table and just says "no table found". I need to figure out how to build a table that will accept this calendar. But, 2 days ago I didn't even know what a table or a database was so I'm still progressing.

 

[SaturnX]

Generally, you upload the script to your host, then navigate to it's installer, ie: http://yoursite/script/install.php

By doing that the script will create the tables and populate the required values.

I have no idea how to even use Dreamweaver, I do everything by hand so I can't help you there.

If there isn't an installer that automatically generates everything for you, better start brushing up on your French (to read the install instructions), or just find another script.

--Mark

 

[hooflung]

look at the files in the zip file that your script came in. If there is no install.php ( or something in that naming convention eg setup.php or config.php ) then look for a file that looks something like .sql and then use phpMyAdmin's sql tab and then the 'from file' feature and then point to the file on your PC.

That would create the tables and any misc. data that might be with them.

Cheers

 

[statik213]

Originally posted by: 1sikbITCH
The problem is this. I can load the php page with the script into Dreamweaver, and I've successfully connected Dreamweaver with the SQL server, but when I try to insert the page into the database via "Insert>Application Objects>Insert Records Wizard" or even just through "Forms>Insert Record", it asks for the table and just says "no table found". I need to figure out how to build a table that will accept this calendar. But, 2 days ago I didn't even know what a table or a database was so I'm still progressing.

you shouldn't have to do anythign of this sort.
like others have said, you would have to upload your script to ur web server and maybe edit a config file to tell the script how/where to connect to ur db and like someone said what table prefix to use.

You would then include that script in any of your PHP scripts.....
on some scripts you might need to call a certain function to 'write' the calendar where you want to on other you just include it where you need to.

here's a good calendar that i've used in the past:

http://www.easyphpcalendar.com/

You might want to reconsider your choice if you can't read the documentation.

 

[1sikbITCH]

Originally posted by: statik213

Originally posted by: 1sikbITCH
The problem is this. I can load the php page with the script into Dreamweaver, and I've successfully connected Dreamweaver with the SQL server, but when I try to insert the page into the database via "Insert>Application Objects>Insert Records Wizard" or even just through "Forms>Insert Record", it asks for the table and just says "no table found". I need to figure out how to build a table that will accept this calendar. But, 2 days ago I didn't even know what a table or a database was so I'm still progressing.

you shouldn't have to do anythign of this sort.
like others have said, you would have to upload your script to ur web server and maybe edit a config file to tell the script how/where to connect to ur db and like someone said what table prefix to use.

You would then include that script in any of your PHP scripts.....
on some scripts you might need to call a certain function to 'write' the calendar where you want to on other you just include it where you need to.

here's a good calendar that i've used in the past:

http://www.easyphpcalendar.com/

You might want to reconsider your choice if you can't read the documentation.

Thanks, that's the entire problem. It only came with the php file and 4 gifs. No documentation at all.

I will certainly use the one you supplied instead, and will read all the posts here and hopefully install successfully.