Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Saving user information

New Here ,
Aug 28, 2011 Aug 28, 2011

I need help.

I have created a website that allows outdoor sales reps to register and then log in to their account.

The site will be used to allow outdoor sales reps the ability to log into there account and fill out a customer lead form then save it as one of their leads. After it has been submitted the outdoor sales rep can keep track of all the forms that they have saved.

I tried to use the insert record wizard to to let the outdoor sales rep fill out a customer lead form and save it in a PHP/MySQL database. I was hoping that the sales rep could save then view multiple forms. The problem is that I can only use the wizard as a one time registration form and not as a way to allow a single user the ability to insert multiple records of the same form and then view all forms that have been saved.

TOPICS
Server side applications
888
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 28, 2011 Aug 28, 2011

Have you considered looking into a pre-existing solution rather than to re-invent the wheel.  This is one of those cases I would recommend looking into a pre-built solution.  It sounds as though you need a solution for your sales reps to save their information for:

1.  Themselves as a reference to help customers

2.  Management as a way of tracking employees

3.  Operations as a way of forecasting

And DW's pre-built tools will take you so far, but after you reach a certain point, the code hinting and personal knowledge that you can learn will far exceed was is built into DW because it is built as a general tool for people editing a simple CMS like Wordpress up to building more expansive applications.

I'd consider reading up on things like:

salesforce.com

highrisehq.com

sugarcrm.com

Or google something like "related:" and then any of those sites mentioned above. 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 28, 2011 Aug 28, 2011

Yeah, are you sure you want to reinvent the wheel? What is your level of expertise with database design, SQL and PHP? If you are building a CRM system, you need to start with a rock solid design. DW's server behaviors won't get you very far.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Aug 28, 2011 Aug 28, 2011

I agree with the above suggestions but depending on a couple things. How many sales reps are there? Will they need all the features of a CRM service? Some of these are not cheap, and may not ultimately be cost effective. But building your own application still will require several components, and it's a big undertaking for someone new to building dynamic web applications. The first part would be to provide the functions your reps need, launched from a main page that displays to the rep when they log in. I wouldn't worry about multiple inserts just yet, just create a single form to insert a new sales lead record. But before even doing that, you need to map out the entire application, as much as you can visualize. AND properly set up your database and tables accordingly. If you try to take the di it as you go approach to the database, you'll hit a roadblock at some point, then have to spend a lot of time with wor-arounds.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 28, 2011 Aug 28, 2011
  • "...Will they need all the features of a CRM service?.."
  •   "...just create a single form to insert a new sales lead record.."

No the sales reps do not need all the features of a CRM service. All the sales rep needs is to be able to fill out an online form and save the results in the MySQL database. Then be able to view the various form results at a later time.

I have a JavaScript form that calcutes what I need and it shows results in specified textfields throughout the page. I want to believe that I should be able to use the "Insert Record" function to add the textfield results to the MySQL database as a "session". I should be able to do this by naming the textfields appropriately to relate with the recordset.

I have attempted this and the second record does insert into the database and can be seen when I browse the table using phpmyadmin. I just can't seem to bind the second record on a webpage. I can only bind the first record.

I know that it can be called because I can use the "Data Objects >> Display Record Count >> Total records" function and It will result "2" for two records. Just can't seem to display both records for viewing only the first record displays.

How do I display both records?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 29, 2011 Aug 29, 2011

I've read through your post again and let me first say a few things.

One, if you believe that DW has the built-in procedures to do everything possible in mySQL, PHP or any other scripting language you have been grossly misinformed.  The basic tasks of inserting single records and pulling records out is in there, but anything more than that you will have to write the query yourself and DW allows this in an advanced editor.

Second, given that salesforce is a more expensive option than most I would still say your comment is a very arrogent one and was taken in the wrong way.  If you hire a sales person and pay them $30k/yr + commission, and they make $15k in commission, you are telling me that $15k in commission does not warrant the payment of $125/month instead of having a disorganized sales person without software making $30k+$5k in commission?  It's a cost benefit analysis and the belief you have that all "rented" software is no good for that reason alone is just plain ignorant.  If you use Windows servers in your business you use CALs to access the server, so even though you own the server and the server software you don't own the right to access your own server?  Because of this did your business abandon Windows for Mac?

I can already use the database to allow a visitor to register and then sign in to their account and veiw their profile information but I can only update their information, If I could just add a second and third and fourth record then I would be in buisiness.

Have you asked your company to send you for training?  Because it sounds like you do not have the necessary training, another reason for my comment.  Dreamweaver is an advanced tool, but it does not do everything for you.  Many people have this same misconception who have started to use DW with Wordpress because of some advertisements not realizing the work that goes into editing a Wordpress site.  They were expecting a plug-and-go tool like a Microsoft Word that does everything for them.  But like a DSLR camera, or Photoshop, there are a lot of users who can run basic things on auto, but if you want to take advantage of what you bought you are going to need more training. 

