OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
php-general Digest 2 Aug 2004 14:26:42 -0000 Issue 2913

php-general-digest-helplists.php.net
Date: Mon Aug 02 2004 - 09:26:42 CDT

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:
        php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
        php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
        php-generallists.php.net

----------------------------------------------------------------------

attached mail follows:

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:willenerum.com]
Sent: Sunday, August 01, 2004 6:03 PM
To: php-generallists.php.net
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

attached mail follows:

* 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!

attached mail follows:

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" <willenerum.com>
To: <php-generallists.php.net>
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
>
>

attached mail follows:

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.
*/

attached mail follows:

On Sun, 1 Aug 2004 10:38:06 -0700 (PDT)
Kathleen Ballard <klb5770yahoo.com> 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);
}

attached mail follows:

=======================================
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 php-generallists.php.net 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

attached mail follows:

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
*/

attached mail follows:

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.
*/

attached mail follows:

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:fabricescriptsphp.org]
> Sent: Sunday, August 01, 2004 2:52 PM
> To: php-generallists.php.net
> 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
-----------------------------

attached mail follows:

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
*********************************************

attached mail follows:

http://php.net/migration5

5.0.1 is coming out shortly, wait for that.

"Gerard Samuel" <php-generaltrini0.org> wrote in message
news:200408011520.32442.php-generaltrini0.org...
> 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...

attached mail follows:

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="<?php print ($PHP_SELF); ?>"
onSubmit="submit_form()">
 <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(); ?>

attached mail follows:

> $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

attached mail follows:

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: php-generallists.php.net
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
 

attached mail follows:

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: php-generallists.php.net
> 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

attached mail follows:

see cacti:

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

On Thu, 29 Jul 2004 14:03:08 +0800, Louie Miranda <lmirandagmail.com> 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 :)

attached mail follows:

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="<?php print ($PHP_SELF); ?>"
onSubmit="submit_form()">
 <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-------
 
From: John Holmes
Date: 08/02/04 13:45:22
To: me2resh
Cc: php-generallists.php.net
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
 

attached mail follows:

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