Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Dec 01 02:46
    mnewnham labeled #909
  • Dec 01 02:46
    mnewnham labeled #909
  • Dec 01 02:46
    mnewnham labeled #909
  • Dec 01 02:46
    mnewnham opened #909
  • Dec 01 02:39
    mnewnham labeled #908
  • Dec 01 02:39
    mnewnham labeled #908
  • Dec 01 02:39
    mnewnham labeled #908
  • Dec 01 02:39
    mnewnham opened #908
  • Dec 01 02:28
    mnewnham edited #907
  • Dec 01 02:28
    mnewnham labeled #907
  • Dec 01 02:28
    mnewnham labeled #907
  • Dec 01 02:28
    mnewnham labeled #907
  • Dec 01 02:28
    mnewnham opened #907
  • Nov 30 03:26
    mnewnham labeled #906
  • Nov 30 03:26
    mnewnham labeled #906
  • Nov 30 03:26
    mnewnham labeled #906
  • Nov 30 03:26
    mnewnham opened #906
  • Nov 30 03:16
    mnewnham edited #905
  • Nov 30 02:51
    mnewnham labeled #905
  • Nov 30 02:51
    mnewnham labeled #905
Damien Regad
@dregad

ADOdb Version 5.21.0 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.21.0/docs/changelog.md
peterdd
@peterdd
How about a video conference next week sometimes? :-) I could host it with jitsi on my mailbox.org account.
MikeW1992
@MikeW1992
Hi, is there anywhere I can direct an email to, to answer some questions and maybe discuss some points about the adodb-mssql/mssqlnative driver?
I'm in the process of writing up my thoughts on my recent experience with looking into the drivers performance, and this doesn't really seem like the correct platform to possibly dump a wall of text.
Mark Newnham
@mnewnham
Message me at mark@newnhams.com
Damien Regad
@dregad

ADOdb Version 5.21.1 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.21.1/docs/changelog.md
Damien Regad
@dregad

ADOdb Version 5.21.2 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.21.2/docs/changelog.md
Damien Regad
@dregad

ADOdb Version 5.21.3 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.21.3/docs/changelog.md
Mark Newnham
@mnewnham
Damien, I'm wondering what release schedule we have now. I noticed that there is no plans for 5.21.4, and that 5.22 is overdue. I've some serious changes that I'd like to talk to you about and that I feel ought to go into an alpha level release as it involves changes in the way that core classes are extended. Let me know what my options could be.
Damien Regad
@dregad
I did not create a 5.21.4 milestone, because I started working on version 5.22.0 which I was planning to release late November, but life got in the way (again). I have a few days off after Xmas, so I should be able to cut 5.22 at that time.
Are you saying I should do 5.22 alpha ? Or release 5.22 and shortly after that a 5.23 alpha ?
Both options are OK with me.
Mark Newnham
@mnewnham
I would say 5.22 then 5.23 alpha. I've got some changes to the way that the classes extend each other, which I think make more sense, but I wanted to explain them in a little more detail to get your opinion. I'll post something a little later, but I don't want to delay anything now
Damien Regad
@dregad
OK
Daniel Ziegenberg
@ziegenberg_gitlab
How far away is release 5.22?
Damien Regad
@dregad
Pretty close actually
Damien Regad
@dregad

ADOdb versions 5.20.21 and 5.21.4 released

This is a Security hotfix release addressing a critical vulnerability in PostgreSQL connections (CVE-2021-3850, advisory GHSA-65mj-7c86-79jf).
See changelog https://github.com/ADOdb/ADOdb/blob/v5.21.4/docs/changelog.md
Damien Regad
@dregad

ADOdb Version 5.22.0 released

Feature and maintenance release.
See changelog https://github.com/ADOdb/ADOdb/blob/v5.22.0/docs/changelog.md
Damien Regad
@dregad

ADOdb Version 5.22.1 released

See changelog https://github.com/ADOdb/ADOdb/blob/v5.22.1/docs/changelog.md
Damien Regad
@dregad
Hi @mnewnham , it took me a bit more time than I expected, but I reviewed (and performed limited testing too) of the PDO driver refactoring, see my comments in PR #826
WebSpectrum
@WebSpectrum
Hi - are the any performance advantages/disadvantages to using prepared statements when they are not strictly required i.e. no variables in query
dory2380
@dory2380:matrix.org
[m]
Hey there~ I'm coming across an issue where the $sql "SHOW VARIABLES LIKE ?" is getting rejected in prepared statements. It's only when using the LIKE keyword and ? together. When I use "show variables where Variable_name=?" it works fine with the given value in the array for the query.
Am on 5.22.1
Damien Regad
@dregad

@dory2380:matrix.org I assume you are getting SQL Statement failed on preparation: SHOW VARIABLES LIKE ? when calling $adodb->execute('SHOW VARIABLES LIKE ?', ['a%']);. The problem is with the underlying PHP mysqli driver, not ADOdb:

$mysqli = new mysqli($host, $user, $password, $database);
$stmt = $mysqli->prepare('SHOW VARIABLES LIKE ?');

