-
Posts
4,362 -
Joined
-
Last visited
-
Days Won
11
Everything posted by Zane
-
make a phpfreaks minecraft server
-
This topic has been moved to CSS Help. http://www.phpfreaks.com/forums/index.php?topic=348337.0
-
Topic Name: How to store form array data to MySQL?
Zane replied to simplysandeep's topic in PHP Coding Help
The more you try to cram multiple questions with multiple possible answers with user data into ONE table, the more problems you will see in the future... or whenever someone else has to look at it. When you have multiples of anything, be it preferences, favorite video games, number of groups subscribed to, etc... you create a table strictly for those options. For example, in your situation, you would need - A table for users' info - A table for questions - A table for answers and most importantly - A table for users' answer to the questions. That's four tables.. In order to get that to work you'll need a many-to-many relationship. Here's a few links to help you understand http://www.tekstenuitleg.net/en/articles/software/database-design-tutorial/many-to-many.html http://www.tonymarston.net/php-mysql/many-to-many.html http://www.tomjewett.com/dbdesign/dbdesign.php?page=manymany.php -
No problem.. Glad you got it working.
-
I searched Google for send arabic mail php and this popped up http://stackoverflow.com/questions/2334935/how-do-i-send-emails-with-arabic-content-via-phps-mail-function
-
What exactly do you mean by freely publish..
-
So.. apparently after figuring out how to use $_GET variables, you received this error Which translates very easily to..
-
same here..
-
Not too sure what a .dmg is, but all you need is Filezilla and your credentials (username, password).. only difference is to select secure FTP from the list of connection types.
-
Godaddy didn't edit your HDD, they edited your server... which is what they do. the only applicable difference between FTP and SFTP is the port number used to connect... and the "S"
-
Parenthesis.. and... numbers are not strings.. so no need for quotes. SELECT campaign_details.pid,campaign_summary.uid,campaign_summary.customer_id FROM campaign_summary,campaign_details WHERE (campaign_summary.camp_id=campaign_details.camp_id) AND ( campaign_summary.uid=1 OR campaign_summary.uid=11 OR campaign_summary.customer_id=205 OR campaign_details.pid=7 ) GROUP BY campaign_details.pid1
-
Tool to display the localhost website files that have been accessed
Zane replied to mrherman's topic in PHP Coding Help
Install the firebug add-on for firefox. Once it's installed, look in the Net tab. Does exactly what you described. -
This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=348013.0
-
You would use a LEFT OUTER JOIN for this, with a WHERE clause. Also, it wouldn't hurt to assign aliases for easier coding. SELECT * FROM research_job_searches a LEFT OUTER JOIN research_job_searches_history b ON a.research_job_search_index=b.research_job_search_history_index WHERE b.research_job_search_history_index IS NULL Here's a great tutorial on JOINs, with pictures! http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
-
WHERE id_pk = '300000' Assuming id_pk is an INT field.. you should take 3000000 out of quotes.
-
This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=348006.0
-
You'd be better off using BCC headers if you're going to do a mass email. Calling the mail() function X amount of times will just make your script X times slower. BCC stands for Blind Carbon Copy if you didn't already know. if you want the other users to see all the subscribers then just use CC so for instance, with your code foreach($email_array as $recip_email) { $headers .= "\r\nBCC:" . $recip_email . "\r\n"; } Then just put the headers variable in your ONE mail function.
-
The syntax in CSS for class selectors is .banner .top add the dot and it should be fixed.
-
It is beyond me why you would store user information like that when you could just as easily create another field for every key you have listed there. Doing that would cut your projected row count by at least 75% if not more.. But if you really want to get data out like that, then you would just use a query to filter by userid.. then use a foreach to assign the values to a multidimensional array.
-
You can set max-width and min-width you know? http://reference.sitepoint.com/css/max-width
-
how to retrieve text area content to store to variable
Zane replied to mpsn's topic in PHP Coding Help
This can only happen if you code it to happen. Your form points to form.php on submit, now unless form.php is the same page the form is on then there is no other way to get that problem unless you are using a redirect EDIT : Oh ok. I see So the form and the script ARE on the same page. Why the big surprise? If you submit to the same page... of course the form will show up again. If you want to display XML data the user has typed in then you must submit to another file with XML headers. ... or just ... don't display the form again on submission and set the headers.. -
What I meant was, that currently, the switch statement only executes if $_GET['lang'] is set... and inside that switch you have the desired default value for cases when $_GET['lang'] doesn't exist. Metaphor time,... imagine you're in a hallway of doors.. You say to yourself, if (and ONLY if) I enter room 35, I will take a dump. Then when you enter room 35, you go to the bathroom and before dropping your load you say, "Well, if I entered room 36 I would have also taken a dump" ... What's the point of saying that since you're already in room 35? That's what you're doing with your isset right now.. You say, well, if there is a lang variable attached, then I will do this with it, but I will also make a case in case there is no lang.. Then directly after that, you do the same thing again.. but instead you assign it a value of zero.
-
You have your logic wrong.. Your script does the following... - First checks to see whether there is a query string.. - If true, the switch checks each possibility. Inside this switch, you have empty cases with no breaks.. you also have a default case.. - If there isn't a query string, $validlang is set to zero when it should have gone through the switch to get the default case. You need to first check for the querystring... set a flag or error or whatever.. THEN exit out of that if into the switch.
-
Seems to me that this is exactly what the OP wants.