Executing a command line in a directory and its subdirectories
I'm finally about to make the jump from PHP's mysql driver to the newer mysqli one using the mysqli converter tool.
The tool is called by this command line:
e.g. at the web root:
It's a fast tool and I'm trying to minimize downtime and errors I might make by missing a subdir level.
How would I get a list, starting at /usr/share/nginx/html and drilling down, then feed it to that command line?
Thanks for any pointers.
Last edited by Franklin52; 12-08-2013 at 06:55 AM..
Reason: Please use code tags
Can someone please tell me how to modify/add to this code so that it recognizes UNIX command options (all beginning with "-") and executes the command with options?
#include<stdio.h>
#include<stdlib.h>
int main(int argc, char *argv)
{
int i;
system("stty -echo");
... (8 Replies)
I need to develop a makefile that spans across directories. For example, let's say i have an upper level directory (main) and about 2 subdirectories. I want my .cpp files and .o files to be in one subdirectory. I want my .a files to be in the other subdirectory. The .a files are made up of the... (0 Replies)
Hi Guys.
I am a complete shell scripting newbie with some syntax and commands understanding. I'm more of a win admin. With that said: I need to write a shell script to monitor a directory '/Mon_Dir' for new occurrences of files with .xx extension. Once a new file is detected in the directory, a... (4 Replies)
I'm trying to remove several directories which contains sun-dirs and files inside.
I used the command rm -r <dirname>
But, it always ask "examine file in directory <dirname> yes/no?" line by line.
So, i need to write "y" for every line.
How can i skip this step and remove all directories with... (9 Replies)
Hi,
This is a quick one.
I have got a review comment in one of the scripts that i wrote:
"In UNIX script it not advisable to use cd to a directory and then run command."
Is this true?
I was trying to cd to log directory and use some cat or head or ls command.
Many Thanks,
Sam (2 Replies)
Hello,
I've been trying to run 'ls -1R | wc -l' inside of sub directories to in order to determine how big each folder is.
find . -maxdepth 1 -type d | while read folder
do
cd "$folder" &&
echo "$folder has $(ls -1R | wc -l) files" &&
cd ..
done
or
for... (3 Replies)
Hi,
Is it possible for me to include the results from a command in the subject line? What I am looking to do is get the file count and include it into the subject line as well as the list of files in the body.
Example Subject line: Currently 25 files in directory
My Code:
#!/bin/ksh
cd... (2 Replies)
Hi,
I am a newbie in shell scripting. I have to copy a particular sub-directory (data) from a large no. of directories (all in the same folder) and paste them to another directory ( /home/hubble/data ) and then rename all the subdirectories (data) as the name of its parent directory.
please... (8 Replies)
Hi Forum,
I am using the below command to find files older than x days in a directory excluding subdirectories. From the previous forums I got to know that prune command helps us not to descend in subdirectories. Though I am using it here, not getting the desired result.
cd $dir... (8 Replies)
Discussion started by: jhilmil
8 Replies
LEARN ABOUT PHP
mysqli_stat
MYSQLI_STAT(3) 1 MYSQLI_STAT(3)mysqli::stat - Gets the current system status
Object oriented style
SYNOPSIS
string mysqli::stat (void )
DESCRIPTION
Procedural style
string mysqli_stat (mysqli $link)
mysqli_stat(3) returns a string containing information similar to that provided by the 'mysqladmin status' command. This includes uptime in
seconds and the number of running threads, questions, reloads, and open tables.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)RETURN VALUES
A string describing the server status. FALSE if an error occurred.
EXAMPLES
Example #1
mysqli::stat example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
printf ("System status: %s
", $mysqli->stat());
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
printf("System status: %s
", mysqli_stat($link));
mysqli_close($link);
?>
The above examples will output:
System status: Uptime: 272 Threads: 1 Questions: 5340 Slow queries: 0
Opens: 13 Flush tables: 1 Open tables: 0 Queries per second avg: 19.632
Memory in use: 8496K Max memory used: 8560K
SEE ALSO mysqli_get_server_info(3).
PHP Documentation Group MYSQLI_STAT(3)