php-general Digest 2 Aug 2004 14:26:42 -0000 Issue 2913

Topics (messages 192452 through 192469):

Re: Upgrade PHP?
        192452 by: bruce
        192453 by: Curt Zirzow
        192455 by: Support

Re: php4.3.7 + phpBB 2.0.10 + Apache - zero sized replies with
        192454 by: Jason Wong

Re: regex help needed
        192456 by: Wudi

[Newbie Guide] For the benefit of new members
        192457 by: Ma Siva Kumar

Re: Still need help with regex function
        192458 by: Jason Wong

Re: Variables not passed to next page
        192459 by: Jason Wong

Re: regex help needed -- Solved!  Thanks!
        192460 by: Fabrice Lezoray

Re: xored TruStudio PHP Editor
        192461 by: Andrei Verovski (aka MacGuru)

Re: Should I wait for PHP 5.1?
        192462 by: Aidan Lister

script error
        192463 by: me2resh
        192464 by: John Holmes
        192466 by: me2resh
        192468 by: Andre Dubuc

Re: Graphing Webstats using MRTG/PHP/MYSQL?
        192465 by: Fernando Gutierrez

langauage error
        192467 by: me2resh

php coding software
        192469 by: Brad Ciszewski

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------
--- Begin Message ---
i've successfully built php5 on rh8 with no issues...

if you search through the achives of this mailing list you'll see what i
did. look for mysqli/php.

what issues are you haveing when you build from source...???

let us know, and i'm sure someone can help....



-----Original Message-----
From: Will Collins [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 01, 2004 6:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Upgrade PHP?


I'm having problems upgrading PHP from 4.2.2 to 4.3.8 on RedHat 9.  I've
tried simply making the 4.3.8 from source, but RedHat didn't use the default
PHP folder structure is seems, since there has been no change in my PHP
version.  I also tried the "./configure" string returned by 'phpinfo()'
(assuming that the correct path info was included) with no luck.  Does
anyone have any tips on an easier way to upgrade?



Thanks,

Will

--- End Message ---
--- Begin Message ---
* Thus wrote Will Collins:
> I'm having problems upgrading PHP from 4.2.2 to 4.3.8 on RedHat 9.  I've
> tried simply making the 4.3.8 from source, but RedHat didn't use the default
> PHP folder structure is seems, since there has been no change in my PHP
> version.  I also tried the "./configure" string returned by 'phpinfo()'
> (assuming that the correct path info was included) with no luck.  Does
> anyone have any tips on an easier way to upgrade?

I'm assuming that the 4.2.2 was installed from an rpm.

If you notice, the 4.2.2 configure string probably has like 3000
different options set. The problem is that when the rpm was built
and bundled, it was on a system that had all the 'devel' rpm's
installed.  The 'devel' rpm's usually contain's all the files
needed to detect and compile with php.

One option is to install all the devel rpms that are dependent on
php to be configured with all those options. 

The other option would involve bringing your system out of the
dependency of RPM's, I wouldn't suggest that unless your very
comfortable with RH's system.

The last one, and perhaps the best solution, is to scratch that
system and build a new one with a more current OS.


Curt
-- 
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about.  No, sir.  Our model is the trapezoid!

--- End Message ---
--- Begin Message ---
I've dealt with a similar problem with Mandrake. Some distros have their own
idea of where things should go. I prefer to install major applications like
apache, perl, mysql, php myself and never install from rpm or accept default
distro packages when installing an os from scratch.

IMHO: Although handy for some things, I still can't figure out why people
put up with rpms. :-)

What I finally did is use rpm to uninstall php, apache, and mysql. I also
followed dependencies and deleted them as well.

This approach is not really a great idea if you're not used to building from
source, but I have my own idea of where I like things to go so this works
for me. Usually /usr/local is a good choice for installing.

Since mysql and apache both come with their own start up scripts using
chckconfig to add them to the system is about as easy as it gets.

Jim Grill
Web-1 Hosting
http://www.web-1hosting.net

----- Original Message ----- 
From: "Will Collins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 01, 2004 8:03 PM
Subject: [PHP] Upgrade PHP?


> I'm having problems upgrading PHP from 4.2.2 to 4.3.8 on RedHat 9.  I've
> tried simply making the 4.3.8 from source, but RedHat didn't use the
default
> PHP folder structure is seems, since there has been no change in my PHP
> version.  I also tried the "./configure" string returned by 'phpinfo()'
> (assuming that the correct path info was included) with no luck.  Does
> anyone have any tips on an easier way to upgrade?
>
>
>
> Thanks,
>
> Will
>
>