When the user logs in they go to the link "Your Stuff" and then click "Discussions" and a list appears of all the threads that they posted.

What you are asking for here is a basic concept in SQL language.  What you need to do is a SELECT query using the WHERE clause to select the items where the rep is the one who posted like: SELECT * FROM tbl WHERE rep=$_SESSION[rep] .  That would be like the discussion forum page and then you would select an individual record from that page.

There was another thread recently about using InnoDB vs MyISAM table tables because with InnoDB you create Foreign Key dependancies which ensure data integrity where the rep would be linked to a Foreign Key in your "rep" table so to ensure that there is a match when new records are created/edited/deleted.  This is something that needs to be considered as well.

I don't mean to scare you but I think you it is in your best interest and the best interest of the company for you to receive the necessary training.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Aug 29, 2011 Aug 29, 2011

I agree about the training, or perhaps your company would consider hiring a web developer at least for consultation. What confuses me, is that the OP on one hand demonstrates a certain ability having created the registration system, but on the other hand a lack of knowledge on how it actually works scripting-wise and with the database. No offense intended, but part of offering solutions here I'd to gauge the skill level of the developer. Inserting a record into the database then displaying the results is no more difficult than building the registration and log in, perhaps even easier.  To the OP, have you created this sales lead form and applied the insert record, and does it work? Did you create antable specifically to store this data? Are you saving the User ID also in that table when you do the insert?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 29, 2011 Aug 29, 2011

Are the responding user’s robots or real people?

I have to ask because every reply doesn't seem to be in response to my posts directly.

For example I wrote that I do have a form created and I have used the insert record function and I have been able to display the record on a webpage all successfully. But I have not been able to insert a second record for the same user and display it on a web page successfully.

The response to this was:

"To the OP, have you created this sales lead form and applied the insert record, and does it work? Did you create antable specifically to store this data? Are you saving the User ID also in that table when you do the insert?"

Why did this user respond with a question to something that has already been established?

This makes me wonder if I'm chatting with a robot instead of a real person. Also there is not one reply that comments on how to help me. In fact the comments seem to be up selling a non-Adobe product and discouraging me from using DW. Actually the comments seem to be putting DW down.

Did I post in the wrong forum?

Is this not a support forum?

I thought that this forum was supposed to help me but everyone seems to be a little upset that I'm not willing to through away my adobe product and buy something else. Some replies have even stooped to calling me names. HMMMM...

If I should buy Sales force then why did I buy DW?

Does Adobe know that this forum is only discouraging folks from enjoying this product even trying to push non-Adobe products on me?

Look folks if you don't know how to create a dynamic website just say so but calling me arrogant because I don't want to acquire another monthly bill on something that can be created using DW and a web server is ludichrist. I even received a lesson in ROI. But nothing related to Dreamweaver Application Development. What is the deal with that?

Where the idea that I work for a company that can afford sending me to school came from is also mystery. I never mentioned a word about a company at all. I asked a pretty basic question that even was commented that the question I asked had a simple solution. I believe that the solution is simple but what is the solution? Even the user who claimed that the solution was simple has failed to produce the simple solution directly.

What will be the next helpful tip "Buy low sell high"?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 29, 2011 Aug 29, 2011

I assure you that your posts are being taken seriously and that do want to help you find the best solution whether that be Dreamweaver or not.  This has been lost in retail where WalMart has to have everything and if they don't pointing you to another store to be more helpful is an offense that warrants the emplyoee being fired.

I have to ask because every reply doesn't seem to be in response to my posts directly.


I will at least try to show you how your questions are being answered:

For example I wrote that I do have a form created and I have used the insert record function and I have been able to display the record on a webpage all successfully. But I have not been able to insert a second record for the same user and display it on a web page successfully.

The answer from my first post:

And DW's pre-built tools will take you so far, but after you reach a certain point, the code hinting and personal knowledge that you can learn will far exceed was is built into DW


DW does not have this option built in.  But Dreamweaver does allow you to write custom queries.  As I went on in my second response:

What you are asking for here is a basic concept in SQL language.  What you need to do is a SELECT query using the WHERE clause to select the items where the rep is the one who posted like: SELECT * FROM tbl WHERE rep=$_SESSION[rep] .  That would be like the discussion forum page and then you would select an individual record from that page.

Unfortunately you have given us nothing to go on.  No data structure at all.  So I cannot say you should be linking tables here, with joins here and foreign keys here.  I can only speak in the same generalization that you have given us.  If you have a genuine interest in learning how to write SQL queries I, and many other users here, are more than willing to help you out and get you pointed in the right direction with tutorials, resources, etc., but we need more to go on.  We understand that companies handle things a certain way, confidentiality, etc., but if that's the case and the information is not allowed to be discussed anywhere, you should request that your company pay for you to receive the necessary training.

If I should buy Sales force then why did I buy DW?

