Jump to content

newhip

Members
 View Profile  See their activity

  • Posts

    39

  • Joined

  • Last visited

 Content Type 

Posts posted by newhip

    Search 2 tables at once

    in MySQL Help

    Posted

    Ok if have some code that i am trying to add to. 

    <form action="#" method="post" enctype="multipart/form-data">
<input type="text" name="search"/>
<input type="submit" name="search1"/>
</form>
<?php

if(isset($_POST['search1'])){
$search=mysql_real_escape_string($_POST['search']);
}
include 'connect.php';
if(isset($_POST['search1'])){

$query=mysql_query("SELECT * FROM media WHERE 
extra_cred  LIKE '%".$search."%' OR 
artist_id  LIKE '%".$search."%' OR 
title  LIKE '%".$search."%' OR 
content  LIKE '%".$search."%' OR 
detail  LIKE '%".$search."%' OR 
tags  LIKE '%".$search."%' OR 
user  LIKE '%".$search."%' OR 
type LIKE '%".$search."%'

")
?>

    What I would like to do is also search another table within that database by the name of artists with the same POST data. Anyone know what to do? I've been at this for a while.

    $GLOBALS

    in PHP Coding Help

    Posted

    Ok i got a new problem regarding this same topic... 

     

    I got everything working and I'm able to read off the the url with $_SERVER but now it's looking for a file on my server.  How do i make it not look for a file and just know that it's actually just data that i've injected into the url?

    $GLOBALS

    in PHP Coding Help

    Posted

    Ok I've seen urls like www.domain.com/title-of-page-blah-blah and i understand how to make the url with the dash.

    My question is how to I set that on the index page? I know how to do that after a set a $GLOBALS['q']['view'] and get the page like 

    www.domain.com/view/title-of-page-blah-blah but not without the "view" or wtv i would set it to. Please help.

    FTP

    in PHP Coding Help

    Posted

    Ok I have a problem... My sever has a max_file_upload of 2mb that can't be modified. I need to load larger files than that through a form and not a client like filezila or wtv.

     

    I've looked through so many documents looking to find the answer and have found none. Does anyone know how this can be done? I want this to be done through php. I'm thinking maybe breaking down the file or using php ftp or something but have no idea where to start! HELP!!!

    Custom player

    in Javascript Help

    Posted

    Hey guys i have a general question not sure if this is the right place to post it but im going to go ahead and ask.

     

    I'm looking to design my own media player that can be embedded in other pages. Problem is i cant seem to figure out how to start.

    Could someone point me in the right direction?

     

    I'm assuming JavaScript is the language i should try doing this with but not sure!

     

    any Input is appreciated.

     

    would be an audio player.

    animate one at the time

    in Javascript Help

    Posted

    Hey guys, 
    I modified a script that i found on the web and and i'm trying to use it as a thumbnail gallery scroller (for lack of better words).
    The problem i'm running into right now is that when i click either the left or the right buttons all of the boxes scroll. I'm trying to use the (this) "selector" but i'm having trouble figuring it out can someone perhaps help me a bit with this one? would be greatly appreciated.

     

    Here's the html.

    <div class="container">
<div class="arrowL"><img  src="left.png"    width:'20';
    height:'100'; />
</div>
<div class="arrowR"><img src="right.png"    width:'20';
    height:'100';/>
</div>
<div class="list-container">
    <div class='list'>
        <div class="item">
        </div>
            <div class="item">
        </div>
            <div class="item">
        </div>
            <div class="item">
        </div>
            <div class="item">
        </div>
            <div class="item">
        </div>
	</div>
</div> 
     
    </div>

    The css.

    .item{ background-color:#FFFFFF;
    width:120px;
    height:90px;
    margin:5px;
    float:left;
    position:relative;
}
 .container{
width:1000px;
height:100px;
}
.list-container { 
display:inline-block;
overflow:hidden;    
width: 960px;  
float:left;    
}
.list{
    background:grey;
min-width:1500px;
    float:left;
}
.arrowR{
    width:20px;
    height:100px;
    float:right;
    cursor:pointer;
	opacity:0.5;
}
.arrowL{
    width:20px;
    height:100px;
    float:left;
    cursor:pointer;
opacity:0.5;
}

    And the js.

    <script>
$(document).ready(function() {

    var $item = $('div.item'),
        visible = 7,
        index = 0, 
        endIndex = ( $item.length / visible ) - 1; 

    $('div.arrowR').click(function(){
        if(index < endIndex ){
          index++;
          $item.animate({'left':'-=300px'});
        }
    });

    $('div.arrowL').click(function(){
        if(index > 0){
          index--;            
          $item.animate({'left':'+=300px'});
        }
    });
});
</script>

    Anyone know what i'm doing wrong?

    overflow scroll

    in CSS Help

    Posted

    I have been trying to look up how to make a div that has a side scroll ability but with out the the ugly normal overflow:scroll attribute. I have seen it used plenty of times but its like nobody knows what i am talking about. Just a div that would inside or on either sides have a right, left ability to scroll. Could anyone help me out? I'm not even sure what language would support this kind of thing. I'm thinking jQuery but could find anything on the subject. Any help would be so appreciated.

    fetch_assoc

    in PHP Coding Help

    Posted

    Hey I have a piece of code that I sort of understand why it is not working but then i dont know how to get around it

     

    <?php
include 'xconn.php';
$get_id = $_REQUEST["name"];
$seartt=mysql_query("SELECT * FROM work WHERE name=".$get_id);
$row = mysql_fetch_assoc($seartt);
?>

     

     The error is "mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in"

    Not sure how to stagger or make this work. Any help is appreciated. Thanks.

    wont insert

    in PHP Coding Help

    Posted

    its giving me

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'videodescription) VALUES ('','','')' at line 1

    still dont get ti

    wont insert

    in PHP Coding Help

    Posted

    i dont understand why my script wont insert can someone help me out per chance?

    <?php
include 'xconnect.php';

$songtitle=$_POST['songtitle'];
$songartist=$_POST['artist'];
$songsingle=$_POST['single'];
$songdescrip=$_POST['songdescription'];
$songinsrt=mysql_query("INSERT INTO songtable (title,song,description) VALUES ('$songtitle','$songsingle','$songdescrip')");

	
$vidtitle=$_POST['videotitle'];
$ARTISRS=$_POST['artist'];
$vidvideo=$_POST['video'];
$viddescrip=$_POST['viddescrip'];
$insert=mysql_query("INSERT INTO videotable (title,,description,video) VALUES ('$vidtitle','$viddescrip','$vidvideo')");
	








?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link rel="stylesheet" href="uploadstyle.css" type="text/css" />

</head>
<div class="supercont">
<body><div id="songupload"><center><h2>SONGS</h2></center>
<form enctype="multipart/form-data" method="post" action="uploadstyle.php">
<center><h4>Title:</h4></center><input type="text"  name="songtitle" /><br /><br />
<center><h4>Artist:</h4></center><input type="text" name="artist" /><br /><br />
<center><h4>Single:</h4></center><input type="text" name="single" /><br /><br />
<center><h4>Description:</h4></center><center><textarea id="songdescrip" name="songdescription"></textarea></center>
<center><input type="submit" name="submit" /></center>
</form></div>

<div id="videoupload"><center><h2>VIDEOS</h2></center>
<form enctype="multipart/form-data" method="post" action="uploadstyle.php">
<center><h4>Title:</h4></center><input type="text"  name="videotitle" /><br /><br />
<center><h4>Artist:</h4></center><input type="text" name="artist" /><br /><br />
<center><h4>Video:</h4></center><input type="text" name="video" /><br /><br />
<center><h4>Description:</h4></center><center><textarea id="viddescrip"name="viddescrip"></textarea></center>
<center><input type="submit" name="submit" /></center>
</form>

</div>

</div>

</div>


</body>
</html>

     

    It wont insert into the videotable but does for others

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.