--- End Message ---
--- Begin Message ---
On Sunday 01 August 2004 23:38, ADFH wrote:

> Even if it isn't, how could this stop Apache from logging even an error?

If you're positive that none of the Apache logs shows anything (but that seems 
*very* unlikely) then I suggest you taking this up with phpBB support. 
Another thing you could do is check the MySQL logs.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
Beware of self-styled experts: an ex is a has-been, and a spurt is a
drip under pressure.
*/

--- End Message ---
--- Begin Message ---
On Sun, 1 Aug 2004 10:38:06 -0700 (PDT)
Kathleen Ballard <[EMAIL PROTECTED]> wrote:

> Sorry,
> Here is the code I am using to match the <h*> tags:
> 
> <h([1-9]){1}>.*</h([1-9]){1}>
> 
> I have removed all the NL and CR chars from the string
> I am matching to make things easier.  Also, I have run
> tidy on the code so the tags are all uniform.
> 
> The above string seems to match the tag well now, but
> I still need to remove the br tags from the tag
> contents (.*).
> 
> The strings I will be matching are html formatted
> text.  Sample <h*> tags with content are below:
> 
> <h4>Ex-Secretary Mickey Mouse <br />Loses Mass.
> Primary</h4>
> 
> <h4>Ex-Secretary Mickey Mouse <br />Loses Mass.
> Primary <br /> Wins New Jersey</h4>
> 
> <h4>Ex-Secretary Reich Loses Mass. Primary</h4>
> 
> Again, any help is appreciated.
> Kathleen

Simple:

while (preg_match("/(<h\d>)(.*)(<br \/>)(.*)(<\/h\d>)/is", $str)) {
    $str = preg_replace("/(<h\d>)(.*)(<br \/>)(.*)(<\/h\d>)/is",
"$1$2$4$5", $str);
}
$str = preg_replace("/(<h\d>)(.*)(<\/h\d>)/is", "$2", $str);


Recommended:

$str = preg_replace("/(<h\d)([^>]*)(>)(.*)(<\/h\d>)/eis", "remove_br('$4')", $str);
function remove_br($str){
    return preg_replace("/(<br)([^>]*)(>)/i", "", $str);
}

--- End Message ---
--- Begin Message ---
=======================================
Please feel free to add more points and send 
to the list.
=======================================

1. If you have any queries/problems about PHP 
try http://www.php.net/manual/en first. You 
can download a copy and use it offline also. 

Please also try 
http://www.php.net/manual/faq.php 
for answers to frequently answered questions 
about PHP (added by Christophe Chisogne).

2. Try http://www.google.com next. Searching 
for "php YOUR QUERY" may fetch you relevant 
information within the first 10 results.

3. There is a searchable archive of the 
mailing list discussion at 
http://phparch.com/mailinglists. Many of the 
common topics are discussed repeatedly, and 
you may get answer to your query from the 
earlier discussions. 

For example: One of the repeatedly discussed 
question in the list is "Best PHP editor". 
Everyone has his/her favourite editor. 
You can get all the opinions by going through 
the list archives. If you want a chosen list 
try this link : 
http://www.thelinuxconsultancy.co.uk/phpeditors/
(contributed by Christophe Chisogne).

4. Not sure if PHP is working or you want 
find out what extensions are available to 
you?

Just put the following code into a file with 
a .php extension and access it through your 
webserver:

<?php
phpinfo();
?> 

If PHP is installed you will see a page with 
a lot of information on it. If PHP is not 
installed (or not working correctly) your 
browser will try to download the file.

(contributed by Teren and reworded by Chris W 
Parker)

5. If you are stuck with a script and do not 
understand what is wrong, instead of posting 
the whole script, try doing some research 
yourself. One useful trick is to print 
the variable/sql query using print or echo 
command and check whether you get what you 
expected. 

After diagnosing the problem, send the 
details of your efforts (following steps 1, 
2 & 3) and ask for help.

6. PHP is a server side scripting language. 
Whatever processing PHP does takes place 
BEFORE the output reaches the client. 
Therefore, it is not possible to access 
users' computer related information (OS, 
screen size etc) using PHP. Nor can you 
modify any the user side settings. You need 
to go for JavaScript and ask the question in 
a JavaScript list.

On the other hand, you can access the 
information that is SENT by the user's 
browser when a client requests a page from 
your server. You can find details about 
browser, OS etc as reported by 
this request. - contributed by Wouter van 
Vliet and reworded by Chris W Parker.