This goes back to my Wordpress comment because I have seen plenty of posts lately of frustrated users who got DW thinking it was the answer to editing Wordpress only to realize how much PHP and coding is involved to make those changes.  DW is a professional-level tool with a steep learning curve.  I've been using it myself since the Macromedia days.  Experience doesn't come overnight and your first post on the forums contained " I tried to use the insert record wizard".  The fact that your first post mentioned the wizard and had no mention of code or queries will lead many users to assume your skill level.  Thus, in a business environemnt where time is money, we opted to instruct you about solutions which can help you attain your goals for a lower development and testing cost to get you up and running.

Sales force had to start with hand coding and eventually they launched a modular system system and resold the system for other companies to use.  The monthly fee is no worse than asking you to upgrade Office or Windows or memory in your computer.  For a consumer perspective $65/month is a lot, but for a business that is pocket change considering the costs of owning/leasing a building, running internet connections, power, depreciation on automobiles, reimbursing traveling outdoor sales teams, etc, etc.

So while you made have made a purchase of DW, even if you don't use it for CRM purposes, you can still use it for your external website, intranet, testing HTML email campaigns and many other functions.  And sometimes businesses take risks and lose money because all of the details were not explained.  For that I would ask if you knew what you wanted to accomplish and did not have much web experience, did you talk to a sales professional regarding the app or even post here on the forums seeking advise of a product community as to whether the product would meet the needs of your business?

Look folks if you don't know how to create a dynamic website just say so but calling me arrogant because I don't want to acquire another monthly bill on something that can be created using DW and a web server is ludichrist.

Many people who travel this forum know how to create a dynamic website and could help you understand things on another level.  You can build Facebook or Amazon with Dreamweaver, but is there a "wizard" to do it for you.  The answer is absolutely not.  Dreamweaver is a tool like a hammer or a screwdriver, but it's specifically targeted at websites. It can help you accomplish a lot from a GUI and coding perspective that a traditional text editor, which many of us used early on in web development, failed to offer.  You were arrogant for stating something that helps you building your business would charge you money is simply outrageous.  The fact that you can just pass something off because it costs money.  Paypal works on a transaction basis charging you a percentage of a sale, are companies and payment processors not worth the money you pay them?  There are plenty of businesses who will tell you not to invest in Open Source because it's free and developed by the community and if the community dissolves, so does your business.  People are in business to make money and their products are not for everyone.  Companies like this exist and charge on a regular basis to lower your bandwidth costs but not having your employees constantly accessing data from your servers.  They charge monthly so that you don't have to worry about servers to store the application, the power for the data center, the redudancy in case of error or emergency.  Maybe arrogant was the wrong choice of word, but it is still fact that you wouldn't consider them because of a regular charge.

Where the idea that I work for a company that can afford sending me to school came from is also mystery. I never mentioned a word about a company at all. I asked a pretty basic question that even was commented that the question I asked had a simple solution. I believe that the solution is simple but what is the solution? Even the user who claimed that the solution was simple has failed to produce the simple solution directly.

You are right that we have no idea about the company and your situation.  You could be a freelancer for all we know.  In which case, did the company who hired you know of your situation and are willing to work with you? 

To the part about my solution to you, go back earlier in this post where I explain what you have given us and about learning the SQL query language.

If you have information to share and want to work through this post back.  If not, I will say it is a long road to learn web design and one that should be considered heavily with your interests, skillset and desire to continually learn in a field that changes as rapidly as web development has.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Aug 29, 2011 Aug 29, 2011
LATEST

This is not a support forum, it's anuser to user forum. It helps if you describe your problem in more detail. To say that you can insert a record and display it on a webpage, but can't do it a second time doesn't tell us much. Why can't you just repeat the same process for the second record? Or is it that the display page will only display the first record?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 28, 2011 Aug 28, 2011

Yes I also agreed originally until I looked into an already created system. The problem is that Salesforce software isn't something that can be purchased it can only be rented. The monthly payments are hundreds of dollars and no software is worth that kind of money.

Sugar CRM apears to be close with the exception of saving online forms that do calculation based on the input. Nothing so far has allowed me to do just one simple action. They seem to just dance around every useful task. The useful tasks just are not for sale.

I can use any suggestions to a prebuilt system that would do more than just log in a user and offer blank tabs. I can already use the database to allow a visitor to register and then sign in to their account and veiw their profile information but I can only update their information, If I could just add a second and third and fourth record then I would be in buisiness. I just can't seem to find this action other than from other websites that are up and going like this website does. This website remembers the threads that a user post which displays a link list of all availalble threads that the user posted. When the user logs in they go to the link "Your Stuff" and then click "Discussions" and a list appears of all the threads that they posted. Now I realize the phpBB would do this but I don't want to save a forum post just a form. I don't see that to be difficult but it is turning out to be.

What prebuilt software does this site use to get that option?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines