Skip to main content
A
Anonymous
November 23, 2010
Question

CS5 and Other Programs

  • November 23, 2010
  • 1 reply
  • 902 views

I asked this in another discussion but shouldn't have because it was under the wrong topic.  Hopefully the answers here can help myself and many others.  I'm trying to build a business website, I'm using dynamic data because I don't feel like building the entire corporate inventory of around 20,000 items one page and link at a time.

I'm aware that there's some issues in trying to combine DW and VS 2010 in certain regards.  I'm also aware of various other IDE's such as Netbeans.

Ok, if I built a SQL (or MySQL) database using something like C#, could DW read from it?  I don't need to transfer anything other than the structure (table set up, contents, and the entity relationships).  So if I filled in about 200 products worth of information in VS for testing purposes, could Dreamweaver read that and could I make it do query statements without compatibility popping up?  All DW needs to do is read and query it, as far as I know, that doesn't need anything like stored procedures from VS.  Secondly, if I updated that database using VS, would I have to rebuild my DW connection, if not, how do I do it?

I've found the PHP code to make Dreamweaver display dynamic data, would this interfere?

That leaves the other question.  Netbeans has PHP editing capability, if I wrote the code in Netbeans, I could just copy and paste that into DW, right?  I just want the debugging feature that won't make me guess at the problems, and netbeans shows me right in the code where it's wrong.

Any answers welcomed and appreciated.

This topic has been closed for replies.

1 reply

A
Anonymous
November 23, 2010

I think I am confused by the whole train of thought.

You need a database to hold about 20k items.  So why not just build a MySQL database using php to create your  inserts and queries?

Netbeans and Dreamwever are editors, what you create in NB can be inserted into DW.  It is all just code, and the editors allow you a canvas to create your code. NB seems to be getting a little irratic as of late, I have an earlier version and use it to try to find errors before testing.

Something I have done also, while a little of topic, is with that many items to store, I have created a form for the owner to insert the data into the db, relieving you of the work.

But, it just seems you are complicating things too far.

Gary

A
Anonymous
November 23, 2010

Sorry, I was caught in my own weird train of thought.  I wanted to use C# to create that form you mentioned to update the database.  I just didn't know if that would work with DW or not.  Just make a simple .exe that would be able to select that database, add info, save, and close.  You phrased it perfect, a form.

The problem is that most of the stuff isn't even on the site, literally starting from scratch, no inventory lists I can use very well, no pictures, no descriptions, nothing.  I wanted to make that form with C# just to streamline adding data.  Can I do that without messing up Dreamweaver?

A
Anonymous
November 24, 2010

Iphp, I think you are confused (again).

The form script, (that was not posted in this post, yet you bring it up), was in a turorial that I wrote, and again (third time I think now it has been brought to your attention) has the following langage in it.

""A couple of other points, there is no validation on the form you see here, so  it opens the door to spam and other attacks. A submitter is not required to  input an email address and can input anything they like with the form as  written. There is no security on this form or script, if you were to add a  database to this script, it would be very vulnerable to malicious attacks. It is  strongly suggested you research form security, in particular if you are adding a  database.""

Now I am unclear if it your reading or comprehension that you are having a problem with, but it seems clear to me.

The tutorial link is http://www.paulgdesigns.com/learncontactform.php

And again, in your failing to read, there was a follow up tutorial called Securing your form, (as well as a few others) which is at  http://www.paulgdesigns.com/secure.php, which deal with email injection attacks. Please note it deals with email attacks, not database attacks.

Now for some reason, I have yet to see you post anything, other than critisism, regarding security on forms.  You had mentioned in one of your post that a single line would make the form scripts safe, are you delusional, do you really think that one line of code would secure anything on the internet?

And no, you still can not hold my hand...

Gary


Harsh guys, real harsh.  I did some research yesterday about that, as far as I know the only thing our database is really going to hold is our inventory, we'll be using third parties to process payments, and since repeat customers just aren't an issue and as far as we know, won't be (it's home lighting and decor mostly, so they're only interested once or twice), we weren't going to bother giving them accounts or anything.  No need.

I didn't think the one line would make all that difference in the search bar (although I'm still going to use it).  Any other decent methods?  All the searches keep coming back to those escape lines or the so called magic quotes(which more research suggests is worse than any injection at the end of the day).

Too bad MD5 isn't so great anymore....

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices