I have a database in mysql5
There is a table which is created that way
------------------------------------------------------
CREATE TABLE `mytable`.`profile_values` (
`fid` int(10) u...
I am able to connect with root login, but it puts this warning to me: Cookies must be enabled past this point.
On each navigator, on different stations, I always have the warning.
Howev...
i have declare a global value that contains the database connection then use another function call that function value but it doesn't seem to work.
here is the code
function openConnection(...
When I run the attached select statement, it totally ignores my first where condition (afield='ab'), and possibly the second and third conditions (bfield = 'ab', bfield='AB'). The only one I ...
Hi,
I need to add custom text to PDF files before the user downloads them using PHP. How can I do this? I would stream the PDF using a custom PHP. I have users who would download PDF files ...
i would like to allow user enter any kind of string then retrieve it from database and display it on the web for instance, if they enter <a href="http://www.yahoo.com">click here</a> then when...
Hi Team,
I have a txt file which is automatically created every night from an accounting package I am using. It uses a CSV format. On the following link it describes perfectly how to get a ...
I have a function. It only deals with numbers that end in .00 or .50. When I total something and it comes to 27.50, it only shows 27.5. How do I get it to show the last 0?
function CalcTotal ...
I need to redirect pages if a db table is updated with user clicking the form submit button.
Also, I need an alert box popping up before redirect, so that the user is not suddenly plunged int...
Simple question, when someone posts an apostrophe ' into a text box. How do I insert the apostrophe into a database? I build up a string and use mysql_query to put into the database. My rea...
I need to have six checkbox values (Housing) concatenated together to be inserting into one field in the database.
I am trying to determine the best practice with specific sql queries/commands for exporting Mysql data to CSV's editing the data and then re-importing it.
I'd like to do the following:
E...
I'm working on implementing a autocompelete search box that is referenced at http://nodstrum.com/2007/09/19/autocompleter. The script was written to work in PHP 5 and my server is only runnin...
I have informix DB in an alpha server installed by previous engineer. I can connect to that database from the shell cmd 'dbaccess dwh@ids_dwh' and query.
In a separate machine I have setup ...
I'm using fgetcsv to import data into mysql but the csv is corrupt and I had to find a way to fix it.
The attached code is what I'm using to fix the data but when I correct the line, $ne...
I have an exisitng web app written in PHP, that allows the user to upload a csv file and it imports the data into a mysql table.
My client is now complaining about converting xls files to c...
Hello, I have a (hopefully) simple but very specific question regarding database management.
I have a single MySQL database containing all of the relevant tables for a live Joomla installatio...
I have a php script that works perfectly, IF there are PDF files in the directory. IF there are PDF files in the directory, my script merges them all into one pdf, using pdftk copies the merg...
I tried inserting this number '5856371059987338' into the database as an integer but it changed the number on me. When I set it to big integer it worked.
What's the difference? Couldnt find...
Code is:
<?php
//start Trigger_Inlog trigger
function Trigger_Inlog(&$tNG) {
global $conn_cartweavermysql,$database_conn_cartweavermysql;
mysql_select_db($database_conn_cartweavermysql, ...
Is there an equivalent function of "mysql_real_escape_string()" if I have SQL Server backend?
Thanks.
I would like to parse data from the url string
e.g. www.mysite.com/testpage.php/somedata . . . ?var=someting else
I only want to :grab" the testpage.php, and create
newphpvariable = t...
I am using the explode function to extract data from a csv file.
I have done this MANY times before.
Here are the first few lines of code:
$open = fopen($thefile, "r");
if($open) {
...
Hello,
I'm looking for a simple php script I can drop into a folder and it will auto generate an album of all the current folder images.
I do not want to configure it
I do not want to spend...
I'm new to PHP so bare with me. I have an input table that the user can dynamically add rows to (via Javascript) in order to submit, then use PHP to populate a MySQL table. I'm having a prob...
