View Full Version : mySQL database Tutorial???

09-25-2006, 11:04 PM

Is there anywhere that I could get a MySQL Tutorial, so that I could learn how to use it effectively?

Please reply...


09-26-2006, 06:06 AM
MySQL is such very large topic, click the below to learn how to create a database....


09-26-2006, 07:15 AM
Hi again,

Thanks for your help... Could you explain - or give me a link that explains - how to use the database in BV?
Say you want to easily update and add new information to your webpage, and the information always has the same fields. Like Address, Practise, Country, Phone Number and Name for example. All the information has to be displayed on the webpage. How could you use a database to do this?

Thank you,

09-26-2006, 08:42 AM
BV has nothing to do with the database. The database administration is made through your CP and the phpAdmin that comes with it.
What you are looking for, is a web based interface script that would allow DB searching, and displaying the querry results. This is usually done with php in joint with a visual part (which can, if you have the knowledge to combine the two, be built in BV)

This is not a standard BV feature (i beleive it is not a feature of ANY sitebuilder) , but is one of the future projects i have. Building a BV intreface for administrating a DB. The project is a very complicated one, as it has to be completely parametric, in order to allow users to define what they want to visualize, how to do it, etc.

For the moment i beleive you can only look if someone (or you) can build a custom made script for your purposes.

09-26-2006, 10:39 AM
Thanks Naval,

I understand what you are saying... thanks for your help.


10-09-2006, 05:55 PM
I have been trying for hours to get this to work. All I want to do is create an opt in form. I am using php form generator. Seemed very easy until I tried to add the info to mySQL database. Obviously I need to maintain the opt in list, but cannot get the databse to work correctly. I have been to php forum, looked everywhere and this post was the closest I could find for an answer. When I fill out the final page in the form maker, I receive this: reply:

[ home (http://phpformgen.sourceforge.net/) ] [update (https://sourceforge.net/project/showfiles.php?group_id=45605)] [support (http://sourceforge.net/docman/?group_id=45605)] [contact (musawir******.com)] quick links - project web (http://sourceforge.net/projects/phpformgen/)
- sourceforge (http://www.sourceforge.net/)
- linux.com (http://www.linux.com/)
- php.net (http://www.php.net/)
- mysql.com (http://www.mysql.com/)
- apache.org (http://www.apache.org/)

powered by h4x0rs.us

wise words What is the difference between genius and stupidity? Genius has limits. - Albert Einstein. Step 5: generation status v2.09 thats it! now we're ready to generate your form. if you encounter any errors, please make sure that you provided the correct database information (if any), and please maintain that everything is case sensitive. also remember to give read+write permissions to the forms directory (located under the phpformgen directory). thank you.

Now creating table 'optinnres' ...

Warning: mysql_connect() [function.mysql-connect (http://www.chicagocycleconnection.com/optinform/function.mysql-connect)]: Access denied for user 'zoyxtaw'@'ns15.vodahost.com' (using password: YES) in /home2/zoyxtaw/public_html/optinform/process3.php on line 288

Could not establish connection to MySQL database with the information provided.I am wit's end trying to do what should be simple. ANy suggestions, or a different approach, Please let me kkkknnnow.

THank you

10-09-2006, 07:01 PM
The DB login details must be wrong. Connect to your CP, Databases, and chech the database login details and the database name. Usually, the username and database name, will have "zoyxtaw_" infront of the name and the username given

12-22-2006, 09:39 PM
i came accross the same problem before , and Navaldesign is right, the DB login details is wrong. Once i corrected it , running smooth now. :)

12-22-2006, 09:52 PM
You might want to preview this link: