Add/Edit Page > Before Record Added > QR Code

$values is an array that stores values of individual fields. You need to use it the following way:

$values["https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=http://10.1.1.1/phprnrapp_view.php?editid1=";] simply doesn't make any sense.
You can not also use backticks (`) instead of double quotes (").

$values["https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=http://10.1.1.1/phprnrapp_view.php?editid1=";] simply doesn't make any sense.
You can not also use backticks (`) instead of double quotes (").

The idea is to use the Google QR Code Generator to create an link to the specific page where the data is recorded.
The following MySQL query works, I guess I am confused how to translate it to PHPRunner.

Is 'id' is your key column or just a regular field?

It is the key column.

The problem with key column that its value doesn't exist before record is physically created in the database. In BeforeAdd event the record in question doesn't exist yet.
What you can do is to run the same SQL code in AfterAdd event:

Makes sense, can't believe I didnt think about that. thanks

I keep getting an error...

I think its the forward slashes (//) in the URL being recognized as a comment. Is there any way around that?

In case anyone else runs into this issue I figured it out. You have to addslashes to define that the backslashes in the URL is not a comment.
Example