I use a cron script that does something like this:
mysqldump -all | zip mysqlbackup.zip ~
You can add a path so that the mysqlbackup.zip file is in your
public_html directory so you can download it, or you can use ftpbackup
to send it to another server if you want to.
-Micah
On Mon, 2003-01-2
No, if you're trying to store an array in the database, use serialize();
http://www.php.net/manual/en/function.serialize.php
Something like this:
$serialized_data = serialize($HTTP_POST_VARS);
$serialized_data = addslashes($serialized_data);
mysql_query("INSERT INTO ads (post_vars, createdate)
> hello,
> will this work?
>
> $sql = "INSERT INTO ads ($HTTP_POST_VARS,createdate)
> VALUES ('$key','$today')";
> mysql_query($sql);
>
> i have this at the top:
>
> foreach ($HTTP_POST_VARS as $key => $value)
No. Not sure how to tell you to do it, though, as I'm not sure wha
hello,
will this work?
$sql = "INSERT INTO ads ($HTTP_POST_VARS,createdate)
VALUES ('$key','$today')";
mysql_query($sql);
i have this at the top:
foreach ($HTTP_POST_VARS as $key => $value)
thanks again, addison ellis
--
Addison Ellis
small independent publishing co.
114 B 29th Ave
> hello and presumably, thank you again...
> i have quite a few fields from different forms that are not
> required and almost as many that are so i have opted to go with
> if ($key != "middle_name") format.
> in using this can i separate the different fields like so if
> ($key != "'mid
hello and presumably, thank you again...
i have quite a few fields from different forms that are not
required and almost as many that are so i have opted to go with
if ($key != "middle_name") format.
in using this can i separate the different fields like so if
($key != "'middle_name','address',
Hello,
I don't understand arrays that well. If someone can help me sort the
contents it would be appreciated.
I have data being retrieved from a text file and the fields as an array
inserted into another array.
orderby is numeric is 1-99 and requires sorting ASC
content is just formatted html
I'm getting this error message when I try the following code:
$link = mysql_connect("localhost")
or die("Could not connect");
print ("Connected successfully");
mysql_close($link);
The scripts outputs:
Warning: Can't create TCP/IP socket (10106) in
C:\Projects\WebServer\admin.php
On Mon, Jan 27, 2003 at 05:05:02PM +0100, Geckodeep wrote:
>Hi,
>
>Can any one guide me through the uploading file procedure please?
>Should I use copy() function to copy the image file to a temp file and
>rename it to the real name and then reference the name in the data base.
>Or is there any ot
Chris --
...and then Chris Payne said...
%
% Hi there everyone,
Hi!
%
% I have way too many databases to backup manually or with PHPMyADMIN, how, using PHP
with MySQL could I backup multiple databases easily?
1) What level of 'manual' is too much?
2) Are all of the databases on the server
On Mon, Jan 27, 2003 at 06:26:06PM -0600, Addison Ellis wrote:
>
> hello and thank you for your time.
> will the below work to check if one field or the other is
> filled in upon submission? either contact_phone or contact_email is
> required but not both. best, addison
I would use someth
You should probably replace $name == "" with strlen($name) < 1.
Also, you should probably used $error .= instead of $error = so that you can list all
the errors instead of just the last one.
<>< Ryan
-Original Message-
From: Addison Ellis [mailto:[EMAIL PROTECTED]]
Sent: Monday, January
hello and thank you for your time.
will the below work to check if one field or the other is
filled in upon submission? either contact_phone or contact_email is
required but not both. best, addison
$error = "";
if ($name == "")
{
$error = "$errorYou must enter a company name.";
}
if ($addres
Hi there everyone,
I have way too many databases to backup manually or with PHPMyADMIN, how, using PHP
with MySQL could I backup multiple databases easily?
Any examples would be really appreciated :-)
Thank you.
Regards
Chris
i searched at mysql.com and it said basically what you are asking. i
contacted the server admin and they are going to re-set the server.
thank you for your time. best regards, addison
Assuming that line 5 is the dbconnect, is there a limit on the number of
connections that your MySQL server all
> any idea what this means? i have not touched or changed my
> config.php file since i put it up the first time... it contains my db
> connect info. also, i just downloaded it from the server to see if it
> had been modified and it had not. thanks again and best, addison
>
> Warning: Too many conne
What database are you using for your server? What OS is it running on? I've
run into this on MSSQL before but never on MySql.
=C=
p.s. Hi from Antioch!
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-Original Message-
From: Addison Ellis [mailto
This would make a whole lot more sense within a context...such as how
busy is your application, what kind of connection you are using
(pconnect vs. connect) and so on.
A quick search on MySQL's web site resulted in:
http://www.mysql.com/doc/en/Too_many_connections.html
Be sure to check out ge
hello and thank you.
any idea what this means? i have not touched or changed my
config.php file since i put it up the first time... it contains my db
connect info. also, i just downloaded it from the server to see if it
had been modified and it had not. thanks again and best, addison
Warning:
function get_domain($domain){
preg_match('/^(www.)?([A-Za-z_-]+).+$/',$domain,$arr);
return $arr[2];
}
Shahar Tal wrote:
Hey
I'm looking and wondering for a function, as i'm trying to do something, and
here it is.
I'm using the SSI call :
.
to get the domain name I am on. this will outpu
No, you didn't get it?
But cornelia es said, just told me that i have mistaken and put an ftp clss,
my mistake.
Cumprimentos
Bruno Pereira
[EMAIL PROTECTED]
-Original Message-
From: Matthew Moldvan [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 27 de Janeiro de 2003 17:21
To: 'Bruno Per
Hi John
I've just got that from browsing through the net.
I am in the middle of figuring it out how to implement it.
If I have any more questions I'll post it on the forum. For time being
thanks for your advice.
GD
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
000201c2c628$a8f0f3b0$7c02
Did you forget to attach the class?
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
Work: (313) 593-7993 x 116
Cell: (734) 658-0997
http://www.trilogyintl.com/ecommerce/
---
-Origina
Hi John,
First of all I don't know how you got into my thread but any way that's not
a problem.
Let me tell you that I am a novice in Php|MySql so I don't know a lot, I'
just started two weeks ago.
During my quest for solutions to my problems, I've come across through
different sites related to
> Can any one guide me through the uploading file procedure please?
> Should I use copy() function to copy the image file to a temp file and
> rename it to the real name and then reference the name in the data
base.
> Or is there any other way.
> Should say though my Service Provider does not suppo
I haven't been following any other threads relating to this, but you
might try the following. It's not a recommended way to do things, as
you can't verify the fields being posted, but it should work.
I am assuming there is no correlation between the various forms being
submitted.
$val) {
$ins_fi
Hi,
I'm looking to config remote Oracle connectivity with php on rehdat.
Can anyone point me in the right direction for how to?
Or perhaps more to the point, looks like I need basic Oracle installed on
the php server as a pre-requisite even for remote Oracle connect
ability... true or false.
Hi,
Can any one guide me through the uploading file procedure please?
Should I use copy() function to copy the image file to a temp file and
rename it to the real name and then reference the name in the data base.
Or is there any other way.
Should say though my Service Provider does not support ex
Hello,
I recently upgraded from PHP 4.2.3 to 4.3 and Apache 1.3 to 2.+. Previously
I wasnt having a problem connecting to Sybase. After the upgrade I cant
connect using the ct_connect library. My php.ini file hasnt changed. Any
ideas?
Here is my error: Warning: sybase_connect() [function.sybase-c
Thxalot!
I didn't thought it would be that easy *g*
- matthias st.
John W. Holmes <[EMAIL PROTECTED]> [EMAIL PROTECTED] 14:12 Uhr:
>> Does anybody know a good reference, where I can lern how to insert
> binary
>> data (e.g. Images) into a BLOB-Field of a MySQL-Database?
>
> Use fopen() to op
> Does anybody know a good reference, where I can lern how to insert
binary
> data (e.g. Images) into a BLOB-Field of a MySQL-Database?
Use fopen() to open the image, fread() it into a variable, and insert
that variable like you would any other one. If the image is coming from
an element, then yo
Hi everybody out there!
Does anybody know a good reference, where I can lern how to insert binary
data (e.g. Images) into a BLOB-Field of a MySQL-Database?
Any help would be warmely appreciated
- Matthias St.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
Hi everybody out there!
Does anybody know a good reference, where I can lern how to insert binary
data (e.g. Images) into a BLOB-Field of a MySQL-Database?
Any help would be warmely appreciated
- Matthias St.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
Try that, is very good, i have the same problem and someone send me that,
try it. I hope is the right one.
Thats just a class, but inside there is the instruction. I put it to work
and is very good.
Cumprimentos
Bruno Pereira
[EMAIL PROTECTED]
-Original Message-
From: cornelia es said [m
hello again and i am sorry i was not more specififc in my last post.
here is where i am confused:
else
{
$today = date("Y-m-d h:m:s");
$sql = "INSERT INTO ads ("")
hello,
can someone help me with this? i have tried all i know and i
am very new at this... my apologies.
i am trying to have multiple forms, all with different
fields/values, point to one .php that will foreach($HTTP_POST_VARS as
$key => $VALUE)
1) check for if ($value == "")
2) ereg function
36 matches
Mail list logo
