$val=127.0.0.1;
$query=INSERT INTO node set uri=\$val\, name=\bla\;
Try this one... think is better n less confusing for u...
On Sun, 19 Sep 2004 19:13:48 +0200, Darryl [EMAIL PROTECTED] wrote:
$val = 127.0.0.1;
$query = INSERT INTO node (uri,name) VALUES ('.$val.','bla');
Try that?
Anyone for a list of php abstraction classes?
ADODB, PEAR::DB... any others? or better?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
quotes instead of single ones,
just as M Saleh Eg suggested. So the following statement finally works:
$query = INSERT INTO node (uri,name) VALUES (\$val\,\\);
Just for everybody else:
SQLite does not support the SET statement in INSERTs, so
INSERT INTO table SET attr=val
would
hmm... u better check n hack phpmyadmin... u might get somethin out there...
On Mon, 20 Sep 2004 13:02:55 +0930, David Robley [EMAIL PROTECTED] wrote:
On Sun, 19 Sep 2004 21:19, Ross Honniball wrote:
Hi all,
Anyone know how to access the optional COMMENT you can add to columns
during
Or maybe with Describe Table ?
On Mon, 20 Sep 2004 10:51:30 -0700, Jasper Howard [EMAIL PROTECTED] wrote:
don't you get that with the DEFINE `table` query?
--
--
Jasper Howard :: Database Administration
ApexEleven Web Design
You should always avoid passing Record IDs through URL parameters.
Use form Hidden fields instead!
In your case, when ur selecting the users form data from the record
check if it's the same user if not then if he tries to change the ID
from the URI Parameter just block it. Or u better MD5 every
Is it better if u have ur javascript alone (for example a good JS
framework to make anykind of UI elements u need?) or would u preffer
having a good set of PHP classes that generates those UI elements for
u from PHP w/o even touching JS or even knowing it?
to be clear,
Would u write this script
Do u prefer data structures in your scripts? as in Trees, Queues, Stacks
Do u like arrays? or like classes?
Once u get ur data from ur DB would u store it in a Tree for example
or would u just take more trips to the database instead?
Datascructures make DB so it cant be against it right?
... while it's simple, lack of these plannings
makes ur work harder.
On Tue, 21 Sep 2004 05:29:30 +0400, M Saleh EG [EMAIL PROTECTED] wrote:
You should always avoid passing Record IDs through URL parameters.
Use form Hidden fields instead!
In your case, when ur selecting the users form data from
.
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.
Bastien Koert
From: M Saleh EG [EMAIL PROTECTED]
Reply-To: M Saleh EG [EMAIL
define the connection object as a global var in ur function
function ( params)
{
global $ur_connection_obj;
...
...
}
On Thu, 23 Sep 2004 14:56:10 -0300, Eduardo Sampaio [EMAIL PROTECTED] wrote:
Its because the function cannot access your connection object...
Try passing it to the
I'd do it this way...
I'd add two column in the users table. 1- activated, 2- activation-hash
once the registeration form is ubmited..
a-the username and user info will be saved in the users table.
b-an encrypted hash would be made n saved in activation-hash column
and sent along with the
Stuart... u got the logic now. check ur syntax problems urself...
this is the only way ull learn it!
a hint... if ur database query is giving u errors... try echoing it
before sending it to mysql_query. ull find out the problem yourself
then ;)
another hint... mysql_query always returns
use the cache disable headers in HTML as well as PHP for the server
side headers.
pick any of the two methods.
1-HTML caching control:
meta http-equiv=pragma content=no-cache /
meta http-equiv=cache-control content=no-cache /
meta http-equiv=cache-control content=must-revalidate /
meta
I'd recommand u to use a serialized variable saved in ur database.
As in the an array of keywords saved in an serialized variable once
the form is submited to save the query.
e.g.
$searchQuery = array();
$searchQuery[Keywords]= $_POST[keyword];
$searchQuery[JobCategory]= $_POST[category];
I'd say never be subjective n say i'm not a fan of MS. Choose what
works the best for you.
Check ur budget... ur time ur method of programming and ur DB
knowlede. And ofcorse the size of your project.
For website(not web applications) i'd prefer mySQL
For webapps I'd preffer MSSQL.
For intranet
The whole thing doesnt have to do anything with the DB. Because what
matters is the client or the gateway character-set ( browser in your
case ) so if ur on windows u're probably posting data through
charset=windows-1256 so if ur using HTML then use this encoding or if
ur using XHTML u could put
As I understand, you're trying to check if the passed value is an
integer or not and then check it's value right?
Use the TYPECASTING technique.
example:
$var = (int) $var;
In this case you're converting ur $var to integer before processing it.
Typecasting is a very well known technique in any
I think this should be posted somewhere else. Maybe the php-general list ?!
This is no chemistry nor physics ! it's PHP-DB related issues right?
no arrays or strings probs. Plz keep the consistancy of our good lists
that are valuable for users who are us!
On Mon, 4 Oct 2004 12:51:52 -0700,
I'd always preffer to keep language stuff in files instead of DB.
A question or a problem u might face later is: How are you going to
store the text in the proper Charset in ur tables?
I'd do it this way.
-A field in DB to keep the current default language
-Every module in the app should have
have a flat file with all the translations for the interface and
everything, but the problem is de dynamic content that must be
multilingual...
Regards,
Bruno
On Oct 18, 2004, at 5:29 AM, M Saleh EG wrote:
I'd always preffer to keep language stuff in files instead of DB.
A question
Only? That aint too big, but now i'm confused what's ur hardware and
O.Sspecs? 300 to 500 would be a peice of cake to load. However, it
depends on
ur system.
I would rather use the array than hitting the db for the query. Because the
bottom line is that you will receive your data in an array no
Are you running your sites on the same server?
If yes use only one database for all of them.
23 matches
Mail list logo
