table (you can use the framework in many applications) and its secure.
Basically you build an admin area, whereby some trusted users have admin
privileges and assign those to various users. The permissions themselves are
simply yes/no fields, assigned with checkboxes or radio buttons.
Bast
you can use over and over if its well designed,
Bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Passing URL parameters, how to hide
Date: Tue, 21 Sep 2
When I
> request "update.php?recordID=2", you should be doing
> something like "SELECT
> * FROM Record_Table WHERE recordID = 2 AND userID =
> 3", which will not
> return any rows.
Okay that makes sense I will try that. Though I'd
imagine the SQL will need to be different since I
could be dealing
Thats why I said CAN, since it is unreliable
Bastien
From: "John Holmes" <[EMAIL PROTECTED]>
To: "Bastien Koert"
<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] Pa
Sounds about right...I would use the session variable for the user name so
that is not even present...but that is the result that you want...
Bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
[EMAIL PROTECTED]
CC: [EMA
No, No, NO!
The user id should not be in the hidden elements in the form.
You need to store that in a session variable for the duration of that user's
session. Otherwise they can try to hack by changing the combination until
they hit another valid record.
Bastien
From: Stuart Felenstein <[EMAIL
they are in the extensions folder in the php folder.
From: "Saeid Banaei" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] Where can I download the php_oci8.dll and ph_oracle.dll ?
Date: Tue, 21 Sep 2004 14:30:10 -0400
Hi,
I am trying to use the PHP in windows, IIS environment to acce
need to have AND between states and jobs
select * from tablename where (jobs='accounting' or jobs='bookkeeping') and
(state = 'AL' or state='CA')
Bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MultSelect ListBox hell! Date: Wed, 22 Sep 2004 05:19:36
-0
if ($x == 0){
$sql.= "job = '$job ";
$x=1;
}else{
$sql .= " OR job = '$job ";
}
$sql .= ")";
}else{
//$_POST['job'] is not an array
$sql .= "job = '".$_POST['job']."' ";
Could be a scope problem. The connection is declared outside the function
and the attempt to run a query is inside the function...Maybe add the global
command to the connection. Or declare the connection inside the function...
Bastien
From: Antoine <[EMAIL PROTECTED]>
Reply-To: Antoine <[EMAIL P
www.fabforce.net -> dbdesigner...great tool and free
bastien
From: Matthew Perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ER diagram class
Date: Mon, 11 Oct 2004 18:03:11 -0500
Does anyone know a good class or program that automatically generates an ER
diagram from all tables i
You'd need to parse out the email (or at least the subject of that email)
then find a file based on that subject, then email the file...it is
possible. I wrote a script to parse out emails, you can find it at
weberdev.com in the php examples area (look for my name).
hth
Bastien
From: "Kenny Fr
use the headers
header("Content-Length: ".filesize($filepath));
header("Content-type: application/octet-stream");
header("Content-disposition: $attachment filename={$newfile}");
header("Content-Transfer-Encoding: binary");
readfile($filepath);
bastien
From: "Adil" <[EMAIL PROTECTED]>
To: [EMAIL PRO
echo out the sql just before you execute it when doing the delete, ensure
that the values that you are expecting to be deleted are being deleted
bastien
From: "Adil" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] deleting multiiple records from database
Date: Wed, 13 Oct 2004 16:11:
If you are usiing the INNOdb table type/engine in the mysql db, it supports
transactions. you can wrap the entire set of sql statement in a transaction
and they would get executed as one block. If any fail, then the whole thing
is rolled back. This DOES NOT work with the myISAM table types.
$sq
did you look to see what the data format was? many of these calendars fill
in american dates (mm-dd-) and mysql prefers (-mm-dd)check to
see what the format is before you assign it to the session id...
bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject:
www.fpdf.org
bastien
From: "balwantsingh" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] pdf
Date: Fri, 15 Oct 2004 13:53:00 +0530
hi all,
i want to how i can save the data retrieved from mysql through php in pdf
format.
thanks for your help in advance.
Have a look at some of the case studies at mysql.comthere are servers
handling 50Million records with not problemsat a certain point it
becomes more a hardware issue than a db server issue...
bastien
From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
yes, you can have multiple submit buttons, you would simply need to test for
the value of that button on the server
if ($_POST['submit']=="delete"){
//delete something
}
if ($_POST['submit']=="update"){
//update something
}
and so one
hth
Bastien
From: "Ron Piggott" <[EMAIL PROTECTED]>
To: "P
skip the two step process and use RAND in the sql statement
SELECT * FROM table1, table2 WHERE a=b AND c
bastien
From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: [PHP-DB] How to optimize select of random record in DB ?
Date: Fri, 15 Oct 2004 07:41:44 +02
4.1 is supposed to handle them, how well is another issue
bastien
From: Matthew Perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL nested subqueries
Date: Sat, 16 Oct 2004 18:30:56 -0500
Anyone know when there will be a version of MySQL that can handle nested
subqueries?
-Mat
you can execute scripts as cron jobs. what is the OS?
Note that for cron jobs you should not have browser based output...any
output, errors, etc should be sent to a file.
bastien
From: Matthew Perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP functions independant executions
You need to use pg_result_error or pg_last_error. Generally, you code to run
the query, in the next line you check for an error and pass the error off to
some error handling function
ie
$result = pg_query($sql);
if (pg_last_error($result) == false){ //here was an error
$error = pg_last_error($
try checking for the value
if (isset($_POST["op"] != "addpost")) {
or to supress the error, use the '@' symbol in fron of the $_POST or $_GET
if (@$_POST["op"] != "addpost") {
Bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] error
Date: Tue, 28 Sep 2004 06:58:10 EDT
Dear frie
why not do a search and replace on the way out to the browser?
$text = str_replace("\r,"",$text);
...
echo $text;
...
?>
bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Convert plain text to HTML tagged text
Date: Tue, 28 Sep 2004 17:15:24 +
To the list:
I've googled an
if the tables have the same structure, use the union operator to query each
table separately and return it all in one result set
select * from asset1 where asset_loc='heaven'
union
select * from asset2 where asset_loc='heaven'
union
select * from asset3 where asset_loc='heaven'
union
select * fro
What you could do is separate the sql string into parts, the initial call
select * from table where 1=1
the where clause(s)
and job_type = 1 or job_type = 2
and then save the where clause tied in some way to the individuals record.
Then a cron job can go thru the recordset from this table and exec
here is something similar. you should be able to adapt this easily
//Google like search engine for your site,
//the $not_search_word array can be added to,
//to limit the results even further for those
//common words that should not be searched for.
foreach ($searchwords as $word) {
/*
For e
The MYI file is the index file. Is there an index on that table?
From: [EMAIL PROTECTED] (Jennifer Goodie)
To: blackwater dev <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], Subject: Re: [PHP-DB] rand()
Date: Wed, 29 Sep 2004 23:27:43 +
-- Original message from blackwater dev :
Here is a basic connect script. I would stringly recommend against using
access, use mysql instead.
// Program to test connecting to a Microsoft Access ODBC Data Source
$connection = odbc_connect("postcard", "", "");
print "Connected to datasource";
if ($result = od
Do you have indexes on the searched columns?
Are you searching on numeric links not text (numbers are easier to compare)
What is your structure / data like?
Bastien
From: "Murat BIYIKLI" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL performance and crash
Date: Fri, 1 Oct 2004 1
http://ca3.php.net/manual/en/function.session-set-cookie-params.php is what
you need to look at.
set_time_limit only sets a time limit for the script itself. it does not
affect the sessions
bastien
From: Philip Thompson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Setting a time
just run them in order
$test=str_replace(...);
$test=str_replace(...);
$test=str_replace(...);
$test=str_replace(...);
bastien
From: GH <[EMAIL PROTECTED]>
Reply-To: GH <[EMAIL PROTECTED]>
To: Felipe Alcacibar <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Convert plain text t
Have you talked to the dba to see if the Oracle DB will accept more than one
thread from the apache server?
Bastien
From: Christopher Jones <[EMAIL PROTECTED]>
To: Chris Back <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Multiple Oracle connections
Date: Mon, 04 Oct 2004 16:44:
try using utf-8 character encoding, see
http://dev.mysql.com/doc/mysql/en/Charset-Unicode-sets.html
bastien
From: [EMAIL PROTECTED]
To: "Dre" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Arabic characters displayed as garbage !!
Date: Mon, 4 Oct 2004 14:36:01 +1300 (NZDT)
By d
I've used it sucessfully many times. It may the other person's unfamiliarity
with arrays and variables
I created the below function which will handle both single choice and
multiple choice drop down values and mark them as selected when the user
views that drop down again.
bastien
function my
Write a small script that runs the sp, then create a cron job that fires off
that page/script at whatever your set time requirements are
bastien
From: "Norma Ramirez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] Postgres Trigger
Date: Mon, 4 Oct 2004 08:41:50 -0500
Hi!
Does any
I created the below function which will handle both single choice and
multiple choice drop down values and mark them as selected when the user
views that drop down again.
bastien
function my_select($name,$rows,$multiple,$array_list,$match)
{
//this select box takes the above 5 arguements to cr
AIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Opinions wanted - Multi select lists , implode
explode
Date: Mon, 4 Oct 2004 10:40:12 -0700 (PDT)
Okay, well a couple of questions. If you don't mind.
Right below is the code I have , and
if you echo $Sent, what do you get?
bastien
From: "Valerie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] Mail & Header Redirect
Date: Tue, 5 Oct 2004 08:24:26 -0400
I have an email that is sent upon submission of a form. I need to redirect
to a confirmation page if email is sent
so try
if ($sent==true) {
mailsent();
}
bastien
From: "Valerie" <[EMAIL PROTECTED]>
To: "Bastien Koert" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] Mail & Header Redirect
Date: Tue, 5 Oct 2004 12:34:27 -0400
When I echo $sent, it
If its an autoincrement, the next highest number will be assigned by the db.
There is no need to query the db to find it. Simply insert the record and
leave the id field out of the insert statement.
bastien
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-
include a link(s) at the top of the column(asc/desc) and pass that value
back to the server. then use that value to sort the column
link = ?col=colname&sort=asc'>Asc
then on the server
$col = $_REQUEST['col'];
$sort= $_REQUEST['sort'];
sql= "select * from tableName [where] order by $col $sort";
b
can you put some output in the function itself to see if its the function
that blowing up and or if its the mail call...
bastien
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Bastien Koert <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mail & Header Redirect
Whats the point? Security thru obfuscation is not security at all. If you
deem your site/data that sensitive, upgrade to ssl , lock the db down tight
and pray that the sys admins at your host are on top of exploits and hacks
to keep the server safe.
Bastien
From: Stuart Felenstein <[EMAIL PROTE
yes, serialize the array. then unserialize it on the other side. look it up
in the manual
bastien
From: Gary Hotko <[EMAIL PROTECTED]>
Reply-To: Gary Hotko <[EMAIL PROTECTED]>
To: Amit Arora <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Passing url parameters
Date: Fri, 8 O
Hi Stu
1. why not check it on every page, then if it fails the user won't need to
make it to the end and then have to go back to the beginning to fix
something minor.
2. You could use hidden fields to pass the data back and for or just use a
session, otherwise the variables expire on that page
see interspered again ;)
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Help: First Time Form with Sessions
Date: Fri, 8 Oct 2004 08:56:48 -0700 (PDT)
See interspersed:
--- Bastien Koert <[EMAIL PROTECTE
hard to say without the code for the function...what is returned by the
fuction determines if the code runs, right? Are you sure the code is
returning "YES"? Maybe post the code for the function
bastien
From: Karen Resplendo <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Why does t
You could make life really simple and write csv document (excel loves those
as long as you handle the data right)force the file to download with the
additional add-type header set to vnd/ms-excel and excel opens it up
automagically...much simpler, no?
we do this for (gasp) asp data to excel
So you have local code executing against a remote server? And you have the
proper accounts and authentication, and direct acccess to the machine?
Could this be an issue where users/aapilcations are still locking the old
table before the drop command is issued? What is the current load on the
ma
here is some code i wrote for a guy.
// redefine the user error constants - PHP 4 only
define("FATAL", E_USER_ERROR);
define("ERROR", E_USER_WARNING);
define("WARNING", E_USER_NOTICE);
// set the error reporting level for this script
error_reporting(FATAL);
//Declarations
$myfile = "
Write a script that exports to text and then zips the file. You can then
download the file or have it emailed.
Its a good idea, you should take control of your data.
Bastien
From: Matthew Perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] backing up off of web host
Date: Sun, 17 O
check out
www.phpforflash.com
or
www.flashkit.com
bastien
From: Juan Stiller <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Showing all mysql query results!
Date: Mon, 18 Oct 2004 15:24:53 -0300 (ART)
Ok, i just followed your advice for make the code
easier to read, it looks good,
try
set password for 'root'@'localhost' = PASSWORD('somepassword');
bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Date: Tue, 19 Oct 2004 08:36:37 -0500
Matt,
Is there a space between PASSWORD and the opening parenthesis? There
shouldn't be, if th
when you log on, there is no default database set to use
type: use mysql
bastien
From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password
Date: Tue, 19 Oct 2004 11:09:56 -0500
I entered select user();
It outputs:
Th cols are likely defined as CHAR not as VARCHAR. CHAR cols will pad out
the length of the value to the full width of the column...change the type to
varchar...
bastien
From: "Dale Hersowitz" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php & mssql
Date: Tue, 19 Oct 2004 09:36:25
http://flashkit.com/board/showthread.php?s=95608f8e3b6478833f8e42171424bf7f&threadid=505071&highlight=pass+php+array
is a discussion about php and flashthe poster 'argonauta' recommend the
use of xml, otherwise the solution is to use individual elements for key
value pair
bastien
From: Juan
Another option might be to place all the elements of each value (ie all
first names) into a csv or other characters separated string and then use
the split command to separate out the elements into an actionscript array
hth
bastien
From: "Norland, Martin" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL P
check both single and double quotes replace them with ('') and ("")
respectively, try mysql_real_escape_string() functions
bastien
From: "Gaby T." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Text corruption when storing to MySql
Date: Wed, 20 Oct 2004 12:49:51 -0700
I am running
Hi Jason,
1. I don't think you need the quotes around the values.
2. is the user cookie set?
bastien
From: "Jason T. Davidson" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Cookies with databases
Date: Wed, 20 Oct 2004 19:54:54 -0500
I am trying to set a c
that I didn't need them)
however this did not help.
"is the user cookie set" This I do not know as I am trying to test this on
that second page. I get nothing, so I am assuming that it isn't set,
however the first one $cid is working just fine, but it's variable do
What about writing a function that will store some of those required
variables into a db. Then on the second site, open a link to the first db
and query for those values that you need?
bastien
From: "Andre Matos" <[EMAIL PROTECTED]>
To: "'Matt M.'" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Su
Have you enabled the gd library? If windows, have you copied the php_gd2.dll
to the c:/windows/ folder?
bastien
From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] imagecreatefromjpeg()
Date: Fri, 22 Oct 2004 13:45:02 -0500
I am using PHP 4.1
Write a function that gets called frequently (or with a cron job) to clean
out session records every half an hour or so...
Each time a page loads with those session vars, update the timestamp in that
record.
bastien
From: "Andre Matos" <[EMAIL PROTECTED]>
To: "&#x
PHP is platform agnostic, so the code you write on windows will work on
*nix, within certain OS dependant limitations. Like COM suuport is windows
only. The question for you is:
Firebird is also platform agnostic (from the docs) but I have not worked
with it and am unsure as to portability of
here is an access one
// Program to test connecting to a Microsoft Access ODBC Data Source
$connection = odbc_connect("postcard", "", "");
print "Connected to datasource";
//$sql="SELECT * FROM postcard";
$sql="insert into postcard (sendername, senderemail, recei
regex replace them all
bastien
From: Robby Russell <[EMAIL PROTECTED]>
To: Vinayakam Murugan <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Implementing search in a database driven website
Date: Tue, 26 Oct 2004 16:57:36 -0700
On Wed, 2004-10-27 at 00:33 +0530, Vinayakam Murugan w
How are you trying to convert the date?
bastien
From: "Bomgardner, Mark A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] Date Question
Date: Wed, 27 Oct 2004 11:17:16 -0500
I am having trouble converting a date from mm/dd/ to -mm-dd on a
user form. I know there was post ab
is it an iteger type datafield?
bastien
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] I can't seem to get Max() to work
Date: Thu, 28 Oct 2004 01:05:46 -0400
Hi there everyone,
I cant seem to get the below to work with PHP and MySQL:
$sql = "SELECT MAX(FoodIt
For bulk loads, its proably best to query the db for the max id number
before the load starts and then do the same after...
last_insert_id only returns the last inserted id
Bastien
From: blackwater dev <[EMAIL PROTECTED]>
Reply-To: blackwater dev <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sub
Best to use int field type and store the difference between the unix
timestamp start time and the unix timestamp end time (both seconds since the
epoch) which would be the number of seconds it took to complete the task.
This number can then be manipulated with math to provide elapsed times in
h
post code, what are we, mindreaders?
bastien
From: "Andre Matos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] PHP does not show errors
Date: Thu, 28 Oct 2004 17:48:56 -0400
Hi List,
I have developed some classes to access MySQL. When I was testing the
classes, I always got a blank
Very simply, either your connection is messed up, you are not getting a
result set back or there is an error in your sql
try this:
$result = mysql_query($query, $link) or die ("failed because
".mysql_error());
then start debugging
bastien
From: "Arne Essa Madsen" <[EMAIL PROTECTED]>
Reply-To:
remove the @ symbol from in front of the connect functions
@mysql_connect
@mysql_select_db
Its supressing any errors that you may have...when you finish the debugging,
then you can add them back in.
bastien
From: Juan Stiller <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Fixing this
Sure, the easiest way is to get that unique value with PHP and then insert
it, then you can show the form again with that unique value, no need to do
an update or other manipulation, if I understand your requirements
correctly...
Bastien
From: "Bomgardner, Mark A" <[EMAIL PROTECTED]>
To: <[EMA
write a script that will access the information, then use a CRON to schedule
the collection at whatever intervals suite your needs.
Bastien
From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL data harvester
Date: Tue, 2 Nov 2004 10:05:5
from the brief error message your provided, I think its blowing up on the
single quote contained in the word "can't". you need to handle this by
choosing one a few of these methods
replace all single quotes with two single quotes
$text = str_replace("'","''", $text);
addslashes function
$text =
use the offset parameter
$offset = 0; //and is set from the application
SELECT * FROM blah WHERE something<>0 LIMIT $offset , 5;
bastien
From: [EMAIL PROTECTED] (Jovan Ross)
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql Function to display number of records
Date: 2 Nov 2004 20:28:41 -
I have a
select distinct(datefield) from
bastien
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] How to get unique entries?
Date: Tue, 2 Nov 2004 17:24:48 -0500
Hi there everyone,
Im listing entries by date in a dropdown box, but on some days there are
7-8+ dates th
DELETE FROM the_table WHERE `ID` IN(1,2,3,4,5,6) will work just fine. The
trick is to be sure that
those records indeed are to be deleted. I prefer to mark the record as
deleted for a time before permanent deletion. That way its recoverable
should something really bad happen.
bastien
From: -{
The logical way t o approach this is to add the buttons and have some
control code that passes control off to a function based on what button was
pressed.
if ($bntSubmit=="Add"){ add(); } //add / edit (update) are all the same
function
if ($bntSubmit=="Delete"){ delete(); }
if ($bntSubmit=="S
have you created a dsn for this connection?
Bastien
From: Petrus Ali Saputra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help me please
Date: Mon, 08 Nov 2004 10:55:45 +0700
Can anyone here help me how to connect to an ODBC data?
Here is my code: $odbc = odbc_connect("Ta Fara","",""
Check the mysql website. Have you upgraded from 4.0x to 4.1 recently. If so
you need to update the client libraries that come with mysql. There are
significant protocol changes from 4.0x to 4.1.
Bastien
From: ian <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PH
Does that user have permissions to run the mysql dump ?
Bastien
From: "Aaron Todd" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysqldump
Date: Tue, 9 Nov 2004 12:59:31 -0500
I have created a PHP script that looks like:
$filename');
?>
For some reason this doesnt work and I cant fig
what mysql version are you running? versions under 4.1 DON"T support
subqueries
bastien
From: GH <[EMAIL PROTECTED]>
Reply-To: GH <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with an insert query
Date: Sat, 13 Nov 2004 01:29:58 -0500
In my mySQL database I have the followi
Try the manual
www.php.net/mssql
From: "Noel Simela" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] MSSQL Server Integration
Date: Sat, 13 Nov 2004 19:15:48 +0200
Hie guys,
Does anyone have any idea how I can make my php pages to work with MS SQL
Server..
regards
Noel
--
PHP Databa
either use a join in the sql syntax to access the data or consider an iframe
bastien
From: Alvaro Cobo <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Nested forms in php (subform)
Date: Sun, 14 Nov 2004 01:35:59 + (GMT)
Hi guys:
I am a very newby in this php stuff and I need a huge
save path variable for sessions by default is
/tmp which is a linux default
try changing it to
/temp
bastien
From: John Holmes <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "Adil" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] IIS and php sessions
Date: Mon, 15 Nov 2004 16:01:
can you show some code?
bastien
From: "Adil" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] IIS/PHP question
Date: Tue, 16 Nov 2004 11:16:40 -0500
I'm having a weird issue with sessions on IIS running PHP. I was finally
able to use sessions on IIS by setting the save_path to "/temp" an
small tables are easier to maintain and grow and quicker to search. need
more info about the data to really help. probably 1 main clients table with
basic info and then 1 or more smaller tables that hold certain specifics
bastien
From: "phpnews" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject:
if you have access to phpmyadmin, use that to dump the table and then
re-import the created files in the server
bastien
From: "Nate Nielsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: [PHP-DB] mysql db dump with php
Date: Wed, 17 Nov 2004 10:08:43 -0600
I tried this but to no avail
yes, its possible. use www.fpdf.org to create the pdfs for you (gets around
the word COM interface) and allows for database storage of template letters
as text, simpler to maintain and change.
FPDF will have some examples that will make this easy for you.
Another option is to use straight html a
see htmlentities function in the manual
http://ca3.php.net/manual/en/function.htmlentities.php
bastien
From: "Todd Trent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] validate/sanitize data
Date: Wed, 17 Nov 2004 15:06:55 -0500
I need to add textarea input into a mysql database. Th
this is a common mysql timestamp problem, you can try using
DATE_FORMAT(datefield, FORMAT) sql function to define the date, or store the
timestamp as a unix timestamp (an integer) from the get go
bastien
From: "Doug Parker" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] timestamp pr
this is how I did it for a client's site
// update the number of times the vehicle has been viewed
mysql_db_query($dbname, "UPDATE vehicle_inventory SET viewed=viewed+1 WHERE
ccode='$ccode'", $link);
bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Updat
ta[comments] = nl2br($data[comments]);
// update the number of times the vehicle has been viewed
mysql_db_query($dbname, "UPDATE vehicle_inventory SET viewed=viewed+1 WHERE
ccode='$ccode'", $link);
...?>
bastien
From: Stuart Felenstein <[EMAIL PROTECTED]>
To: Bastien Koe
number_format() is what you need
look it up
bastien
From: Mark Benson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Currency and number types...
Date: Fri, 19 Nov 2004 17:35:53 +
I'm trying to display data calculated by my script as a currency. The
problem I have is that PHP is t
Better to save the file locally, the pass the name in a session variable.
otherwise the overhead of holding a multi Kb or Mb file will be killer on
the system.
What are you trying to do with the file?
Bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Question on Files&Sess
You need to understand how the htaccess file and its passwords are created.
using mcrypt will likely lead to problems. htaccess passwords are encrypted
with DES algorithm
[quote http://www.edevcafe.com/viewdoc.php?eid=97]
If you wanted to write a CGI script to help you add/delete users from the
1 - 100 of 772 matches
Mail list logo
