Where do I put my files?

ryanx5452

I am brand new, and Im sure this is dumb, so sorry for that. 🙂

I have MySQL databse on my hosted website, and created it with phpmyadmin, but what if I wanted to create one with my own php script, where would it go?
Or, if I make a php file that will connect to my database and insert data into a table, the data that it got from POST html form, where does that php file go, where to upload it?
I ask because, first off, how do I access it once it is there, and second, is it hidden on my website or can others just get to the php scripts i upload to my website server and interact with my databases??

Sorry if these questions are ludicrous, but Ive been on this about 2 days now, lol.
Thank you for your time and help!

woodeye

I'm not quite sure I completely understand your questions.

First of all, unless someone has your username and password to your database, they shouldn't be able to access it. Maybe some hackers may know a way around this, but as far as I know, they need that info.

If you want to create a database via PHP, you absolutely can, start here. That has all the info you need to do what you're looking for.

You're losing me when you're asking where to put your files. If you're writing a script, like all scripts, it would go on your site. MySQL is a service that the server is running, and it manages and stores the data for you. And either you can write a page that will access and display that data, or you could view the data in phpMyAdmin or something like that.

Hope that helps

ryanx5452

😃Thank you for replying, and I will read through that link, thanks.
Sorry my question was not clear, I am learning as I go, :eek:

What I meant about where to I put the files is this, for example;
I have a page called index.html which is obviously uploaded to the root directory as the home page. I have a folder called SMF where my forum stuff is. Other folderand files are all default from godaddy hosted account, I added none.
I want to create a php script whose only job is to connect to my database, take info from a php/html form and input it. Does that php script get uploaded to the same directory as where the file is that has the html/php form in it?

There is also a folder there called php uploads, that is empty and was created by default. Should all php scripts I make go into there? And then when I want to use the POST data from one of the html forms, do I tell it the action is the path to the php script I made in the other folder? like /domainname.com/phpuploads/myscript.php ?

Does that make sense?
Sorry for the confusion and dumb question, I am learning as I code 😃

Thank you again for the help!

woodeye

You can put PHP scripts just about anywhere. I don't know why GoDaddy would create a phpuploads folder, but if you want to put your scripts there, as far as I know, you can. You just have to include the folder name in the path to your script.

So you're form tag will be something like this:

<form method="POST" action="phpuploads/script.php">

I don't usually do it that way, but you can, it's up to you.

ryanx5452

can you tell me how you usually do it? I have no idea, that stuff I wrote was just guessing.
What is the best way, simplest, to do it? If I have a page that has an html form and another page that is script.php, where is the best place to put them?

woodeye

I usually put them in the same folder. So use the same FORM tag, just remove the "phpuploads/" part.

But I usually make my form a php page, and then have it call itself. That way I can make sure that all the required fields are filled in correctly, and if they are, then I post to the database, and display a message letting them know that the post was successful. You could do verification using Javascript instead, but I'm better at coding in PHP, so I go that route.

ryanx5452

Thanks again,
what do you mean by making your form a php page and having it call itself?
Do you then just have that same form connect and update the database? Or have the php form page call a database connecting script?