To insert the record I use this code:
$sSql = INSERT INTO myTable (time_in ) VALUES ( getdate() );
try something like
$sSql = INSERT INTO myTable (time_in ) VALUES ( getdate() ); SELECT
@@IDENTITY;
works with the Perl DBI at least.
:-)christian
But if I get the ID in a second
Hi, id'like to know the opinion about to ensure external file integrity.
Scenario: A web application that uses binary files( images, PDF's ).
On the database ( postgresql 7.2.2 ) i store the filename of the files.
The files ( images only ) are taken from an internal machine when needed(
via ftp
this function doesnt work
function query($sql)
{
return mysql_query($sql, $this-mysql_link) or die(query
failed: $sql);
}
but this one does
function query($sql)
{
$mysql_result = mysql_query($sql, $this-mysql_link) or
Can someone point me in the direction of an online tutorial for php
mysql that covers the following:
- Teaches me how to use php to access mysql
- Creating a db that is structured to be efficient
- How to add, modify, and delete records in a database
- How to search for records
- How to filter
Most of this stuff is actually just SQL and has little to do with PHP. So
look for an SQL tutorial. From the PHP side all you need to know is
mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().''
All queries are sent to the database via mysql_query(). It doesn't matter
to
Right well that's what I'm asking I need a tutorial and haven't found a
good one.
-Matt
Rasmus Lerdorf wrote:
Most of this stuff is actually just SQL and has little to do with PHP. So
look for an SQL tutorial. From the PHP side all you need to know is
mysql_connect(), mysql_select_db(),
On Tue, 03 Sep 2002 08:56:43 -0400
Matt Zur [EMAIL PROTECTED] wrote:
Can someone point me in the direction of an online tutorial for php
mysql that covers the following:
http://www.phpbuilder.com
http://www.devshed.com
http://www.devarticles.com
Well, if you do not find something here :-)
http://www.mysql.com/doc/en/Tutorial.html is a good place to start with the
mysql functions in the php manual.
http://www.devshed.com/Server_Side/ has a number of on line tutes amongst
others.
phpbuilder also is useful. The normalisation article is a good first step; it
is at
Just one more to throw on the fire:
Pretty basic tutorial that covers a lot of topics. If you buy the book,
there's a little more depth. On my first day working with PHP/MySQL, I had
basic pages up and running.
http://www.webmasterbase.com/article/228
Incidentally, this same question was asked
Hello all,
I have a MySQL database with some 2 million rows in it. I am counting all
of the different names in one column. How to I get these to come out in
descending order, with the most numbers of one event at the top and going
down from there?
Thanks in advance,
Ron Clark
--
PHP
For a SQL tutorial, I would recommend that you get yourself a copy of Joe
Celko's SQL for smarties.
Best investment I ever made. Everything you need to know is there.
Bon courage!
- Original Message -
From: Matt Zur [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 03,
Try
SELECT name, COUNT(*) AS nb
FROM mytable
GROUP BY name
ORDER BY nb DESC
Ignatius
RClark [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello all,
I have a MySQL database with some 2 million rows in it. I am counting
all
of the different names in one
I'd endorse SQL for Smarties, plus just about anything else JC has
written on SQL.
Another good book is The Practical SQL Handbook by Bowman, Emerson
Darnovsky, ISBN 0-202-44787-8
For a tutorial have a look at Julie Meloni's at http://www.thickbook.com.
They are single issue tutorial,
We are developing Web applications on Red Hat 7.3, Apache (latest), PHP
(latest), Microsoft sql (latest) to display customer, inventory, and order
pages. Looking for very strong PHP consultant experienced with MS sql to
help with knotty problems. Near Los Angeles or Pacific Time Zone is a plus.
Hi I made this.
?
//config.php
$sqlhost = localhost;
$sqluser = root;
$sqlpasswd = password;
$sqldatabase = project;
?
?
//sqlclass.php
require('config.php');
class Connect {
var $link;
function Connect() {
$this-link = mysql_connect($sqlhost,$sqluser,$sqlpasswd);
$select =
These should be helpful:
http://zc8.net/zc8/shownews.php?articleid=93
http://zc8.net/zc8/shownews.php?articleid=95
http://zc8.net/zc8/shownews.php?articleid=98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I do have the same problem since I did update to the newest version of
phpmyadmin.
This seems to be a bug in the new release since everything was working ok
before the update. guess those guys are gonna release a .1 version pretty
soon.
andy
Kasper [EMAIL PROTECTED] schrieb im Newsbeitrag
I must concur, Chapters 28 29 are worth the price of the book!
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 9:49 AM
To: [EMAIL PROTECTED]; Matt Zur
Subject: Re:
I'm trying to connect using the sample code in the php documentation. IT however dies
every time. If someone could please help me? Thanks.
Bryan
can't you just make the name of the file include a unique identifier of some
sort, or store each user's files in a different directory or something, to
make sure that they can't overwrite each other's (or their own) files?
Or would that not work in your app?
HTH
Beau
// -Original
In article 000c01c253b2$506d7530$0101a8c0@fwcmain, [EMAIL PROTECTED]
says...
I'm trying to connect using the sample code in the php documentation. IT however
dies every time. If someone could please help me? Thanks.
Bryan
Can you show the code you are using, and any error messages you
try this.
?php
$sqlhost = localhost;
$sqluser = root;
$sqlpasswd = password;
$sqldatabase = test;
//using pconnect to stay connect all the time to
//close the connect use mysql_close($link);
$link = mysql_pconnect($sqlhost,$sqluser,$sqlpasswd);
mysql_select_db($sqldatabase);
?
- Original
I got it to work My problem was I didn't put include in function. So the
class file should be like this
?
class Connect {
var $link;
function Connect() {
include('config.php');
$this-link = mysql_pconnect($sqlhost,$sqluser,$sqlpasswd);
if (!$this-link) {
printf(Could not connect to sql
Hello,
Is there a way to upload data in a csv file into a mysql table?
Thanks
Indera
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
try phpMyAdmin - nice and easy, although i'm pretty sure there is a direct
command line.
// -Original Message-
// From: Dr. Indera [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 4 September 2002 12:21 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Upload csv file into mysql
//
//
//
25 matches
Mail list logo