7. Provide a clear descriptive subject line. 
Avoid general subjects like "Help!!", "A 
Question" etc. Especially avoid blank 
subjects. 

8. When you want to start a new topic, open a 
new mail composer and enter the mailing list 
address [EMAIL PROTECTED] instead of 
replying to an existing thread and replacing 
the subject and body with your message.

9. It's always a good idea to post back to 
the list once you've solved your problem. 
People usually add [SOLVED] to the subject 
line of their email when posting solutions. 
By posting your solution you're helping the 
next person with the same question. 
[contribued by Chris W Parker]

10. Ask smart questions 
http://catb.org/~esr/faqs/smart-questions.html
[contributed by Jay Blanchard)

11. Do not send your email to the list with 
attachments. If you don't have a place to 
upload your code, try the many pastebin 
websites (such as www.pastebin.com).
[contributed by Burhan Khalid]

Hope you have a good time programming with 
PHP.


-- 
Integrated Management Tools for leather 
industry
----------------------------------
http://www.leatherlink.net

Ma Siva Kumar,
BSG LeatherLink (P) Ltd,
Chennai - 600106

--- End Message ---
--- Begin Message ---
On Sunday 01 August 2004 08:07, C.F. Scheidecker Antunes wrote:

> In order to get the filenames from the output below I have tried the
> following:
>
> preg_match_all('/inflating:"(.*?)"/', $stdout, $matches);
> print_r($matches);
> return $matches[1];
>
> But I only get empty arrays with it.

Try:

  preg_match_all('|^\sinflating: (.*)$|m', $stdout, $matches);

[snip]

