php mysql comparison

[Jerome Tan]

hi there,

how is vb.net database programming easier compare to php-mysql combination?
i'm having trouble understanding how vb.net work compare to php-mysql
database accessing.

can anyone shed me light for easier understanding?

thanks.

regards/
jerome

 

[Anon-E-Moose]

hi there,

how is vb.net database programming easier compare to php-mysql
combination? i'm having trouble understanding how vb.net work compare
to php-mysql database accessing.

can anyone shed me light for easier understanding?

ASP.NET is fully OO, has the ability to handle events for starters.

If you're an ASP, PHP, or even ColdFusion programmer... you may have some
getting to used to with ASP.NET, but once you do, you'll wonder why other
web languages aren't like ASP.NET : )

 

[Jerome Tan]

i don't mean asp.net... i mean vb.net integrating with database, i get
confused with datasets....

Regards/
Jerome

 

[Cor Ligthert]

Hi Jerome,

In addition to Anon,

There are more ways to go with ASP.NET.
When you use the dataset is basicly the only thing you need.
A datasetconncection
A dataadapter
A dataset

A dataset is a collection of datatables, those holds tables which are
selected from the database using a select.

Tables have columns and rows, although a little bit confusing is that a
column is called when using an item.

A dataset is
ds.tables(0).rows(0).item(0) represent the first item in the first row in
the first table.

Typical code to make this is
Dim conn as new SQLconnection("connectionstring")
dim ds as new dataset
dim sqlstring as string = "select * from mytable")
dim da as new sqldataadapter(sqlstring, conn)
da.fill(ds)

You have now your data in your dataset.

I hope this helps?

Cor

 

[steve]

|but once you do, you'll wonder why other
| web languages aren't like ASP.NET : )

i don't know about that! php 5 is about ready for release and boasts most of
the features of asp.net...without all the overhead.

as to the question asked though, it doesn't compare. php and mysql are light
and fast...then there's asp.net/sql server. and then there's free v.
expensive. i've been developing php and asp sites since
'98...professionally. sure would be nice to be able to run asp on a unix
server and/or a windows server. i'm starting to get off on a rant...i
digress. let me put it this way. whatever is lacking in php v. asp, i
haven't had to deal with it...it's all in how you design/implement it. the
$1B+ per year company i work for is sticking with php/mysql/oracle...and i
guess i will be too. anyway, the combination is fast and light and the
interfaces are easy to understand...the interface is the only place i see
asp.net keeping up with our needs.

but that's just my 0.02 usd.

hth,

steve

 

[Anon-E-Moose]

i don't mean asp.net... i mean vb.net integrating with database, i get
confused with datasets....

Check out Microsoft's Application Building Blocks:

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnbda/html/daab-rm.asp

This class simplifies the creation of Datasets/Datareaders/etc. It's a
great utility from Microsoft!

Version 1 is for VS.NET 2002. Version 2 is for VS.NET 2003.

 

[Anon-E-Moose]

i don't know about that! php 5 is about ready for release and boasts
most of the features of asp.net...without all the overhead.

as to the question asked though, it doesn't compare. php and mysql are
light and fast...then there's asp.net/sql server. and then there's
free v. expensive.

PHP 5 doesn't support events yet nor does it have the the object model
currently present in ASP.NET. I would consider the object model and event
model to be the two biggest feature of .NET

Also, you can run ASP.NET with free databases such as Firebird SQL or MySQL
- I've used .NET with both and they work fine.

Speedwise, I wouldn't doubt PHP is faster than ASP.NET, but I doubt the
speed difference is significant enough for me to give up the features of
ASP.NET ; )

In anycacse, it would be nice if ASP.NET supported multiple platforms... on
the brightside, C#.NET has been ported to Linux:

http://www.mono-project.com/about/index.html

 

[steve]

| PHP 5 doesn't support events yet nor does it have the the object model
| currently present in ASP.NET. I would consider the object model and event
| model to be the two biggest feature of .NET

well...not quite true. php has supported classes for quite some time.
granted, there isn't scope protection for a class's interfaces, however
saying there is no support for object modeling is misleading and incorrect
altogether. php has allowed inheritance and overloading way before vb ever
thought of their inclusion in the language. there are also several "events"
to which you can subscribe...ex., error handling...these events are not
user-defined at this point though.