throws Fatal error: Uncaught mysqli_sql_exception: 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 '?'
Try it with

$adodb->execute('SHOW VARIABLES where variable_name LIKE ?', ['a%']);
1 reply
Mark Newnham
@mnewnham
This issue was also covered in more detail in #798
Paul Maher
@webspectrum_gitlab

Hi - how does one reuse a query result with PHP ADODB? I am currently doing this but assume its an inefficient approach:

$query = "SELECT colname FROM table";
$result1 = $db->SelectLimit($query,10,-1);
$result2 = $db->SelectLimit($query,10,-1);

// 1ST RUN
while (!$result1->EOF) {
echo $result1->Fields('colname').'<br>';
$result1->MoveNext();
}
// 2ND RUN
while (!$result2->EOF) {
echo $result2->Fields('colname').'<br>';
$result2->MoveNext();
}

Paul Maher
@webspectrum_gitlab

No worries, I see we use $result1->move(0), which does it.

$query = "SELECT colname FROM table";
$result1 = $db->SelectLimit($query,10,-1);

// 1ST RUN
while (!$result1->EOF) {
echo $result1->Fields('colname').'<br>';
$result1->MoveNext();
}
// 2ND RUN
$result1->move(0); // move recordset cursor back to 0
while (!$result1->EOF) {
echo $result1->Fields('colname').'<br>';
$result2->MoveNext();
}

Damien Regad
@dregad

ADOdb Version 5.22.2 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.22.2/docs/changelog.md
giopk
@giopk
Hi, I have reasons to believe that the last main contributor for Firebird driver will not be available for a few years. What's the appropriate way to sponsor someone to work on it?
Sorry, just saw that @mnewnham is working on it. Still would like to sponsor the maintenance of the driver
Mark Newnham
@mnewnham
@dregad , how do you think we should approach this?
Damien Regad
@dregad
@giopk thanks for your sponsorship proposal! This is much appreciated, but kind of new for us. Could you please clarify what you have in mind? Your expectations, etc... If you prefer to discuss this privately feel free to do so here, or take this to email (you'll find our addresse in the git log)
giopk
@giopk
@dregad Sorry I've been travelling and saw this only now, will contact you by e-mail
giopk
@giopk
@dregad @mnewnham Hi, sent you an email a couple of days ago but got no answer, did you receive it?
Paul Maher
@webspectrum_gitlab
is there a more efficient way to do the following without having a query for each catid ? I have a large number of queries to do something simiar with:

$query1 = "SELECT col1, col2, catid FROM table WHERE catid = 1";
$result1 = $db->execute($query1);
$totalRows_result1 = $result1->RecordCount();

$query2 = "SELECT col1, col2, catid FROM table WHERE catid = 2";
$result2 = $db->execute($query2);
$totalRows_result2 = $result2->RecordCount();

if ($totalRows_result1 < 1) { 
    echo 'sorry, category 1 has no items';
}

if ($totalRows_result2 < 1) { 
    echo 'sorry, category 2 has no items';
}
Damien Regad
@dregad

@giopk

Hi, sent you an email a couple of days ago but got no answer, did you receive it?

Yes I got it, sorry I've been busy... Will reply as soon as I can, I hope by end of the week.

Damien Regad
@dregad

@webspectrum_gitlab

is there a more efficient way to do the following without having a query for each catid ?

Sure, you need to use a parameterized statement and bind variables, e.g.

$q = 'SELECT col1, col2, catid FROM table WHERE catid = ?';
$r1 = $db->execute($q, [1]);
$r2 = $db->execute($q, [2]);

See https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_bind:bind_vars. If your database supports them, you may want to use a prepared statement.

Mangal Kumar
@dmiepub

I installed adodb by composer, pls help me to include it;
I am trying to use it like this but it Uncaught Error: Class "ADOdb\ADOdb\Session\ADODB_Session" not found.
use ADOdb\ADOdb\Session\ADODB_Session;

when we installed it by download method then we are including it like this
include('includes/adodb5/session/adodb-session2.php');

Damien Regad
@dregad
oncfelipe
@oncfelipe
image.png
Hi everyone! IDK what I'm missing in a simple Firebird connection statement...
image.png
Damien Regad
@dregad
Looks like you did not install the firebird php extension
oncfelipe
@oncfelipe

Looks like you did not install the firebird php extension

That's the thing, I did install php extension... not sure why I'm getting this missing extension error.

image.png
Damien Regad
@dregad

ADOdb Version 5.22.3 released

See Changelog https://github.com/ADOdb/ADOdb/blob/v5.22.3/docs/changelog.md
Marc Laporte
@marclaporte_gitlab
Congrats and thank you!
Damien Regad
@dregad

ADOdb Version 5.22.4 released

Hotfix release.
See Changelog https://github.com/ADOdb/ADOdb/blob/v5.22.4/docs/changelog.md
Marc Laporte
@marclaporte_gitlab
Thank you
Damien Regad
@dregad
You're welcome