PHP - Music Api Not Searching Any Data

There are websites like Soundcloud, Soundclick, MySpace and more.   The Question: How to not get a law suite as a website owner when copyright protected music or in other words music from the retail has gotten uploaded?   Will moderating it and having it frequently taken down do the job?   I know that the users themselves could get researched too. The site owner could get requested to give out IP addresses. Though, I kept this separately from that question.   I basically would be looking to be safe and not get a law suite.   I would appreciate the suggestions a lot.

hi!
i want to upload videos and music files using php but it's not working correctly.through this code imges are uploaded successfully but there is problem with video files ..i hv use php.ini to resolve the size prblem but still its not working..can u give me any code that works perfectly.
here is my code..
 Collapse
<?php
ini_set('post_max_size', 5242880);    // Set upload limit (5MB)
ini_set('upload_max_filesize', 5242880);    // Enforce upload limit
ini_set('max_execution_time', 2400);    // Increase 'timeout' time

echo "<form enctype='multipart/form-data' name='form2' method='post' action='video.php?view_id=view'>";
if(isset($_REQUEST['Submit']))
{
print_r($_FILES['file2']);
$music=($_FILES['file2']['name']);
if($_FILES['file2']['error']>0)
{
    echo "error accured";
}
else
{
    move_uploaded_file($_FILES['file2']['tmp_name'],"uploadedMusic/".$_FILES['file2']['name']);
}
 
}
 
echo "<input name='file2' type= 'file'>";
echo "<input name='Submit' type='submit' value='upload music'>";
echo "</form>";
?>

This topic has been moved to Other.

http://www.phpfreaks.com/forums/index.php?topic=354424.0

Ok I have a set of PDF files that i need to be searchable. My question how do i go about doing this. Can this be achieved with php or do a need to do something else?

Hi im really confused and annoyed

Im making a real estate website and im stuck ont eh searching for a house part.

Im trying to set up some searches on the different parts of the house usign text boxes for area and postcode and drop boxes for type and bedrooms and bathrooms

i now you have to set up a form with input type text and then call it a name use get/post on a php side and then  $_POST['search'];

But i dnt seem to be able to make a search was hoping someone was kind enough to knock me up some quick code so it is functional and makbe i can work from it

A;so any help towards searching using dropboxes would be awsume and if i have 2 boxes for price upper and lower how would this work

Much appreciated

So I've full text indexed the columns I want searchable:




I have some rows inserted:




Yet when I run a match() against(), I get 0 results:



If I do:
Code: [Select]
SELECT * FROM video WHERE MATCH (name) AGAINST ('test')
I get 2 results. Why does that work, yet keywords don't?

Hi, I want to create a search which uses the 'title' of my 'product' table and matches the terms the user has submitted.
At the moment, my products are displaying one by one.

For example,
I have an apple and apricot in my table.
The user searches 'a' and the search results show 'apple' but not apricot.

Here's my code:
Code: [Select]
<?php 
require_once('inc/global.inc.php');

# search.inc.php

/* 
 * This is the search content module.
 * This page is included by index.php.
 * This page expects to receive $_GET['terms'].
 */

// Redirect if this page was accessed directly:
if (!defined('BASE_URL')) {

// Need the BASE_URL, defined in the config file:
require_once ('../includes/config.inc.php');

// Redirect to the index page:
$url = BASE_URL . 'index.php?p=search';

// Pass along search terms?
if (isset($_GET['terms'])) {
$url .= '&terms=' . urlencode($_GET['terms']);
}

header ("Location: $url");
exit;

} // End of defined() IF.

// Print a caption:
echo '<h2>Search Results</h2>';

// Display the search results if the form
// has been submitted.
if (isset($_GET['terms']) && ($_GET['terms'] != 'Search...') ) {

$terms = $_GET['terms'];
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die *('Error connecting to MySQL server');
// Query the database.
$query = "SELECT * FROM product WHERE title LIKE '%$terms%'";
$result = mysqli_query($dbc, $query);

// Fetch the results.
$row = mysqli_fetch_array($result);

// Print the results:


$output[] = '<ul>';
$output[] = '<li>'.$row['title'] .': &pound;'.$row['price'].'<br /><img src="'.$row['img'].'" alt="'.$row['title'].'" /></li>';

$output[] = '</ul>';
echo join('',$output);
}

else { // Tell them to use the search form.
echo '<p class="error">Please use the search form at the top of the window to search this site.</p>';
}
?>


A friend told me I need to use a for-each loop but I can't figure it out.

Any help is appreciated,
thanks for reading.

I'm having some trouble with a GET search code; everything works until the stringresult but then it dies to Error Querying Database
Code: [Select]
<html>
<body>

<?php

//Get sort setting and search terms from URL with GET
$usersearch = $_GET['usersearch'];
echo 'Search word: ' . $usersearch;
echo '<br>';
require_once("dbvars.php");

//Connect to Database
$dbc = mysqli_connect (DB_HOST, DB_USER, DB_PW, DB_NAME) or die ("Error connecting to database.");

//Build the Query
$query = "SELECT * FROM customers" . 'WHERE customers.given_name=\'' . $usersearch . '\'';
echo $query;

