I need a program or script that resides on a Linux server that can open an excel csv file, convert it to csv and save the csv file.
I understand the OpenOffice can be used via PHP.
Does ...
Hi,
I am having a problem with an include file which controls access and session start for several pages.
I am having problem particularly with two pages, 2nd and 3rd pages are giving the fo...
Hi,
I´m using a system A which was written with the help of phpdbform.
The script A is hosted in a directory and produces a downloadable CSV file as an output.
I installed a new applica...
Hi,
I am trying to load an external text file into HTML (main reason is so the owner of the site can just update the text files) and I don't know how to get line breaks, so that the text...
I am new to this so forgive me if the terminology or question is correct.
I am using a PHP cURL application and I want to validate the specific domain SSL certificate which is installed on ...
The script creates an image and then displays it in a browser window. I need to also save the image in the directory, however I need it to save as a random filename, I can get the random file ...
I am trying to connect to a sql server (2005) using this:
<?php
$myServer = "cms";
$myUser = "mjarratt";
$myPass = "test123";
$myDB = "traffic";
//connection to the database
$dbhand...
I have a script that is being used as a commit-hook for a subversion repository on another server.
I have tried using system, shell, shell_exec and passthru to run the svn update command.
...
Hello,
This is a follow on prom my previous question.
I have attempted to embed two levels of if statements in each case of a switch statement.
I get the following parse error:
Parse erro...
I am looking for a method to save a html page created with php and a mysql query into a fully formatted Excel document and PDF document. I am open to purchasing and installing scripts/applica...
Ok I would like to create something like the code below that Verifies the fields before sending the message, but I would like to take this one step further and after the fields are verified to...
Hello all, thanks for reading this, im kind of new in javascript and php but im getting the grip of it, i just need a quick answer to this question to see if it is possible.
I have a form w...
Hello expert,
In MySQL you can use the LEFT() string function to select a set number of characters from the left of a particular data column.
My query is working well but I would like to...
I keep getting the following error message when I call the mysqli function real_scape_string as shown in the code below:
"Fatal error: Call to a member function real_escape_string() on a no...
I have 2 mysql tables in mysql database
1. favorites .. shows friends list
for example user_id "42" had 2 friends "41" and "44" user_id.
2. second table records data relating to user_i...
Speaking as an ASP/VBscript developer this is very easy, for example:
<% if var = 1 then %>
....lots of HTML...
<% else %>
...lots of HTML...
<% end if %>
but when I do the ...
I am writing a page that a user would be able to view their password in plain text (actually, this is for the site administrator), instead of in the MD5 encryption. I am able to CREATE the pa...
Hi, I've created a simple form and all I want is:
- If the request isn't a form submission, show the form.
- If the request is a form submission, check for required fields and validate the s...
I have created a form that has a drop down list (Called ExistingFacility)which is populated by a collumn in a MySQL database. The form is being used to either write a new row to the database, ...
Hi i am using php and mySql to create a registration form which adds itself to a database:
When I send the form it gives me this error:
Invalid query: Unknown column 'sVisit' in 'field l...
1) I am not sure if I have this syntax correct, specifically lines 5 and 6.
2) Also, in line 6 I want it to search all region_ids if null, otherwise search specific region_id. Is line 6 doi...
Not being very well versed in PHP and MySQL I'm not sure where to turn with this issue. I use joomla 1.53 for our website and it has been a great experience all in all. The only problem I am e...
I'm working to get a login script that connects to a mysql database set up. I believe i got a good config.php and opendb.php set up already, and the login.php also seems to look right.
I ju...
$sql .= " FROM REQUEST WHERE STATUS = 'S' and LAUNCH='No' and TITLE != null ORDER BY NUMBER DESC";
i want to use the above qry in my php code to pull all records where the TITLE is not emp...
MYSQL PHP
Hello,
I have a date field and a time field in my MySQL database table, i.e.
[date] [time] [title] [contents]
How do I code the mysql query in a PHP file to output X days Y...
