Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2023-01-24 23:13:39

maruchan
Member
From: Ukiah, California
Registered: 2010-06-12
Posts: 590
Website

Is this accurate advice from ChatGPT?

Hi everyone,

Out of curiosity, I asked ChatGPT some questions about using Textpattern programmatically, and it started to refer to the “Textpattern API.” Is this terminology used by developers?

Here’s the full answer it gave in that case, after I typed the following:

How do I add an article to a Textpattern site using PHP?

(ChatGPT answer starts here:) Textpattern has a built-in API that you can use to create new articles programmatically. Here’s an example of how you can use the Textpattern API to create a new article:

<?php

// Include the Textpattern config file
require_once('path/to/textpattern/config.php');

// Connect to the Textpattern database
$db = mysql_connect(TXP_DB_HOST, TXP_DB_USER, TXP_DB_PASS);
mysql_select_db(TXP_DB_NAME, $db);

// Define the article data
$title = 'My New Article';
$body = 'This is the body of my new article.';
$category = 'news';
$status = '4';
$author = 'admin';
$publish_now = '1';

// Use the Textpattern API to create the article
$result = safe_insert('textpattern',
    "Title='$title',
    Body='$body',
    Category1='$category',
    Status='$status',
    AuthorID='$author',
    posted='now()'
    ");

// Output a message to indicate that the article was created
if ($result) {
    echo 'Article created successfully!';
} else {
    echo 'Error creating article';
}

This script uses the safe_insert() function to insert the article data into the textpattern table. The safe_insert() function is a Textpattern utility function that automatically escapes the data to prevent SQL injection attacks.

You can customize this script to your specific needs, such as adding more fields, setting the timestamps, handling different types of errors, etc.

It’s important to test the script thoroughly before running it on your live site, and also check the logs to ensure that the script is running as expected.

You may also want to consider security measures, such as validating the input data to prevent SQL injection and other types of attacks, and limiting the script’s access to the database.

Keep in mind that mysql_* functions have been deprecated as of PHP 7.0 and removed in PHP 7.4, you should consider using the mysqli_* or PDO functions instead, for better security and performance.

(End ChatGPT answer)

I thought that was interesting, and it was certainly convenient, but I’m not sure if it’s reliable. Here’s another answer that made me even more doubtful but I still wasn’t sure if it was accurate.

Any feedback would be appreciated—if I try any of this stuff I kind of want to know if it’s generally being done in the correct way, as opposed to the magical (?) way. :-)

Last edited by maruchan (2023-01-24 23:14:08)

Offline

#2 2023-01-25 11:12:40

etc
Developer
Registered: 2010-11-11
Posts: 5,028
Website GitHub

Re: Is this accurate advice from ChatGPT?

No, we can not yet leave patching our bugs with this marvel.

Offline

#3 2023-02-02 13:54:36

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: Is this accurate advice from ChatGPT?

maruchan wrote #334570:

Out of curiosity, I asked ChatGPT some questions about using Textpattern programmatically […].

Ask it who Donald Swain is…

Offline

#4 2023-02-02 14:17:42

Dragondz
Moderator
From: Algérie
Registered: 2005-06-12
Posts: 1,529
Website GitHub Twitter

Re: Is this accurate advice from ChatGPT?

gaekwad wrote #334616:

Ask it who Donald Swain is…

I asked and here is the response :

I’m sorry, but I don’t have any information on a specific person named “Donald Swain.” Could you please provide more context or specify if you are referring to someone in a particular field or with a specific background?

Offline

#5 2023-02-02 14:40:31

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: Is this accurate advice from ChatGPT?

In reply to Dragondz #334618:

I’m sorry, but I don’t have any information on a specific person named “Donald Swain.”

To be pedantic…does anyone know who Donald Swain is/was?

Offline

#6 2023-02-02 17:15:32

swain
New Member
From: Cardigan
Registered: 2015-07-21
Posts: 8
Website

Re: Is this accurate advice from ChatGPT?

gaekwad wrote #334619:

To be pedantic…does anyone know who Donald Swain is/was?

This Grachtengordel stuff is fantastic.

Well done you Netherlands!

Offline

Board footer

Powered by FluxBB