//Execute the Query
$result = mysqli_query($dbc, $query) or die ("Error querying database.");

//Create the Table Headings
echo '<table border="1"><tr>';
echo '<td><b>First Name</b></td>';
echo '<td><b>Last Name</b></td>';
echo '<td><b>Address</b></td>';
echo '<td><b>City</b></td>';
echo '<td><b>Province</b></td>';
echo '<td><b>Postal Code</b></td>';
echo '<td><b>Phone Number</b></td>';
echo '</tr>';

//Display Results through Array Loop
While ($row = mysqli_fetch_array($result)) {
echo '<tr><td>' . $row['given_name'] . '</td>';
echo '<td>' . $row['surname'] . '</td>';
echo '<td>' . $row['address'] . '</td>';
echo '<td>' . $row['city'] . '</td>';
echo '<td>' . $row['province'] . '</td>';
echo '<td>' . $row['postal_code'] . '</td>';
echo '<td>' . $row['phone_number'] . '</td></tr>';
}
'</table>';

// Close the database connection
mysqli_close($dbc);

?>


<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">
 <input name="usersearch" type="text" size="30" />
<input name="submit" type="submit" value="go" />
</form>

</body>
</html>

I've been reading a few tutorials on how the best way to search key words in a database and at the moment im trying to get this query to work but its coming back with a error:

#1191 - Can't find FULLTEXT index matching the column list

query:

SELECT title, description
FROM items
WHERE MATCH(title, description) AGAINST('xbox')

any help or advise on how the best way to search 2 columns on matching words...thank you  

Dear All,

Greetings!

I am a student and have a final semester project of making a php based form to search a database.

Database is already created:
Username: test
password: test1
Details: DB Name: resume_bank, Table Name: Candidate
Table contents: Name, Phone, Address, DOB, Gender, Designation, experience_yrs, experience_months, Employment_Status

I need the code which would give the user an option to search using AND, OR, ALL functions.

Friends please help.

The form should look like: Enter the Designation you are looking for:
                                         Enter the experience: Yrs___ Months___
                                         Select Gender:

The result must come in another webpage which has numbered display results, like page-1, page-2, page3...

PLEASE HELP URGENTLY!!!!!!!
ANY BODY HAS READY MADE CODE PLEASE SEND IT!!!!!!

Thanks.

<?php
$string = "aStringwith SomeSpecialChars+^$%";

// want to check if there is "+" in it
if( ????? ($string,'+') {
echo "yes string has plus sign";
}
?>

Which function should I use to search in a string ?

I am working on a poject, where the search functions doesnt work as the user wishes. The coding is technically correct, but the idea behind it is wrong.

Basically at the moment, the script receives this:

thesite.com/search.php?q=xxxx&Submit=Search

The search script then runs a database query to search the tag coloumn, looking for like $q. This would work, however the structure of the coloumn is tag1, tag2, tag3, tag4.

So my resolutions is this so far:

I explode the $q variable, via the + (if you search more than one term "thesite.com/search.php?q=search+stuff&Submit=Search"

I then count the elements in the array and write the database function accordingly

Code: [Select]
$var = @$_GET['q'] ;
$trimmed = trim($var);

$searchpieces = explode("+", $trimmed);

$dbquery="";

$count = count($searchpieces);

for ($i = 0; $i < $count; $i++) {
if($i == 0){$dbquery.="tags = $searchpieces[$i]";}
elseif($i > 0){$dbquery.=" OR tags = $searchpieces[$i]";}
}

So my database query is

        $sql = "select * from gallery where $dbquery order by date DESC " . $limit;

so my question is this.. how to i eplode the tags database coloumn, so my datase query an look at each tag fro "tag1, tag2, tag3" as "tag1" "tag2" "tag3"

I am not even sure if this is possible, but its the system that is already in place.

The problem with the current system, is because the pictures have alot of tags and the database query is $like $q, it just shows all images in the database as the result

I am trying to perform a search but it doesn't see to pass through i thing its because of this \ does any one know how i can pass this trought to search in mysql table


12\019PB (i cant search this item)

Code: [Select]
$searchlading = mysql_real_escape_string($_GET['searchlading']) ; // get the query for the search engine (if applicable)
$trimmed = trim($searchlading); //trim whitespace from the stored variable
//query for pedimento
$sql_ped = "SELECT order_id, bill_of_lading, pedimento_num FROM `".TABLE_ORDERS."` WHERE bill_of_lading LIKE '%$trimmed%'";

Hi, I have a piece of code which I trying to search two columns but I just cant get it to work.  Instead it just dumps around 30 entries onto the page.  Can anyone point me in the direction of how to search two columns?

Code: [Select]
$query = "SELECT * FROM questions";

if(isset($_GET['question']) && !empty($_GET['notes'] ))
{
/*query the database*/
$question = $_GET['question'];
$notes = $_GET['notes'];
$query .= " WHERE question && notes like '%$question%' LIMIT 0, 10";
}

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$question = $row['question'];
$notes = $row['notes'];

echo "$question
$notes  </br>";
}

Hey,
Looking to find a solution to something. I have been experimenting making a template engine for a website I am building. How can I search a variable for all occurrences of {VARIABLE} eg. {Username} {Title} {Content} so I can str_replace them.

Thank you