JayD

Hi all, I am currently building an eCommerce site for an art gallery that want to sell their items online. I am building the site using PHP and mySQL but have little experience with databases. I was wondering if anyone could tell me how many databases I would likely need. The online shop will sell their whole image catalog, with variations in size and print material. i.e. canvas or paper, A4-A0. Ideally the site will allow user sign-up and login. Does anyone have any experience doing a site like this and have any indication of how many db's I'll need? Thanks in advance, Jay

Hi all, I appreciate that many of these questions abou commerce have already been answered but I would appreciate any input. My CSS and HTML skills are good, yet I have to build a gallery site for a friend and was wondering the best approach as my PHP and MySQL are limited. As each item is a print, with various sizes etc, there needs to be check boxes or radio buttons for each variation. Does this therefor mean I will need to use somthing like osCommerce that will build the php for me, and I just have to try and alter to give it the desired look? I had considered my hosts check-out system but as each item has variation options that need to be held (I think they would be sessions in php??), the whole site would need to be in php anyway wouldnt it? In an ideal world, there would be a free, fully functional shop that is fully customisable using my front end skills. Does such a thing exist??? Thanks in advance. Jay

Hey, with regards to your questions: 1. Prints and canvases 2. Hundreds 3. All of the above (if possible) 4. Not for the time being 5. Ideally yes. Does this help?? Jay

Hi all, I am currently building a gallery site, which I ultimately would like to take payments on. Here lies my dilema; Do I look to use something like OS-Commerce, adpating all the code myself, or would it be easier to use, say for example my hosts merchant tools to process payment? Or is there an alternative more efficient or simpler way? Any guidance or advice would be great. Cheers, Jay.

I have two books myself, they just dont have anything specific on forums. If the "everyday apps for dummies" book has a guide on building a forum I might look into getting that aswell. I know what you mean, this isnt gonna b easy, hence the plea for help. ha ha. Jay

Hi Guys, I have to create a Forum in ASP.NET yet have limited knowledge in the area. I have Visual studio and all I need to build it, I just need to know the best way to go about it. Where should I start? Does anyone know of any tutorials or have any advice. I would be very greatful!! N.B. As this is a project I cannot use automated build tools. It has to be my own work. Thanx in advance, Jay

Ideally I would like to produce some statistical results based on the given anwers each individual give. I relise however that this may prove to be difficult and very time consuming, so a simple results page based on their answers would suffice. Jay

Perhaps I could use that as a starting point. The issue I have however, is that I am using a scale. I.e. 1. I strongly agree. 2. I agree. 3. Not sure. 4. I disagree. 5. I stronly disagree. with a set of questions. Any suggestions how I would go approach this!! Jay

Hi all, really hope someone can help!? I would like to build a questionnaire in php. At this point, I really am unsure of how to go about it. I hav basic knowledge of php but would really like to kno the best way to approach it. Any suggestions/hints/info would be very greatly recieved. Cheers guys. Jay

Hi all, I am currently embarking on my final year of studying internet technology and as part of my final year project I am taking a psychological research piece and making it electronic. My major hurdle is that I wish to create a questionnaire, which up until now has been paper based, and make it electronic. I am thinking of designing the sight in ASP.NET or PHP. Does anyone have any suggestions on the best way to go about this, what would be the best approach, asp or php? The questionaire takes the form of a scale, in the sense that there are two statements at either end and the participant has to indicate with which they agree. I have attached an example of the test. The questionnaire would not nessissarily need 2 look like this but hold the same principals in terms of structure. Any advise or info you guys could spare would be brilliant. Thanx guys. Jay.

Hi all. I have designed a website in html, however it is a store, so I have just installed OS Commerce on my server. Do I have to go through and edit each piece of PHP supplied by the OS Commerce in order to make it look like my site??? Being that I'm fairly new to PHP, are there no easier ways? Thanks in advance. Jay

Hi all. I have designed a website in html, however it is a store, so I have just installed OS Commerce on my server. Do I have to go through and edit each piece of PHP supplied by the OS Commerce in order to make it look like my site??? Being that I'm fairly new to PHP, are there no easier ways? Thanks in advance. Jay

I have tried this and moved my usb 2 another computer and simply right clicked and it let me delete the file??

Hi Guys, I'm not sure if anyone can help me but I am trying to make some files on a usb stick protected. In other words I want the files to be readable but immovable. Does anyone know how I go about this? Thanx, Jay

Hey guys, I have a query, is it possible to send the information that a user would fill in, in a form, to an email address? If so, how would I go about it? Cheers, Jay.

Yeah got it working fine, thanx 4 all ur help. I do however, have another query, do you know how i would go about sending a completed form in an email? So once the submit button is pressed, the information filled in in the fields, will b emailed. Cheers, Jay.

Yeah Gibbs you were right, thats pretty much what I came up with. Thanx.

Ok so if I wanted to to convert that code to work for an image called 'rugbyshirt' in a folder called 'images', stord in my website directory, how would I go about it? Cheers, Jay????

