[PHP-DB] auto_increment

2006-05-01 Thread Ron Piggott (PHP)


How do I change the auto_increment / auto_index value?  Ron

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] auto_increment

2006-05-01 Thread JupiterHost.Net



Ron Piggott (PHP) wrote:


How do I change the auto_increment / auto_index value?  Ron


Do a query that does what you want.

Without knowing the type of DB you're using (and since this is a PHP 
and Database list not just specific DB list) or any other info, there 
really isn't much you can get from here.


You should likely ask on a list specific to your question.

This will help in your search for info:
 http://www.catb.org/~esr/faqs/smart-questions.html

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] auto_increment

2006-05-01 Thread Ron Piggott (PHP)
I am using mySQL

On Mon, 2006-05-01 at 13:21 +, replies-lists-
[EMAIL PROTECTED] wrote:
 
  Original Message 
  Date: Monday, May 01, 2006 09:14:36 AM -0400
  From: Ron Piggott (PHP) [EMAIL PROTECTED]
  Subject: [PHP-DB] auto_increment
  
  How do I change the auto_increment / auto_index value?  Ron
 
 -- End Original Message --
 
 that depends on the database you're using -- and probably best asked on
 the appropriate db-specific mailing list.
 
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] auto_increment

2006-05-01 Thread chris smith

On 5/1/06, Ron Piggott (PHP) [EMAIL PROTECTED] wrote:

I am using mySQL


.. a google search for mysql reset auto_increment reveals the answer!

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] auto_increment

2006-05-01 Thread JupiterHost.Net



Ron Piggott (PHP) wrote:


I am using mySQL


In that case, mysql.com woudl have MySQL specific resources since it has 
nothgin to do with PHP (aside form that is apparently what you're using 
to interact with MySQL)


Please read http://www.catb.org/~esr/faqs/smart-questions.html#forum

the entire URL is excellent but that specifric section will apply to 
this thread.


Also *please* do not top post :)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] capture a webpage to later process it

2006-05-01 Thread Alejandro Tesone

Maybe you are looking is CURL function.

On 4/29/06, John Hicks [EMAIL PROTECTED] wrote:


John Hicks wrote:
 J. Alejandro Ceballos Z. -JOAL- wrote:

 I want to read the results of an URL address, to later process it and
 insert part of them as internal code.

 If I use include or require, they inserts ALL the resulting code, but
 I want to do something like:


 blah, blah, blah
 ?php
  $result_webpage = somephpfunc('http://other.sit/externalpage.html');
  if

(eregi(result:([:alnum:]+).*([:alnum:]+\.jpg),$result_webpage,$array_match))

{ echo h2External status:.$array_match[1].brimage: img
 src=\..$array_match[2].\/h2;  }
 ?
  blah, blah, blah

 If you have fopen wrappers enabled (see
 http://us2.php.net/manual/en/ref.filesystem.php#ini.allow-url-fopen)
 then you can simply use file_get_contents() to read the web page into a
 string. You can then manipulate it with regexes like so:

 $Url = 'http://www.php.net';
 $ThePageContents = file_get_contents($Url);
 $TheNewPageContents = preg_replace('/PHP/', 'Ruby :)',
$ThePageContents);
 echo $TheNewPageContents;

 --J


Here's a more useful use of the same idea:

?php
if (isset($Url)) {
$ThePageContents = file_get_contents($Url);
$TheNewPageContents =
preg_replace(
'/(head[^]*)/',
\1base href='$Url/' /,
$ThePageContents);
echo $TheNewPageContents;
} else {
echo Enter a URL as a query string in this URL, e.g.:
br /a href=\${_SERVER['PHP_SELF']}?Url=http://www.yahoo.com\;

http://${_SERVER['SERVER_NAME']}${_SERVER['PHP_SELF']}?Url=
http://www.yahoo.com/a;
}
?

This allows you to run your own rather sloppy proxy. Just plug the url
you want into the query string for your page (or, better still, make a
form to post it):


https://mydomain.com/mypage.php?Url=http://DomainIWantToView.com/PageIWantToView.html

The regex adds a base tag to the remote web page to make the images
and links work.

But of course, that means the gets of all the images, css, js, etc. will
all show up with your workstation IP on the remote server's log (and on
your boss's log of your browsing), so you haven't really accomplished
much :(

But it's kind of fun, huh?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php