Search found 65 matches

by marnieg
Wed Sep 14, 2011 1:48 pm
Forum: PHP - Code
Topic: Uploading large file into database
Replies: 5
Views: 1162

Re: Uploading large file into database

I also have noticed that if my fields have any commas in them it is disrupting the insert statement. I have the fieldseparator in my script set to "," but I think it needs to be something else in the case where I have this situation. For example one of my fields is a text field. The origin...
by marnieg
Wed Sep 14, 2011 12:53 pm
Forum: PHP - Code
Topic: Uploading large file into database
Replies: 5
Views: 1162

Re: Uploading large file into database

I believe the issue is still with my php settings of variables. I reduced the size of my input file from 35,000 records to 20000 and the script worked. Therefore my script is correct I just need more direction on which variables are not set correctly. Again look at my phpinfo.php of my site and the ...
by marnieg
Wed Sep 14, 2011 12:18 pm
Forum: PHP - Code
Topic: Uploading large file into database
Replies: 5
Views: 1162

Re: Uploading large file into database

I have read about "Load Data" syntax but wasn't sure my hosting account would allow me to use that. I thought that was only allowed on dedicated servers, not shared hosting. I know that if I go into my database through my GoDaddy account and use phpmyadmin it has the option for "Load ...
by marnieg
Tue Sep 13, 2011 3:22 pm
Forum: PHP - Code
Topic: Uploading large file into database
Replies: 5
Views: 1162

Uploading large file into database

I have a script that is trying to read in a large csv file (7MB) and insert the data into my database (MySQL). I use the same script for smaller files and it works so I'm thinking it is one of my php variables not set high enough to read in the data. Here is my php5.ini file register_globals = on al...
by marnieg
Wed Aug 17, 2011 3:11 pm
Forum: PHP - Code
Topic: Reading local files
Replies: 1
Views: 186

Reading local files

I have a website where I want to prompt the user to select multiple files to be read which the code will then upload data into my MySQL database. Is it possible to prompt them for multiple files or do I have to do them individually? Currently the files are dbf files and I was going to use dbase_open...
by marnieg
Wed Jan 05, 2011 3:15 pm
Forum: PHP - Code
Topic: Getting Sum on multiple fields in one Select
Replies: 2
Views: 124

Re: Getting Sum on multiple fields in one Select

Thank you! I knew I could do multiple sums in the select but wasn't sure how to address them as individual variables.

This forum always comes through for me and in a timely manner. :D
by marnieg
Wed Jan 05, 2011 2:48 pm
Forum: PHP - Code
Topic: Getting Sum on multiple fields in one Select
Replies: 2
Views: 124

Getting Sum on multiple fields in one Select

I have several columns that I want the sum of based on a criteria. I want to place these individual sums into variables. Is it possible to do this in one Select statement. Here is a portion of my code. $stquery = "Select sum(ts_calc_st) from timesheets where ts_insp_id = $inspid and ts_wo_num =...
by marnieg
Mon Dec 13, 2010 12:56 pm
Forum: PHP - Code
Topic: Multiple record update testing checkbox
Replies: 3
Views: 156

Re: Multiple record update testing checkbox

The code you provided was almost perfect. Just

changed if($_POST['Approve']) to if($Approve)

and on the "where" statement you had an extract single quote at the end.

Thanks so much for your quick response. I can always count on this forum to get me past my little hurdles. :D
by marnieg
Mon Dec 13, 2010 11:04 am
Forum: PHP - Code
Topic: Multiple record update testing checkbox
Replies: 3
Views: 156

Multiple record update testing checkbox

I have a page where I'm listing some records. On each record I have added a checkbox. Then I have button for "Approve" where if they click it, then an update only on those records that have the checkbox set I want to update another field in my database. What is happening is when I click th...
by marnieg
Mon Dec 06, 2010 9:37 am
Forum: PHP - Code
Topic: saving parameters
Replies: 6
Views: 104

Re: saving parameters

I was able to resolve this using session_register variable for cust_id and then using the session variable in my query statement. I also had to use the unset of the variable on the page I came from so that a new variable could get loaded if the cust_id changed. Thank you for your suggestions. They p...
by marnieg
Fri Dec 03, 2010 2:01 pm
Forum: PHP - Code
Topic: saving parameters
Replies: 6
Views: 104

Re: saving parameters

It is being passed as a parameter from the previous page. Once I get to this page I want to keep it and continue passing it to my query.
by marnieg
Fri Dec 03, 2010 12:53 pm
Forum: PHP - Code
Topic: saving parameters
Replies: 6
Views: 104

Re: saving parameters

Sorry I was just tyring to bold the cust_id in my query to show where the variable in question. Here is the code without it. <form name="search" method="post" action="<?=$PHP_SELF?>"> <b>Seach for:</b> <input type="text" name="find" value='<?php echo...
by marnieg
Fri Dec 03, 2010 10:00 am
Forum: PHP - Code
Topic: saving parameters
Replies: 6
Views: 104

saving parameters

I have one page that passes a parameter to another page. For example http://mydomain.com/view_jobs_custwithsearch.php?cust_id=1 Once I get to the new page I have two forms. One displays the data from my database based on the parameter I sent it. The other is a form that I want the user to reset with...
by marnieg
Fri Dec 03, 2010 9:07 am
Forum: PHP - Code
Topic: redisplay search criteria
Replies: 3
Views: 1765

Re: redisplay search criteria

I figured out that you need to conditionally echo the field based on what was posted. here is my form changes for future reference to others having this problem. <form name="search" method="post" action="<?=$PHP_SELF?>"> <b>Seach for:</b> <input type="text" na...
by marnieg
Thu Dec 02, 2010 3:34 pm
Forum: PHP - Code
Topic: redisplay search criteria
Replies: 3
Views: 1765

redisplay search criteria

I have a page that displays data from the database. The user has option of entering some search criteria and reset the page. This works, but I'm losing the search criteria after the data is displayed. Here is a portion of my code with the two forms. <form name="search" method="post&qu...