Sorry guys, posted in the wrong forum!! OOOOPS

Hi guys, I currently have a table displaying items from a mysql database. I would also like to add images to the table. I have an images folder already in the same web directory as all my pages, containing the images I would like to display. What code do I need to use to display these images in the table? My code is currently as follows: <?php // Connect to MYSQL and Select database $dbc = mysql_connect (*********,'****','*********') OR die('Could not connect to MySQL : ' . mysql_error() ); mysql_select_db ('cse') OR die('Could not select the database : ' . mysql_error() ); // Perform SQL query $query = "SELECT * FROM harrison_catergories WHERE Cat_id = 1"; $result = mysql_query ($query); ?> </p> <table width="700" border="1"> <tr> <td width="120" height="32"><strong>Item</strong></td> <td width="412"><strong>Description</strong></td> <td width="70"><strong>Cost</strong></td> <td width="70"><strong>Stock</strong></td> <td width="70"><strong>Purchase</strong></td> </tr> <?php while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { Echo "<tr><td>$row[item]</td><td>$row[Description]</td><td>$row[Cost]</td><td>$row[stock]</td><td><a href = 'purchase.php$row[Purchase]'>Buy</a></td></tr>\n"; } mysql_close(); ?> Cheers guys, hope sum1 can help me out? Jay

Hi guys, I currently have a table displaying items from a mysql database. I would also like to add images to the table. I have an images folder already in the same web directory as all my pages, containing the images I would like to display. What code do I need to use to display these images in the table? My code is currently as follows: <?php // Connect to MYSQL and Select database $dbc = mysql_connect (*********,'****','*********') OR die('Could not connect to MySQL : ' . mysql_error() ); mysql_select_db ('cse') OR die('Could not select the database : ' . mysql_error() ); // Perform SQL query $query = "SELECT * FROM harrison_catergories WHERE Cat_id = 1"; $result = mysql_query ($query); ?> </p> <table width="700" border="1"> <tr> <td width="120" height="32"><strong>Item</strong></td> <td width="412"><strong>Description</strong></td> <td width="70"><strong>Cost</strong></td> <td width="70"><strong>Stock</strong></td> <td width="70"><strong>Purchase</strong></td> </tr> <?php while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { Echo "<tr><td>$row[item]</td><td>$row[Description]</td><td>$row[Cost]</td><td>$row[stock]</td><td><a href = 'purchase.php$row[Purchase]'>Buy</a></td></tr>\n"; } mysql_close(); ?> Cheers guys, hope sum1 can help me out? Jay

Could you ellaborate a little. How would I set the values for the action?

Yeah I'm gettin multiple: Notice: Undefined index: yourname in ********.php on line 105 Notice: Undefined index: first_name in *******.php on line 106 Notice: Undefined index: address in *******.php on line 107 Notice: Undefined index: phone in *******.php on line 108 Notice: Undefined index: action in *******.php on line 111 Notice: Undefined index: action in *******.php on line 117 Notice: Undefined index: action in *******.php on line 123 These are the line in the code: Cheers, Jay.

Hi guys, I'm new to PHP and I'm trying to create a form that can read, alter and delete addresses from a database. However I am getting a: Notice: Undefined index: action in...... The code I have is as follows: <?php $name = $_POST['yourname']; $firstname = $_POST['first_name']; $address = $_POST['address']; $phone = $_POST['phone']; $dbc = mysql_connect (*************.com','***','*****') OR die('Could not connect to MySQL : ' . mysql_error() ); mysql_select_db ('cse') OR die('Could note select the database : ' . mysql_error() ); if ($_POST[('action')] == 'ddbase') { $query = "DELETE FROM harrison_addresses WHERE Name = '$name'"; $result = mysql_query ($query); echo 'The information has been deleted from the database'; } elseif ($_POST[('action')] == 'adbase') { $query = "INSERT INTO harrison_addresses (Name,First_Name,Address,Phone) VALUES ('$name','$firstname','$address','$phone')"; $result = mysql_query ($query); echo 'The information has been added to the database'; } elseif ($_POST[('action')] == 'cdbase') { $query = "UPDATE harrison_addresses SET First_Name='$firstname', Address='$address', Phone= '$phone' WHERE Name='$name'"; $result = mysql_query ($query); echo 'The information has been changed in the database'; } $query = "SELECT * FROM harrison_addresses ORDER BY Name"; $result = mysql_query ($query); ?> </p> <table width="718" border="1"> <tr> <td width="132"><strong>Name</strong></td> <td width="132"><strong>First Name </strong></td> <td width="244"><strong>Address </strong></td> <td width="182"><strong>Phone</strong></td> </tr> <?php while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { echo "<tr><td>$row[Name]</td><td>$row[First_Name]</td><td>$row[Address]</td><td>$row[Phone]</td></tr>\n"; } mysql_close(); ?> Hope someone can help. Cheers guys, Jay. :-)