05-09-2019
Voila!
Changed the last part with exact match like shown below and no need to create a second query to grab video_id:
.....WHERE url = 'http://localhost/test/" $1 ".mkv';"}
What I still do not know is how it grabs video_id as value in SELECT field.
I did not tell it to read video_id where $1 matches.
I supposed that I should have created a second query to grab it which was the main purpose of the thread.
Thank You All
Boris
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i am using the below script and trying to move files in that directory in that pattern to archive. But it doesn;t seem to take the metacharacters. Please sugggest.
Code
Debug output: (1 Reply)
Discussion started by: dsravan
1 Replies
2. Shell Programming and Scripting
I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish...
. $X='grep foo blah.log'
then 'mysql command SELECT foo FROM bar WHERE ' . $X
or something like that.
... (2 Replies)
Discussion started by: kero
2 Replies
3. Shell Programming and Scripting
Hi Gurus
I have a file called /tmp/CMDB which looks like this
serial: 0623AN1208
hostname: server1
model: x4100
assetID: 1234
I am writing a for loop that will go through this file line by line creating a variable of itself. Using the first iteration of the loop (i.e. the first line) as... (6 Replies)
Discussion started by: hcclnoodles
6 Replies
4. Shell Programming and Scripting
Hi all,
I have a variable say var1 (output from somewhere, which I can't change)which store something like this:
echo $var1
name=fred
age=25
address="123 abc"
password=pass1234
how can I make the variable $name, $age, $address and $password contain the info?
I mean do this in a... (1 Reply)
Discussion started by: freddy1228
1 Replies
5. Shell Programming and Scripting
I'm running a bash script query and assigning the output to a variable like this:
exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \
-e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \
AND field2 ='$b' LIMIT 0 , 30";`
which returns something like:
echo... (2 Replies)
Discussion started by: unclecameron
2 Replies
6. Shell Programming and Scripting
Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format:
firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies
7. UNIX for Dummies Questions & Answers
Is FreeBSD and OpenBSD considered Unix? What O.S does Most of the forum members use? How popular are Licensed Unix operating systems for home users?
Additionally I thought Linux was a Minux fork and BSD was a Unix fork.
Thanks in ... (7 Replies)
Discussion started by: theKbStockpiler
7 Replies
8. UNIX for Advanced & Expert Users
Hi all,
I'm bit new to the advanced bash shell scripting.
When I'm looking at some of the existing code in my organization, got confused with a few variable definings.
For ex:
var1={1:-30}
var2="abc def ghi"
var3={xyz:-$var2}
In above, 1st and last lines are confusing me.... (4 Replies)
Discussion started by: raghu.iv85
4 Replies
9. UNIX for Dummies Questions & Answers
I'm a bit confused about the term ‘environment variables'.
Within your shell you can set two types of variables:
1. Shell variable - affecting functionality within your shell
2. User defined variable
When using the ‘export' command on a variable you make sure it's being inherited by new sub... (2 Replies)
Discussion started by: niels
2 Replies
LEARN ABOUT PHP
mysqlnd_uh_set_connection_proxy
MYSQLND_UH_SET_CONNECTION_PROXY(3) 1 MYSQLND_UH_SET_CONNECTION_PROXY(3)
mysqlnd_uh_set_connection_proxy - Installs a proxy for mysqlnd connections
SYNOPSIS
bool mysqlnd_uh_set_connection_proxy (MysqlndUhConnection &$connection_proxy, [mysqli &$mysqli_connection])
DESCRIPTION
Installs a proxy object to hook mysqlnd's connection objects methods. Once installed, the proxy will be used for all MySQL connections
opened with mysqli, mysql or PDO_MYSQL, assuming that the listed extensions are compiled to use the mysqlnd library.
The function can be disabled with mysqlnd_uh.enable. If mysqlnd_uh.enable is set to FALSE the function will not install the proxy and
always return TRUE. Additionally, an error of the type E_WARNING may be emitted. The error message may read like PHP Warning:
mysqlnd_uh_set_connection_proxy(): (Mysqlnd User Handler) The plugin has been disabled by setting the configuration parameter
mysqlnd_uh.enable = false. The proxy has not been installed [...].
PARAMETERS
o $connection_proxy
- A proxy object of type MysqlndUhConnection.
o $mysqli_connection
- Object of type mysqli. If given, the proxy will be set for this particular connection only.
RETURN VALUES
Returns TRUE on success. Otherwise, returns FALSE
EXAMPLES
Example #1
mysqlnd_uh_set_connection_proxy(3) example
<?php
$mysqli = new mysqli("localhost", "root", "", "test");
$mysqli->query("SELECT 'No proxy installed, yet'");
class proxy extends MysqlndUhConnection {
public function query($res, $query) {
printf("%s(%s)
", __METHOD__, var_export(func_get_args(), true));
$ret = parent::query($res, $query);
printf("%s returns %s
", __METHOD__, var_export($ret, true));
return $ret;
}
}
mysqlnd_uh_set_connection_proxy(new proxy());
$mysqli->query("SELECT 'mysqlnd rocks!'");
$mysql = mysql_connect("localhost", "root", "", "test");
mysql_query("SELECT 'Ahoy Andrey!'", $mysql);
$pdo = new PDO("mysql:host=localhost;dbname=test", "root", "");
$pdo->query("SELECT 'Moin Johannes!'");
?>
The above example will output:
proxy::query(array (
0 => NULL,
1 => 'SELECT 'mysqlnd rocks!'',
))
proxy::query returns true
proxy::query(array (
0 => NULL,
1 => 'SELECT 'Ahoy Andrey!'',
))
proxy::query returns true
proxy::query(array (
0 => NULL,
1 => 'SELECT 'Moin Johannes!'',
))
proxy::query returns true
SEE ALSO
mysqlnd_uh_set_statement_proxy(3), mysqlnd_uh.enable.
PHP Documentation Group MYSQLND_UH_SET_CONNECTION_PROXY(3)