Help! What do i use for this!

[Blazer06]

Originally Posted by large_nostril

MS equivalent to PHP and MySQL is basically ASP and Access, which never should have been allowed online.

YES! Do NOT use ASP and Access. (if you do use ASP, you still can use mySQL, but there is no reason to)


-Blaze

[Creosote]

Originally Posted by large_nostril

MS equivalent to PHP and MySQL is basically ASP and Access, which never should have been allowed online

Access is the equivalent of MySQL? These are two VERY different databases. It would be more fair to compare MySQL to MSDE, or SQL Server Express. There is also ASP.Net, which is very different from ASP.

[James T]

When you connect from your client machine to the server you are limited to the commands you can send, GET & POST being the main two. You can pass data to the server by the way you format the GET request or by the POST method.

From here the web server really just serves up a page, but in doing so it passes data to a server side script which is then able to connect to a server side database and read and write to the database. You cannot do this from a client side script, you cannot do it from javascript, you can attempt it with client side java but then you have to write your own network sockets on the client side and access a port direct into your database on the server side, which is bad for security.

You can use java on server side as large_nostril pointed out, but it must still respond to the GET and POST methods. Now it is possible to write a dedicated java server side socket and go java client side to java server side. Don't, the security holes you open are potentially massive.

Also, I suspect when you are talking Dreamweaver MX java, you are talking client side java. Just a guess this.

[Blazer06]

Originally Posted by James T

When you connect from your client machine to the server you are limited to the commands you can send, GET & POST being the main two. You can pass data to the server by the way you format the GET request or by the POST method.

From here the web server really just serves up a page, but in doing so it passes data to a server side script which is then able to connect to a server side database and read and write to the database. You cannot do this from a client side script, you cannot do it from javascript, you can attempt it with client side java but then you have to write your own network sockets on the client side and access a port direct into your database on the server side, which is bad for security.

You can use java on server side as large_nostril pointed out, but it must still respond to the GET and POST methods. Now it is possible to write a dedicated java server side socket and go java client side to java server side. Don't, the security holes you open are potentially massive.

Also, I suspect when you are talking Dreamweaver MX java, you are talking client side java. Just a guess this.

Wrong, you *CAN* send varibles to the server using javascript. Getting them into the database, I am sure you can do, but I'm not sure.

Here is just a example script that will pass varibles to the server: (send the month, day and year, as well as any exsisting varibles)

<SCRIPT LANGUAGE="JavaScript1.2">

<!-- Begin
  var time=new Date();
  var lmonth=time.getMonth() + 1;
  var date=time.getDate();
  var year=time.getYear();
  year = year + 1900;
 
  url = new String( document.location );
  vars = url.split("?");
  vars2 = vars[1];

  if( vars.length > 1 ) {
    urlString= "page.php?" + vars2 + "&d_d=" + date + "&d_y=" + year + "&d_m=" + lmonth;
  } else {
    urlString= "page.php?d_d=" + date + "&d_y=" + year + "&d_m=" + lmonth;
  }

  self.location = urlString;

// End -->


</SCRIPT>

You then can use almost any scripting language to handle that.


-Blaze

[James T]

Originally Posted by Blazer06

Wrong, you *CAN* send varibles to the server using javascript. Getting them into the database, I am sure you can do, but I'm not sure.

Blaze, your example script is using the GET method, which is one I described. So you've actually demonstrated I'm right by example.

[large_nostril]

Access is the equivalent of MySQL? These are two VERY different databases. It would be more fair to compare MySQL to MSDE, or SQL Server Express.

Indeed they are very different, in functionality. I was (maybe erroneously) comparing their support. I don't know many standard servers (by that I mean not a single one) that support MSDE or MS SQL.

There is also ASP.Net, which is very different from ASP.

lol... I preferred ASP to ASP.NET; but still, it never should have been allowed online (IMO).

Long story short, there are dozens of ways this could be accomplished. The best way, is to use PHP and MySQL. If your server doesn't support MySQL, the next best is to use PHP to read and write from a flat text file. If your server doesn't support PHP, the next best would be ASP and MySQL, then ASP and text file, then... well, let's just not go there.

(boomsonic, sorry for getting this thread so off topic. If you need any more help, you can PM me)

[Blazer06]

Originally Posted by James T

Blaze, your example script is using the GET method, which is one I described. So you've actually demonstrated I'm right by example.

lol, Sorry, I got confused.


-Blaze

[Creosote]

I would use XML over a text file. A $5 per month rented space on a webserver wouldn't support MSDE or SQL Server. One's own Windows box would, however, and MSDE is free as well. SQL Server is offered on almost all Windows hosting plans for a fee.

I still wouldn't use a text file or XML over Access. I would use MySQL over Access, however,