This is a discussion on "My SQL/PHP - phpmyadmin" within the Databases section. This forum, and the thread "My SQL/PHP - phpmyadmin are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
My SQL/PHP - phpmyadmin
|
||
| Notices |
![]() |
|
|
LinkBack (1) | Thread Tools |
#1
|
|||
|
|||
|
My SQL/PHP - phpmyadmin
Hi I know nothing about Mysql or PHP, all i know is that my domain company provides me with an sql database (currently utilised by a phpbb forum i setup) and phpmyadmin.
I want to set up the option to register for my visitors in order for them to have profile pages on my site and have the ability to upload images etc. Basically all the comforts phpbb offers at the moment. I want to set up a database, i really cant get a grasp of it though and dont want to delete the phpbb forums until i am confident its replacement can be implimented almost straight away. I am sure i have made a database in phpmyadmin before but wasnt sure how to interract with it, how to make text boxes on my web pages to gather new user info? I'm sorry if my post doesnt make much sense but having read up on mysql, php and a wasted effort of learning how to build a microsoft access database - only to find it had no relevence to serverside scripting, i'm confused to say the least. Any help would be very appreciated. |
|
|
|
#2
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
What you need to learn is php/mysql basics.
http://www.w3schools.com/php/php_mysql_intro.asp |
|
#3
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
Quote:
You've got what will probably be a major learning task ahead of you, and quite some coding too. Learn from web pages such as the ones that Sypher gave to you, books (PHP, MySQL), etc. If you're really serious, then there are PHP courses and MySQL courses around that will help you get started, help you through the initial trial and tribulations without you having to spend hours scratching you head over each new issue / roadblock you find, and help you to write reliable, secure, easily enhancable and maintainable code. Declaration of interest - I'm presenting the courses that I've just given the link to ... but I choose to teach MySQL and PHP because they're great products that I believe in! |
|
#4
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
Thanks for your help, I'm afraid after reading Syphers reply I deleted the PHPBB forum, replaced it with a db I made on phpmyadmin as i followed along the instructions from w3schools.com, I am serious about learning php/mysql but as i'm currently unemployed (hence i can dedicate so much time to my website) I certainly cant afford any courses at the moment.
My other concern would be that as i'm accustomed to creating webpages through WYSIWYG programs in a drag and drop manner, it could be argued i'm not 100% on HTML either, but now i find myself with a well presented webpage which i never thought possible and php/mysql seems the logical next hurdle to jump! |
|
#5
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
damn sorry about that
|
|
#6
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
lol no probs, u never said to delete it, i just took what i thought was the logical next step. I have to say its all more difficult than i thought it was going to be, I'm guessing i creat a form for the visitor to provide their information and then i create a script so that when a submit button is pushed it then enters that information into a table.
Question. How many tables can a database hold? Or is that more of a question of how much webspace i have? |
|
#7
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
Using myphpadmin I have done the following under database name 'test'
Table Person has been created. SQL query:CREATE TABLE `Person` ( `FirstName` VARCHAR( 15 ) NOT NULL , `LastName` VARCHAR( 15 ) NOT NULL , `Age` INT NOT NULL ) ENGINE = MYISAM ; now i've added the form to a webpage on my server using the following code <form action="insert_db.php" method="POST">Enter your Firstname: <input type="text" name="firstname" />Enter your Lastname: <input type="text" name="lastname" />Enter your Age: <input type="text" name="age" /><input type="submit" /></form> Where insert_db.php, should i ammend this to the database name I am using? On the furstname, lastname and age fields are the first letters case sensitive? Then to show the form the route to the table i use the following? $con = mysql_connect("localhost","###username###","###pas sword###");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person(firstname,lastname,age)VALUES('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }echo "Success!"; Please feel free to show me any errors Last edited by sypher; Jun 14th, 2006 at 19:13. |
|
#8
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
Dont post ur user name and password otherwise people can messup your databases.
It can fit in as many tables as you want. Ill make a simple form to show you how its done, just gotta finish some work of first. |
|
#9
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
Ok Thanks, the username and password are false
|
|
#10
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
|
|
#11
|
|||
|
|||
|
Re: My SQL/PHP - phpmyadmin
Setup a table and replace ##db-table## on the script with the table name you have setup.
Replace the user auth settings at the top with your own. In your table make 3 fields, firstname lastname age Save the file as insert_db.php |
|
#12
|
||||
|
||||
|
Re: My SQL/PHP - phpmyadmin
"PHP and MySQL for Dynamic Web Sites" (2d edition!) by Larry Ullman is excellent for a beginner. He stays active on a website, too, with corrections, errata, downloadable scripts to save some typing, and a forum where he will actually answer questions. Unlike a lot of books, the scripts have been proofread thoroughly and actually work. Any problems will show up on his site.
He doesn't use PHP MyAdmin but it's such an intuitive interface that it's really unnecessary. |
![]() |
| Tags |
| sqlphp, phpmyadmin |
| Thread Tools | |
|
|
LinkBacks (?)
LinkBack to this Thread: http://webforumz.com/databases/6916-my-sql-php-phpmyadmin.htm
|
||||
| Posted By | For | Type | Date | |
| ÀÏÎÐÒ: phpmyadmin | This thread | Refback | Nov 29th, 2006 10:14 | |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| phpMyAdmin | geyids | Databases | 8 | Aug 11th, 2007 07:03 |
| phpmyadmin ... site down? | Accurax | Webforumz Cafe | 5 | May 10th, 2007 18:43 |
| phpmyadmin | ktsirig | PHP Forum | 1 | Sep 30th, 2005 10:06 |
| phpmyadmin help needed | blatant3 | PHP Forum | 1 | Nov 4th, 2004 08:48 |