PHP Developers Network

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...

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 ...

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 ...

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...

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...

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.

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 =...

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.

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...

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...

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.

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...

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...

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...

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...