i do agree asp.net has a lot to offer...but php developers are working out
methods to accomplish things like this...and, how to keep the functionality
w/o loosing speed or consuming too many resources.

| Also, you can run ASP.NET with free databases such as Firebird SQL or
MySQL
| - I've used .NET with both and they work fine.

i do as well...just not w/ asp.net. i hit all kinds of db's w/ vb.net.

| Speedwise, I wouldn't doubt PHP is faster than ASP.NET, but I doubt the
| speed difference is significant enough for me to give up the features of
| ASP.NET ; )

really depends on what you're developing...your probably right for most
cases. we have high volume and lots of data exchange.

| In anycacse, it would be nice if ASP.NET supported multiple platforms...
on
| the brightside, C#.NET has been ported to Linux:
|
| http://www.mono-project.com/about/index.html

cool link...too bad ms isn't porting its own stuff though.

 

[Tom Shelton]

| PHP 5 doesn't support events yet nor does it have the the object model
| currently present in ASP.NET. I would consider the object model and event
| model to be the two biggest feature of .NET

well...not quite true. php has supported classes for quite some time.
granted, there isn't scope protection for a class's interfaces, however
saying there is no support for object modeling is misleading and incorrect
altogether. php has allowed inheritance and overloading way before vb ever
thought of their inclusion in the language. there are also several "events"
to which you can subscribe...ex., error handling...these events are not
user-defined at this point though.

i do agree asp.net has a lot to offer...but php developers are working out
methods to accomplish things like this...and, how to keep the functionality
w/o loosing speed or consuming too many resources.

| Also, you can run ASP.NET with free databases such as Firebird SQL or
MySQL
| - I've used .NET with both and they work fine.

i do as well...just not w/ asp.net. i hit all kinds of db's w/ vb.net.

| Speedwise, I wouldn't doubt PHP is faster than ASP.NET, but I doubt the
| speed difference is significant enough for me to give up the features of
| ASP.NET ; )

really depends on what you're developing...your probably right for most
cases. we have high volume and lots of data exchange.

| In anycacse, it would be nice if ASP.NET supported multiple platforms...
on
| the brightside, C#.NET has been ported to Linux:
|
| http://www.mono-project.com/about/index.html

cool link...too bad ms isn't porting its own stuff though.

Why? The mono guys have done most of the work for them...

 

[steve]

| Why? The mono guys have done most of the work for them...

lol

i wish i was allowed to just worry about programming for one os and let
someone else (not even w/n my company) write the ports. ;^)

 

[Jerome Tan]

I just downloaded it, it's a source code... or should I expect it to be a
code generator?

Regards/
Jerome

 

[Anon-E-Moose]

I just downloaded it, it's a source code... or should I expect it to be a
code generator?

Compile the sourcecode into a DLL.

Open your exisiting project - add the dll as a reference.

Import Microsoft.Application.Data

You're all set to go!

(BTW, read the webpage... it has a tutorial on how to use it)

 

[Anon-E-Moose]

| PHP 5 doesn't support events yet nor does it have the the object
| model currently present in ASP.NET. I would consider the object model
| and event model to be the two biggest feature of .NET

well...not quite true. php has supported classes for quite some time.
granted, there isn't scope protection for a class's interfaces,
however saying there is no support for object modeling is misleading
and incorrect altogether.

I guess I should of been more clear as what I was referring to as
objects - I primarily meant the buttons, datagrids, etc. The complete
webcontrols framework that Microsoft provides the user. I guess I used
the word objects in the wrong context. I do understand that PHP4.0
support OO programing to some extent and PHP5 implements a lot of the
missing features. In .NET I can do:

Button.Text = "Some Text Here"

Or I can handle events for a button:

Private Sub Add(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnAdd.Click

'Do some stuff when I click the Add Button

End Sub

Events aren't limited to just buttons but all the objects in ASP.NET
have a complete set of events and properties.

While you can replicate a similar framework in PHP5, someone has to
build it. In ASP.NET the entire framework has been built for you.

Anyhow, I'm not against PHP, ColdFusion or other web languages - I've
used them all. It's that after using ASP.NET for the past year and a
half... all the other languages seem archaic in comparison.

 

[steve]

| Anyhow, I'm not against PHP, ColdFusion or other web languages - I've
| used them all. It's that after using ASP.NET for the past year and a
| half... all the other languages seem archaic in comparison.

opinion duely noted and appreciated. ;^)