djfox
Members-
Posts
327 -
Joined
-
Last visited
Never
Everything posted by djfox
-
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
Maybe I need to reword my question: What is LEFT JOIN doing? -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
What is the LEFT JOIN stuff? -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
I`ve already long since got the database stuff, now it`s the code I need. I`ve looked over the code you provided but I am not getting it. I`ve been trying to explain many times that I`m not understanding what it is being said and I`m not seeing how this can be done in one form, and yet the database structure keeps getting brought up, but that isn`t helping me understand how the code is going to get done. I can`t spend money to have someone else do it, I`m poor, or else I would`ve just hired someone else to do it for me and would`ve skipped all this (I`m not getting paid to have this code done anyhow). -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
So anyone going to give me a hand with the code? -
$_get is not retrieving my variable from the URL
djfox replied to piscatorhominum's topic in PHP Coding Help
Are you testing this script off your harddrive or do you have it uploaded onto a server? -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
No see, we -want- that history. That`s why I was trying to get this stuff entered into the database in the first place. The thing is to get the pets and services selected and chosen in one form, which will automatically create the history and the invoice would be built from that, rather than making copy A into history and copy B in invoice. What I wanna do is get it all done with just the one form. I can get the pets from the one customer to show up. I can get the list of services to show up. What I can`t do, is get all that to enter into the database with that one click of the submit button. -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
@ChemicalBliss My lack of being able to understand continues. For each service that has to be done with each pet, a new entry has to be made into the whatever database table? Wouldn`t this mean that still a form has to be entered for each service for each pet? I`m not seeing how in a list of pets each with a list of services could be done in one form. -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
I`ve looked it over but I don`t see how that could possibly be done in one form. I can only see it being done with multiple forms. -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
Yep, that`s the proper way to help me understand things... I`m having an extremely difficult time understanding what it is that you guys are trying to tell me to do. All I can get out is that more tables have to be made and the clerk has to fill out multiple forms. That`s all that I`m getting from here. -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
What? I don`t know what that is or how to do it. Haven`t a clue of what that is either. Ok but wouldn`t this still require the clerk to sit there and fill out form after form after form just for one single client to do EACH job for a pet, and then do it all over again for their second pet, etc? -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
Why? What do I need it for? What does that do? What kind do I go for? I`ve searched on this and all I`m finding are sources on books to buy, I can`t find anything online. Now I`m getting frustrated about trying to get this project done and no one here is making any sense or providing anything that is actually being helpful. -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
Sorry to say that I haven`t a single clue of what it is you`re trying to explain to me to do. I`ve read over that post 6 times, read over your second post twice, I am not getting it at all. -
How to enter each post together in one field for the database via form?
djfox replied to djfox's topic in PHP Coding Help
@Thorpe: Your post tells me nothing. @ChemicalBliss: Wait wait wait, are you telling me that the best way to do this is to have the clerk go through and do something like: Create an invoice Select Owner 1 Select Pet A Select Service A Create an invoice Select Owner 1 Select Pet A Select Service B Create an invoice Select Owner 1 Select Pet A Select Service C Create an invoice Select Owner 1 Select Pet B Select Service A Etc etc etc? That`s ridiculous! Not to mention VERY inefficient for a business! Vet offices and other professional places do not do this. Second of all, you`re telling me to rebuild my owner and pets tables and rebuild how the owners pets are id`ed to the owner? Why? My system of bringing up the owner`s pets are working just fine. Unless I have TOTALLY misunderstood everything you`ve written...Which is quite possible. -
Ok, this line: $sql="UPDATE players SET displayname = '$displayname', campname = '$campname', WHERE id='$id'"; Change it to: $sql="UPDATE players SET displayname = '$displayname', campname = '$campname' WHERE id='$id'"; You have an extra comma that shouldn`t be there.
-
I don`t see anywhere in your code that $displayname $campname and $id are picked up on for the system. You would need to add in $displayname = $_GET['displayname']; $campname = $_GET['campname']; $id = $_GET['id']; If you`re using post method for the form on the previous page, then replace GET with POST. Without specifying those before you tell the system to add them in, the system won`t know what it`s supposed to grab.
-
I`m working on this invoice creator for work, and I`m having a bit of trouble for this one function. I have created a checkbox list of services a clerk can check off that the customer wants to have done and another checkbox list of which of their pets is involved (for those who have multiple pets). I have the form to send each checked entry to the next page just fine. However, I want the entries to go into the database in one field. For example, for the checkboxes of the pets, it should list off 23,24,25,26 in a single field "pets", while the services 1,2,3,4 should be in another single field together. Right now I can only get it to list off each entry of the checkboxes that have been made. But I have no idea how I can get them into the database. Here is the form invoice_start.php <?php //Date: June 30 2010 $Title = "Start an Invoice"; require_once "header.php"; require_once "parsecomment.php"; session_start(); $id = $_GET['id']; $res = mysql_query("SELECT id, name, homephone, street, city, state, zip, cellphone, workphone, date FROM customer WHERE id='$id'"); $rows = mysql_fetch_row($res); mysql_free_result($res); $name = "Start an Invoice for $rows[1]"; include "box_start.php"; echo "Use this form to start an invoice for services for a customer. You will still have to use the register system to add in the costs to the system, but this will track what services were done in the past for a customer, create a record of what critters are currently boarding and will allow to print a nice invoice for customers to take home."; echo "<p>"; echo "<form action='invoice_start2.php' method='post'>"; echo "<input type='hidden' name='customer' value='$id'>"; echo "<table border=0 width=100%>"; echo "<tr>"; echo "<td valign=top width=50%>"; echo "<b>Check all pets that apply to this invoice:</b>"; echo "<br>"; $query = "SELECT id, name, species FROM pets WHERE customer='$id' ORDER BY name ASC"; $result = mysql_query($query)or die( mysql_error() . "<HR>".$query); while($chap = mysql_fetch_row($result)){ echo "<input type='checkbox' name='POLL[".$chap[0]."]'> $chap[1] <br>"; } echo "<td valign=top width=50%>"; echo "<b>Check all pets that apply to this invoice:</b>"; echo "<br>"; $query2 = "SELECT id, breed, type, cost FROM groom_prices ORDER BY type ASC"; $result2 = mysql_query($query2)or die( mysql_error() . "<HR>".$query2); while($chap2 = mysql_fetch_row($result2)){ echo "<input type='checkbox' name='COST[".$chap2[0]."]'> <b>$chap2[2]</b> <i>$chap2[1]</i> @ $ $chap2[3]<br>"; } echo "</table>"; echo "<p>"; echo "<b>Any Additional Products or Other Purchases, enter the amount (including tax), do NOT enter the $ symbol.</b>"; echo "<br><input type='text' name='add' size=75 maxlength=100>"; echo "<p>"; echo "<b>Any Additional Notes to Be Made in regards to today`s service or any notes to be made to customer:</b>"; echo "<br><textarea rows=6 cols=60 name='bod'></textarea>"; echo "<p>"; echo "<input type='submit' name='submit' value='Start Invoice'>"; echo "<input type='reset' name='reset' value='Clear Form'>"; echo "</form>"; include "box_end.php"; ?> <p> <?php include "footer.php"; ?> Here is what I have for invoice_start2.php so far (I don`t know how to continue it: <?php //Date: June 30 2010 $Title = "Start an Invoice"; require_once "header.php"; require_once "parsecomment.php"; session_start(); $name = "Start an Invoice"; include "box_start.php"; echo "Use this form to start an invoice for services for a customer. You will still have to use the register system to add in the costs to the system, but this will track what services were done in the past for a customer, create a record of what critters are currently boarding and will allow to print a nice invoice for customers to take home."; echo "<p>"; $id = $_POST['customer']; $add = $_POST['add']; $bod = $_POST['bod']; echo "ID: $id <br>Additional: $add <br>Notes: $bod<p>"; foreach($_POST['POLL'] As $PollItem=>$PollValue){ $poll = $PollItem; echo "$poll<br>"; } echo "<p>"; foreach($_POST['COST'] As $CostItem=>$CostValue){ $cost = $CostItem; echo "$cost<br>"; } echo "<p>"; echo $_POST['POLL']; include "box_end.php"; ?> <p> <?php include "footer.php"; ?> The database I have setup for the invoice, the fields are: id (int) customer (int) date (varchar) pets (text) services (text) additional (int) notes (text) How do I get this entered into the database?
-
But how would I do that?
-
I know there is a way to do it. No one here knows how?
-
I`m no expert, but I would think that means that when you set up the database table, you made two or more entries primary when only one needs to be primary.
-
My site allows for registered users to upload images to the site under their own gallery. Currently it just leaves the file named as however the person has it named. But what I would like to do is something another site does, which is rename the files when the user uploads them. An example of how I would like it done: A user whose username is "I Like Cheese" uploads a file named "whatever.jpg", but in the uploading form, they title the upload "Dog In the Rain". I`d like like "whatever.jpg" to be renamed to "Dog In the Rain_by_I Like Cheese.jpg" upon the upload process and use that new filename for the database information. How would I tell the system to rename the image file in that manner?
-
I`m working on a new category system for the submissions to my website. The new system is broken down into two different database tables. I know the basics of creating a form and have the original drop down selection of the form for the old category system. But for this one, what I want to do is have one select drop down menu with a list (digital, traditional, photography, etc) and depending on what the user selects there, another menu will appear containing the subcategories that belong under the first selection (ie, if they choose digital, they`ll get abstract, wallpaper, fan art, but if they choose photography, they`d get wallpaper, animals, landscape). How can this be done? I`ve looked around online, googling all day but can`t find anything that is like what I`m looking for.
-
They`re not the kind I had done before, these are wildly different. But if it`s possible to get it to execute a php file, as the link shows, then that will be a better (and much easier) alternative.
-
My server has suddenly decided to erase all of my cron jobs. I had several but didn`t save any so I have to re-write them all. However, because I`m not an expert with them, I don`t remember how to write them. Can someone give me an example?
-
Aw man. Ok, maybe I can cook up another way then to get something similar.
-
I thought that png would be best because it has the transparency of gif and the colour pallet of jpg and unlike gif, the edges aren`t pixely and jagged..