> Also, I need to be able to indentify errors with the unzip utility that
> does not support some types of zip file, the output is like this:
>
> unzip test1.zip
> Archive:  test1.zip
>   skipping: test1.txt              `shrink' method not supported
>
> There's a skipping instead of a inflating or Inflating in pkware.

You can modify the above regex to do this.

> The third situation is an error on the zip file itself :

If you simply want to detect whether an error has occurred then using exec() 
you can get the exit code of the program being executed and usually would 
indicate any errors. Otherwise you can use the string search functions to 
look for common/expected error messages in $stdout.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
There comes a time to stop being angry.
                -- A Small Circle of Friends
*/

--- End Message ---
--- Begin Message ---
On Sunday 01 August 2004 02:28, Andre Dubuc wrote:

> Yes the first page has the appropriate <form> tags:
>
> {edit-news.php]
> <form action="edit-news-x.php" method="post"> . . . </form>

Good.

> The second and third pages [edit-news-x.php/ edit-submit.php] are pure php
> (a pass-through page) -- I wasn't aware they needed these tags as well. Hmm
> . . . that might explain why they weren't passed -- I must be getting old
> :> . . .

I'm not sure what you mean by pass-through page. But whenever you're using any 
form elements then they should always be wrapped with properly constructed 
<form> tags. Some browsers are more lax than others but you should always try 
to make your pages browser independent particularly when it comes to 
something as basic and mundane as forms.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
Do not clog intellect's sluices with bits of knowledge of questionable uses.
*/

--- End Message ---
--- Begin Message --- Kathleen Ballard a écrit :
Thanks!  Works like a charm!

I am the very lowest of newbies when it comes to regex
and working through your solutions has been very
educational. I have one question about something I
couldn't figure out:


#<h[1-9]>(.*)</h[1-9]>#Uie
`<h([1-6])>.*?</h\1)>`sie
What is the purpose of the back-ticks and the '#'?

PCRE patterns has to be enclosed, you can use all the non alpha numerics characters to do that. Personnaly, I prefer back ticks because I don't have to escape it often inside my patterns.
For my example, you can also remove the ``s pattern modifier, It makes the dot ( . ) accept any New line characters, and I had not see that you removed them before.


What are 'Uie' and 'sie'?

there are patterns modifiers, you can find a complete list and descriptions here :
http://www.php.net/manual/en/pcre.pattern.modifiers.php


Thanks again!
Kathleen

-----Original Message-----
From: Fabrice Lezoray [mailto:[EMAIL PROTECTED] Sent: Sunday, August 01, 2004 2:52 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: regex help needed


hi

M. Sokolewicz a écrit :

You could try something like:
$return = preg_replace('#<h[1-9]>(.*)</h[1-9]>#Uie',

'str_replace("<br


/>", "", "$1")');


- Tul

Kathleen Ballard wrote:


Sorry,
Here is the code I am using to match the <h*> tags:

<h([1-9]){1}>.*</h([1-9]){1}>

I think this mask is better : `<h([1-6])>.*?</h\1)>`sie



I have removed all the NL and CR chars from the

string

I am matching to make things easier. Also, I have

run

tidy on the code so the tags are all uniform.

The above string seems to match the tag well now,

but

I still need to remove the br tags from the tag
contents (.*).

To remove the <br /> tags, you need to call preg_replace_callback() :

<?php
$str = '<h1>hi <br /> ..</h1> bla bla <h5> .... <br />
..</h5> ...<br />';
function cbk_br($match) {
return '<h' . $match[1] . '>' . str_replace('<br />',
'', $match[2]) . '</h' . $match[1] . '>';
}
$return =
preg_replace_callback('`<h([1-6])>(.*?)</h\1>`si',
'cbk_br', $str);
echo $return;
?>


The strings I will be matching are html formatted
text.  Sample <h*> tags with content are below:

<h4>Ex-Secretary Mickey Mouse <br />Loses Mass.
Primary</h4>

<h4>Ex-Secretary Mickey Mouse <br />Loses Mass.
Primary <br /> Wins New Jersey</h4>

<h4>Ex-Secretary Reich Loses Mass. Primary</h4>

Again, any help is appreciated.
Kathleen




Sorry for my bad english ..

--
Fabrice Lezoray
http://classes.scriptsphp.fr
-----------------------------

--- End Message ---
--- Begin Message ---
Hi,

Quite surprised to see any news about xored trustudio. I used it some time ago, but switched to phpeclipse. xored was developed by a Russian company located in Siberia, city of Novosibirsk. Are they still alive? I have tried their latest M1, it did not work for me.

Does anyone know how to get the "hover" functionality working in xored's
webstudio/trustudio for PHP.


TIA,

Daryl


********************************************* * Best Regards --- Andrei Verovski * * Personal Home Page * http://snow.prohosting.com/guru4mac/ * Mac, Linux, DTP, Development, IT WEB Site *********************************************

--- End Message ---
--- Begin Message ---
http://php.net/migration5

5.0.1 is coming out shortly, wait for that.


"Gerard Samuel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Sunday 01 August 2004 12:19 pm, Randall Perry wrote:
> > Any major gotchas going from 4 to 5? Any problems with PostgreSQL
> > connectivity? Will I have to scour and rewrite current scripts?
> >
>
> My opininon would be to wait on maybe 5.0.1, especially if its on a
production
> box.  Im not having an absolute blast with it on my dev boxes...

--- End Message ---
--- Begin Message ---
i am using this script as a form to enter articles into databas,
the variable post_content comes from wysiwyg script
but when i execute the script everything goes fine except it doesn't insert any rown in the databse
can anyone tell me what is wrong with my code ?
 
 
 
 
 
 
<?php ob_start();
 
$post_title = addslashes($post_title);
 
$post_author = addslashes($post_author);
 
$post_content = addslashes($post_content);
 
$post_date = addslashes($post_date);
 
$db = mysql_connect("localhost", "root");
mysql_select_db("balady", $db);
$query = "insert into 'posts' ( `post_id` , `post_title` , `post_date` , `post_author` , `post_content` , `m_cat_id` , `s_cat_id` , `post_pic`) values (\'\', \'$post_title, \'$post_title, \'$post_author, \'$post_content, \'\', \'\', \'subject.gif\' )";
mysql_query($query);
 

?>
 
<html>
<head>
<title>Add Article</title>
</head>
<body>

 
 
 
 
<form name="post_article" method="post" action="" >
 <table border="0" width="56%" id="table1">
  <tr>
   <td width="193"><b><span lang="ar-eg">
   <font size="3" face="Simplified Arabic">&#1593;&#1606;&#1608;&#1575;&#1606; &#1575;&#1604;&#1605;&#1608;&#1590;&#1608;&#1593;</font></span></b></td>
   <td width="341"><input type="text" name="post_title" size="40" dir="rtl"></td>
   <td>&nbsp;</td>
  </tr>
  <tr>
   <td width="193"><b><span lang="ar-eg">
   <font size="3" face="Simplified Arabic">&#1575;&#1587;&#1605; &#1575;&#1604;&#1603;&#1575;&#1578;&#1576;</font></span></b></td>
   <td width="341"><input type="text" name="post_author" size="40" dir="rtl"></td>
   <td>&nbsp;</td>
  </tr>
  <tr>
   <td width="193"><b><font size="3" face="Simplified Arabic">
   <span lang="ar-eg">&#1578;&#1575;&#1585;&#1610;&#1582; &#1575;&#1604;&#1605;&#1608;&#1590;&#1608;&#1593;</span></font></b></td>
   <td width="341"><input type="text" name="post_date" size="40" dir="rtl"></td>
   <td>&nbsp;</td>
  </tr>
<tr>
<td>
</td>
<td>
<?php
 
// include the config file and editor class:
 
include_once ('editor_files/config.php');
include_once ('editor_files/editor_class.php');
 
// create a new instance of the wysiwygPro class:
 
$editor = new wysiwygPro();
$editor->set_name('post_content');
 
// print the editor to the browser:
 
$editor->print_editor(700, 400);
 
?>
</td>
</tr>
  <tr>
   <td width="193">&nbsp;</td>
   <td width="341"><input type="submit" value="Submit" name="submit"><input type="reset" value="Reset" name="reset"></td>
   <td>&nbsp;</td>
  </tr>
 
</TABLE>
</form>
</body>
</html>
 
<?php ob_end_flush(); ?>
____________________________________________________
  IncrediMail - Email has finally evolved - Click Here

--- End Message ---
--- Begin Message ---
$query = "insert into 'posts' ( `post_id` , `post_title` , `post_date` , `post_author` , `post_content` , `m_cat_id` , `s_cat_id` , `post_pic`) values (\'\', \'$post_title, \'$post_title, \'$post_author, \'$post_content, \'\', \'\', \'subject.gif\' )";
mysql_query($query);

Change that last line to

mysql_query($query) or die(mysql_error());

and run the script again. If you can't figure it out, post back with the error message and what troubleshooting you've done.
--


John Holmes

php|architect - The magazine for PHP professionals - http://www.phparch.com
--- End Message ---
--- Begin Message ---
thanks for your help
 
i did that
and here is the error message returned
 
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''posts' ( `post_id` , `post_title` , `post_date` , `post_author 
 
