|
I learn basic SQL from this video SQL for Beginners
and how to go to next step?
What is the best site for learn sql in advanced level?
|
|
|
|
|
There are many sites that offer SQL tutorials and samples. You have to decide which one is 'best' according to your knowledge and ability. To become really accomplished there is no substitute for doing it. Create some databases and practice all the different commands until you are thoroughly familiar with them. See https://www.google.com/search?q=msdn%3A%20sql[^] for some of Microsofts offerings.
|
|
|
|
|
|
also don't forget that learning anything to advanced levels requires time and experience, so before you go read a bunch more theory work with it at the level you know and radually push yourself until you hit things you want to do but don't know how to
wax on wax off
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
|
|
|
|
|
I'm looking for a link redirecting script (php) or wordpress plugin that will switch links based on how many times clicked. I know its simple, and I thought it would be very easy to find but I can not find a useful tool anywhere. Thought maybe you guts could help.
|
|
|
|
|
|
please check the code and tell me if there is any problem.as far as i know there is some problem with the text data not being sent toh php file.
<html>
<head>
<title>Ajax Search Box using PHP and MySQL</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="typeahead.min.js"></script>
<script>
$(document).ready(function(){
$('input.typeahead').typeahead({
name: 'typeahead',
remote:'search.php?key=%QUERY',
limit : 10
});
});
</script>
.bs-example{
font-family: sans-serif;
position: relative;
margin: 50px;
}
.typeahead, .tt-query, .tt-hint {
border: 2px solid #CCCCCC;
border-radius: 8px;
font-size: 24px;
height: 30px;
line-height: 30px;
outline: medium none;
padding: 8px 12px;
width: 396px;
}
.typeahead {
background-color: #FFFFFF;
}
.typeahead:focus {
border: 2px solid #0097CF;
}
.tt-query {
box-shadow: 0 1px 1px rgba(0, 0, 0, 0.075) inset;
}
.tt-hint {
color: #999999;
}
.tt-dropdown-menu {
background-color: #FFFFFF;
border: 1px solid rgba(0, 0, 0, 0.2);
border-radius: 8px;
box-shadow: 0 5px 10px rgba(0, 0, 0, 0.2);
margin-top: 12px;
padding: 8px 0;
width: 422px;
}
.tt-suggestion {
font-size: 24px;
line-height: 24px;
padding: 3px 20px;
}
.tt-suggestion.tt-is-under-cursor {
background-color: #0097CF;
color: #FFFFFF;
}
.tt-suggestion p {
margin: 0;
}
</head>
<body>
Ajax Search Box using Node and MySQL Codeforgeek Tutorial
<button type="button" class="btn btn-primary btn-lg">Visit Tutorial</button>
<input type="text" name="typeahead" class="typeahead tt-query" autocomplete="off" spellcheck="false" placeholder="Type your Query">
</body>
</html>
|
|
|
|
|
Don't expect other people to run and debug your code for you. We're glad to help if you will narrow down the issue and ask a specific question.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
im trying to get one response from a form inside a aspx web page but i only get the same page without styles.
Whats is my error? Exist other alternative?
URL WEB SITE
<?php
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://the web site/');
curl_setopt($ch, CURLOPT_USERAGENT,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/32.0.1700.107 Chrome/32.0.1700.107 Safari/537.36');
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, "ddlCiudad=05001&ddlEntidadEspecialidad=121-True-3110-05001-Juzgado de Circuito-Familia&rblConsulta=1&a5kuj4redmp05gddr1lfjij5=05001316000420140143000");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_COOKIESESSION, true);
curl_setopt($ch, CURLOPT_COOKIEJAR, 'cookie.txt');
curl_setopt($ch, CURLOPT_COOKIEFILE, '');
$answer = curl_exec($ch);
if (curl_error($ch)) {
echo curl_error($ch);
}
echo $answer;
curl_setopt($ch, CURLOPT_URL, 'http://the web site/');
curl_setopt($ch, CURLOPT_POST, false);
curl_setopt($ch, CURLOPT_POSTFIELDS, "");
$answer = curl_exec($ch);
if (curl_error($ch)) {
echo curl_error($ch);
}
echo $answer;
?>
CASE NUMBER: 05001316000420140143000
Now, i need this answer:
URL IMAGE RESPONSE
Thanks!
|
|
|
|
|
Hi,
I have a strange behaviour in a php script.
1. I list all files of a directry and it's subdirectories in an array.
2. I convert all names in utf-8 and put them in a second array.
3. I serialize and save both arrays in binary files.
4. I rename all files by stripping accents, spaces and all non-ASCCI characters (normalized names).
5. I unserialize the binary files in new arrays and then ...
all that I get is only the normalized names in each table.
I can't understand how this happens and how to get around.
Note: If I exit the script after 3. and rename the binary files, everything works fine in point 5. by unserializing these renamed binary files.
I would greatly appreciate any suggestion.
Thx for your time.
Michel.
|
|
|
|
|
Michel PIERRE wrote: I would greatly appreciate any suggestion.
Show the code that is not working and indicate where the error occurs.
|
|
|
|
|
Hi Richard,
Thank's for your interest.
Unfortunatly, I have to leave for now.
As there's a big peace of code, I'll simplify it and post it as soon as I can.
Best regards,
Michel
|
|
|
|
|
Hi Richard,
I think I've found a walk-around:
As at the begining I only the names in the differents formats to store in my database, I'll just get them and I'll renames the files after closing the DB.
Hope this will work. But I'm still obseded by this strange behaviour. 
Thanks and cheers.
Michel
|
|
|
|
|
Hi, I'm a total newbie to JavaScript, Ajax and PHP, so please excuse any stupid question I might ask.
So, I'd like to use a lazy loading TreeView which gets it's data from a database via PHP. I found a JavaScript control to use and an example to try out, and now I have a question.
To lazy load the data for the expanded tree node I need to fire an Ajax request to a PHP file which gives me the answer as a JSON stream. In the example I'm trying out this PHP file only delivers one string (with 'echo'), but what do I have to do if I need to loop through a database recordset. Can I 'echo' every partial answer to my lazy loading treeview as I get it from the database or do I need to collect the complete answer inside the PHP file in a string variable and send it only when it's complete?
I hope you understand my question.
Thanks for any answer or advice in advance.
|
|
|
|
|
No there is no real difference between lots of little echoes and one big one with the same content. Depending on your server and its buffering policy, you might find little ones a bit faster.
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
|
|
Hello,
I am a beginner in php and I'd see a picture on the same page by validating certain criteria by pressing a button.
Here the form that I created and I would like the table appears below when I click on the button displaying statistics .
|
|
|
|
|
hint:
1.load the statistics and use css set display:none;button on click,
(jquery) $("id of the table").show something like that
-or-
(javascript) document.GetElementById('id').style.display = block;
2.use javascript / jquery as above, and google for ajax
|
|
|
|
|
Hi,
I am getting the following error in my index.php:
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/meskholdings/meskholdings.com/jobs/index.php:1) in /home/meskholdings/meskholdings.com/jobs/index.php on line 3
I checked my code and my session_start() is the first line. cany anyone help please...
this is my index.php:
<?php
include("php_header.php");
include("connect2db.php");<br />
?>
<!DOCTYPE html>
<html lang="en">
<head>
and this is my php_header.php:
<?php
ob_start();
if(!isset($_SESSION)) { session_start(); }
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL & ~E_NOTICE);
?>
Technology News @ www.JassimRahma.com
|
|
|
|
|
Look out for any whitespace, including newlines.
<?php
include("php_header.php");
include("connect2db.php");
?><!DOCTYPE html>
|
|
|
|
|
|
Hello
I need a simple code that I can give a URL of image to this code and this code save the image in host.
Regards
|
|
|
|
|
Please don't post the same question in multiple places.
Also posted in QA: How can Save Image with PHP?[^]
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
copy_player_image($url,$destinationurl);
copy_player_image($imgurl,$destinationurl){
$image = file_get_contents($imgurl);
$imgpath = 'images/xyz.jpg";
$fullpath = $_SERVER['DOCUMENT_ROOT'].$destinationurl;
if(!file_exists($fullpath)){
unlink($fullpath);
file_put_contents($fullpath, $imageurl);
}
return $imgpath;
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
