jazzman1
Staff Alumni-
Posts
2,713 -
Joined
-
Last visited
-
Days Won
12
Everything posted by jazzman1
-
fine tuning MySQL server configuration for better performance
jazzman1 replied to jeger003's topic in MySQL Help
Please, don't pressure the people of the forum! -
You can execute linux commands within a php script using a shell_exec - http://php.net/manual/en/function.shell-exec.php As Christian mentioned above it's quite easy to make a bash script which does this. Take a look at here, make sure that your Slackware has a web CGI library installed on it - http://www.yolinux.com/TUTORIALS/BashShellCgi.html
-
I think your answer lies here -> http://www.brennan.i...ml#ddnsservices You need to purchase a unique domain name ($8-10 per year) and using sites like TZO.com, DynDNS.com, etc. to register that particular domain name through their web services. (http://dyn.com/) DDNS allows dynamic IP account users a service where their DNS records are updated if their connection (IP Address) details change, and then allows the updated information to be propagated throughout the rest of the DNS world After registration you need to add the information that they will provide you to your home router, just check for a tab named: DDNS. If your ip address is a static, everything that you need is to purchase a domain name and if you have enough knowledge about servers to make your local machine as DNS server. if you use a linux one, especially RedHat or Centos, I could help you to set up properly.
-
Christian, I don't understand the question from OP very well. He wants to use some of the resources from a remote server into the local machine or backwards?
-
cant connect my results page to connect with mysql database - Help!
jazzman1 replied to Glasgow-Guy's topic in MySQL Help
My point to use SSH was to get a list of your database names (or create a new one) using only SSH, but it seems in that particular shared web hosting environment, the databases are hosted on a separate server. No one of us couldn't help you in this situation. -
Pika's reply is correct! Your sql string is not readable at all, try to re-design it.
-
Make sure that you have an empty space between a select and the first backtick, after and before FROM too!
-
What is the status of the server - up or down ?
-
yes
-
What type of structure is nice_date in your DB, is it varchar?
-
Any errors? Can you echo the query before to send it to db? Example: $query = 'SELECT * FROM sample WHERE `nice_date` >= "'.$year.'-01-01" and `nice_date` < "'.$year.'-01-31" AND `product_name` LIKE "%'.$brand.'%" AND `product_name` LIKE "%'.$brand2.'%" '; echo $query; exit;
-
No, just stop it: Line: 129
-
Can you echo it we to see the real string?
-
Changing the name of file uploaded adds up Array to the name
jazzman1 replied to ChrisPHP's topic in PHP Coding Help
Try, $target = basename($_FILES['AImage']; $value = array_shift($target); $target = $target . $value . $an .'.jpg'); -
cant connect my results page to connect with mysql database - Help!
jazzman1 replied to Glasgow-Guy's topic in MySQL Help
Yep, there is opened port 22 (SSH) [jazzman@localhost ~]$ nmap -sT 217.8.240.25 Starting Nmap 5.51 ( http://nmap.org ) at 2013-01-05 18:42 EST Nmap scan report for uniform.rb.xcalibre.co.uk (217.8.240.25) Host is up (0.12s latency). Not shown: 995 filtered ports PORT STATE SERVICE 21/tcp open ftp 22/tcp open ssh 25/tcp open smtp 80/tcp open http 443/tcp closed https Nmap done: 1 IP address (1 host up) scanned in 7.28 seconds You can try to log in trying to use FTP password or if you remember something about that. If your log in has been successfully you could be obtain an information about database without to log in. -
cant connect my results page to connect with mysql database - Help!
jazzman1 replied to Glasgow-Guy's topic in MySQL Help
Give us the domain name of that site to check which ports are open. -
cant connect my results page to connect with mysql database - Help!
jazzman1 replied to Glasgow-Guy's topic in MySQL Help
Does your hosting provider provide you something like control panel or SSH access? -
There are to many if's You are missing to close a foreach loop. Take a look at that, <?php $facebook_pade_id = 'id'; $access_token = 'token'; $number_of_posts = 5; $json_content = file_get_contents('http://graph.facebook.com/'.$facebook_page_id.'/feed?access_token='.$access_token); $raw_data = json_decode($json_content); $i=0; foreach($raw_data->data as $feed): $feed_id = explode("_", $feed->id); if (!empty($feed->message)): $i++; if($i<($number_of_posts+1)): ?> <div class="fb_update"> <?php if (!empty($feed->likes->count)) { ?> <div class="fb_likes"><?php echo $feed->likes->count; ?></div> <?php } ?> <?php if (!empty($feed->created_time)) {?> <div class="fb_date"><?php echo date('F j, Y', strtotime($feed->created_time));?></div> <?php } ?> <div class="fb_message"><?php echo $feed->message; ?></div> </div> <?php endif; // end the second if statement endif; // end the first if statement endforeach; // end the foreach loop
-
Hey Christian! I've made streaming into my local server in 4 different ways. To obtain more information about it click here - http://www.videolan.org/doc/streaming-howto/en/ch04.html If someone wants to test my streaming, I've started a song from Michael Jackson (mp3). It worked just fine with a video file too. For windows users just copy/paste this part of code into IE browser - mms://216.58.61.35:8080 For UNIX one, they could be install a VLC and in Network Media Streaming's tab to paste that: mmsh://216.58.61.35:8080
-
He-he-he, good observation
-
It shouldn't have a comma before the sql from clause!
-
No, I copy/paste the string into my machine and I got this: ''art.stevenjacobs@yahoo.com'' There are empty spaces between the quotes, that's why you got an error message.
-
No, rid single quotes off '%s'. Try that one and give me a result back: $check_email = sprintf("SELECT `EMAIL` FROM `subscribers` WHERE `EMAIL` = %s", GetSQLValueString($_POST['email'], "text")); echo $check_email; exit; EDIT: That one has a correct sql syntax - SELECT `EMAIL` FROM `subscribers` WHERE `EMAIL` = ''art.stevenjacobs@yahoo.com'' Why do you get a Sql Syntax Error Message?
-
@StevenJacobs, you're going to other direction! Could you give me a result back of my reply #35?
-
Problem With A Php Script Using Mysqldump And Cron Job
jazzman1 replied to azw's topic in MySQL Help
Ah.., I was thinking that this one is a dedicated server The script that I wrote in replay #8 works just fine. If you want to use SSH to connect to the remote server without asking you for a password (otherwise bash will be stuck) you need to install a trusted certificate between the client and a server. Take a look at that guide, it will help you - http://www.linuxproblem.org/art_9.html