how can i fix it ?
 
-------Original Message-------
 
Date: 08/02/04 13:45:22
Subject: Re: [PHP] script error
 
> $query = "insert into 'posts' ( `post_id` , `post_title` , `post_date` ,
> `post_author` , `post_content` , `m_cat_id` , `s_cat_id` , `post_pic`)
> values (\'\', \'$post_title, \'$post_title, \'$post_author,
> \'$post_content, \'\', \'\', \'subject.gif\' )";
> mysql_query($query);
 
Change that last line to
 
mysql_query($query) or die(mysql_error());
 
and run the script again. If you can't figure it out, post back with the
error message and what troubleshooting you've done.
--
 
John Holmes
 
php|architect - The magazine for PHP professionals - http://www.phparch.com
 
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
 
____________________________________________________
  IncrediMail - Email has finally evolved - Click Here

--- End Message ---
--- Begin Message ---
Maybe unquote 'posts' -- I would write:

 $query = "INSERT INTO posts ( `post_id` , `post_title` , `post_date` , ......



On Monday 02 August 2004 06:49 am, me2resh wrote:
> thanks for your help
>
> i did that
> and here is the error message returned
>
> You have an error in your SQL syntax. Check the manual that corresponds to
> your MySQL server version for the right syntax to use near ''posts' (
> `post_id` , `post_title` , `post_date` , `post_author
>
> how can i fix it ?
>
>
> -------Original Message-------
>
> From: John Holmes
> Date: 08/02/04 13:45:22
> To: me2resh
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] script error
>
> > $query = "insert into 'posts' ( `post_id` , `post_title` , `post_date` ,
> > `post_author` , `post_content` , `m_cat_id` , `s_cat_id` , `post_pic`)
> > values (\'\', \'$post_title, \'$post_title, \'$post_author,
> > \'$post_content, \'\', \'\', \'subject.gif\' )";
> > mysql_query($query);
>
> Change that last line to
>
> mysql_query($query) or die(mysql_error());
>
> and run the script again. If you can't figure it out, post back with the
> error message and what troubleshooting you've done.
> --
>
> John Holmes
>
> php|architect - The magazine for PHP professionals - http://www.phparch.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message ---
see cacti:

http://www.raxnet.net/products/cacti/

On Thu, 29 Jul 2004 14:03:08 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote:
> has anyone know any tools related to this?
> 
> Graphing Webstats using MRTG/PHP/MYSQL?
> 
> --
> Louie Miranda
> http://www.axishift.com
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 


-- 
-- Fernando Gutierrez Perez --
gmeileando un poco :)

--- End Message ---
--- Begin Message ---
i am using a form to enter articles into mysql databse  in Arabic language
when i enter the data from Phpmyadmin it converts the letters to the unicode they match
like &#1610;&#1576;&#1604;&#1610;
but when i enter it from my form it returns strange letters which is not usefull
like OE??C?EO??CO?E?
 
how can i make my scripts encode the arabic letters to the unicode of them before it stores it in the database
 
here is my script
 
 
 
 
 
<?php ob_start();
 
$post_title = addslashes($post_title);
 
$post_author = addslashes($post_author);
$post_author = "<span lang=\"ar-eg\">.$post_author.\"</span>";
 
$post_content = addslashes($post_content);
 
$post_date = addslashes($post_date);
 
$db = mysql_connect("localhost", "root");
mysql_select_db("balady", $db);
$query = "insert into posts (post_id ,post_title ,post_date ,post_author ,post_content ,m_cat_id ,s_cat_id ,post_pic) values ('', '$post_title', '$post_title', '$post_author', '$post_content', '', '', 'subject.gif' )";
mysql_query($query) or die(mysql_error());
 

?>
 
<html>
<head>
<title>Add Article</title>
</head>
<body>
 
 
 
<form name="post_article" method="post" action="" >
 <table border="0" width="56%" id="table1">
  <tr>
   <td width="193"><b><span lang="ar-eg">
   <font size="3" face="Simplified Arabic">&#1593;&#1606;&#1608;&#1575;&#1606; &#1575;&#1604;&#1605;&#1608;&#1590;&#1608;&#1593;</font></span></b></td>
   <td width="341"><input type="text" name="post_title" size="40" dir="rtl"></td>
   <td>&nbsp;</td>
  </tr>
  <tr>
   <td width="193"><b><span lang="ar-eg">
   <font size="3" face="Simplified Arabic">&#1575;&#1587;&#1605; &#1575;&#1604;&#1603;&#1575;&#1578;&#1576;</font></span></b></td>
   <td width="341"><input type="text" name="post_author" size="40" dir="rtl"></td>
   <td>&nbsp;</td>
  </tr>
  <tr>
   <td width="193"><b><font size="3" face="Simplified Arabic">
   <span lang="ar-eg">&#1578;&#1575;&#1585;&#1610;&#1582; &#1575;&#1604;&#1605;&#1608;&#1590;&#1608;&#1593;</span></font></b></td>
   <td width="341"><input type="text" name="post_date" size="40" dir="rtl"></td>
   <td>&nbsp;</td>
  </tr>
<tr>
<td>
</td>
<td>
<?php
 
// include the config file and editor class:
 
include_once ('editor_files/config.php');
include_once ('editor_files/editor_class.php');
 
// create a new instance of the wysiwygPro class:
 
$editor = new wysiwygPro();
$editor->set_name('post_content');
 
// print the editor to the browser:
 
$editor->print_editor(700, 400);
 
?>
</td>
</tr>
  <tr>
   <td width="193">&nbsp;</td>
   <td width="341"><input type="submit" value="Submit" name="submit"><input type="reset" value="Reset" name="reset"></td>
   <td>&nbsp;</td>
  </tr>
 
</TABLE>
</form>
</body>
</html>
 
<?php ob_end_flush(); ?>
-------Original Message-------
 
Date: 08/02/04 13:45:22
Subject: Re: [PHP] script error
 
> $query = "insert into 'posts' ( `post_id` , `post_title` , `post_date` ,
> `post_author` , `post_content` , `m_cat_id` , `s_cat_id` , `post_pic`)
> values (\'\', \'$post_title, \'$post_title, \'$post_author,
> \'$post_content, \'\', \'\', \'subject.gif\' )";
> mysql_query($query);
 
Change that last line to
 
mysql_query($query) or die(mysql_error());
 
and run the script again. If you can't figure it out, post back with the
error message and what troubleshooting you've done.
--
 
John Holmes
 
php|architect - The magazine for PHP professionals - http://www.phparch.com
 
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
 
____________________________________________________
  IncrediMail - Email has finally evolved - Click Here

--- End Message ---
--- Begin Message ---
Does anyone know any good software for PHP/mysql coding? I currently use
DreamWeaver MX, however it doesn't have much PHP support, and no MySQL
support. I just want an easy program to script in, and upload on to my
webserver. Please help! :o

--- End Message ---

Reply via email to