Web Hosting, Design, & Coding

General discussion

MySql and PHP

by Eddiewilson194 / April 29, 2010 8:22 PM PDT

I want to know how Mysql and php works together. and how differ from asp.net

Post a reply
Discussion is locked
You are posting a reply to: MySql and PHP
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: MySql and PHP
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Re: MySqL and PHP
by Kees Bakker / April 29, 2010 8:32 PM PDT
In reply to: MySql and PHP
Collapse -
I agree with Kees
by Maarek Stele / May 10, 2010 7:01 AM PDT
In reply to: Re: MySqL and PHP

put it this way, it's more of the code then and the connection then it is about the database. SQL has more menu and orientation that deals with Visual Studio, while MySql is more command line driven.

further, PHP uses more HTML which ASP.NET uses the <ASP> tag for all their browser items. And finally the Code. ASP.NET will use Visual Basic a wordy type of code and also C# where the code is more Java based.

PHP on the other hand uses a more structured code like C++, but there's the newer the version, the more pre-compiled functions to allow users and programers more flexibility with simple things like email.

To my knowledge, if you are new to programming period. Start with PHP. It's free, there are tons of service programs for Windows XP, etc or even for Linux (LAMP) installations. If you are a Microsoft person, have the $$$ for Visual Studio, and are looking to go into .NET, then by all means learn .NET from the start.

Collapse -
Links php vs asp
by ugniesdebesys / June 8, 2010 8:55 PM PDT
In reply to: I agree with Kees
Collapse -
RE: MySql and PHP
by glenjparker / July 6, 2010 8:20 AM PDT
In reply to: MySql and PHP

Php is a scripting language. MySql is used to access data from a database. Both can exist perfectly happily on their own but are very powerful when their powers combine as the scripting language is perfect for manipulating the retrieved data.
Asp.net has many attributes that set it apart from php but very generally its role in the equation would be like that of php.

Collapse -
php mysql connection
by Urarto / July 15, 2010 4:17 AM PDT
In reply to: MySql and PHP

It is easy to work with PHP and SQL. Once you have created a database, there are a few ways you can connect to it.
To connect from a PHP script, just put this in your file:
<?
mysql_connect("DBSERVER", "DBUSERNAME", "DBPASSWORD");
mysql_select_db("DBNAME");
?>
using the following substitutions for the bold terms as above, plus substituting DBPASSWORD with your own mysql password:

* Replace DBSERVER with the correct database servername for your site.
* Replace DBUSERNAME with your own mysql username.
* Replace DBNAME with your own mysql databasename.
According to php form tutorial the connection will be closed automatically when the script ends.

Collapse -
PHP and MYSQL
by localinternettraffic / July 25, 2010 9:58 PM PDT
In reply to: MySql and PHP

PHP is a server side scripting language. which is use for write script which will run on server not on client. PHP uses a RDBMS to store the databases. MYSQL is a sort of RDBMS. PHP uses MYSQL for store and retrieve data. In other hand asp.net is also a server side scripting language with powerful controls . asp.net is a product of Microsoft.
asp.net can use MYSQL for store data,but generally developers of asp.net prefer sqlserver instead of MYSQL.

Popular Forums
icon
Computer Help 47,885 discussions
icon
Computer Newbies 10,322 discussions
icon
iPhones, iPods, & iPads 3,188 discussions
icon
Security 30,333 discussions
icon
TVs & Home Theaters 20,177 discussions
icon
HDTV Picture Setting 1,932 discussions
icon
Phones 15,713 discussions
icon
Windows 7 6,210 discussions
icon
Networking & Wireless 14,510 discussions

Tech for the holiday

Find recipes for July 4 with these foodie apps

The Fourth of July means fireworks, fun and food. If you're planning on a barbecue this weekend, we've got the apps to help you find holiday-inspired recipes.