PHP - Using An Audio File Thats Stored As A Longblob

Hi all:

I have been going nuts trying to get this to work. I have gone through many attempts based on internet searches and examples that simply do not work.

I have files stored in my MySQL db. The files cna be of any type and are being displayed in a listed report. The files are hyperlinked and clickable, but here is the issue:

When I click on a file in:
http://development.products-and-services.ca/cms/test.php
I get:
http://development.products-and-services.ca/cms/test2.php?content=DHall_CV_webdev_eng.pdf
as a blank page result.
The objective is to get a file download alert or to see the file in the browser.

Any ideas?

Hi,

i have the following code:

where i want the sound to only play during the false part of the IF statement

but currently it always plays on every reload, and even if the IF = true

any ideas? ive tried autoplay="0" also

 

Thanks

 

	<embed src="beep.wav" autostart="false" width="0" height="0" id="sound1"
enablejavascript="true">

+

<script>
function PlaySound(soundObj) {
  var sound = document.getElementById(soundObj);
  sound.Play();
}
</script>

+

		if( isset( $json['Data'] ) ){
			echo "<b>Success</b>";
			echo "</br>";
			echo $data.' x ' .$tqty;  
			echo "</br>";
			
		} else {
			echo "Error";
			echo "</br>";
			echo $json['Message'];
			echo '<script> PlaySound("Sound1"); </script>';
		}

 

Hi.  So I've coded many a file upload form and never had any trouble.  Until now.  For some reason when I try to upload MP3 files, I'll hit submit and the page just reloads.  Once it does so, the file upload field is once again blank.  What's odd is that images and documents upload just fine.  It's only audio tracks that cause the page to reload and clear.  My php.ini max file upload size is at this point set to 100M, and the files I'm trying to upload are under 10M.  Any ideas?  Here's the form code, just to post it-- pretty basic.  I'm at a loss here....  Any ideas would be appreciated.  Thanks very much.



<form action="test.php" enctype="multipart/form-data" method="POST"/>


   <input type = "file" name = "audio" />
   
   <p><input type ="submit" name="submit" value="do it."/><p>

</form>

 wrote a stored procedure this morning and i don’t know how to get the values out of it through a class function in php or phpmyadmin.

here is what i wrote :

public function totalProcedures($friend_name,$session_id) 
{ /* *query to fetch stored procedure */ 
try { 
//executing the stored procedure 
$sql_sp="CALL timeline (:friend, :session,@updates, @group_posts)";
$stmt_sp= $this->_db->prepare($sql_sp); 
$stmt_sp->bindValue(":friend",$friend_name);
$stmt_sp->bindValue(":session",$session_id); 
$stmt_sp->execute();
$rows=$stmt_sp->fetch(PDO::FETCH_ASSOC); 
$stmt_sp->closeCursor(); // closing the stored procedure 
//trying to get values from OUT parameters.
$stmt_sp_2=$this->_db->prepare("select @updates,@group_posts");
$stmt_sp_2->execute();
return $stmt_sp_2->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $ei)
{
echo $ei->getMessage(); } 
}

can someone helpme how to get results.

here is the storedprocedu

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `timeline`(IN `friend` VARCHAR(255), IN `session_id` VARCHAR(255), OUT `updates` VARCHAR(62555), OUT `group_posts` VARCHAR(62555))
BEGIN


select * FROM updates where author in (friend,session_id)  order by time desc limit 5;



select * FROM group_posts where author_gp in (friend,session_id) order by pdate desc limit 5;
END$$
DELIMITER ;

i get the result in php myadmin as follows:

 how do i do this inside a php class function.

CALL timeline('shan2batman','aboutthecreator', @updates, @group_posts);

 

The path to a image is stored in a variable and I need to display this image in the email. Can someone help me.

This is my current attempt and nothing is happening. But the variable passes the URL correctly.

Code: [Select]
<TABLE BORDER='0'>
<TR>
<TD align='left' width='370'><img src='".$dis_logoimg."' width='370' height='86' /></TD>
</TR>
</TABLE>

I'm working on a project and cannot figure out why one piece of code works in one project but not in this one.

Code: [Select]
$username = "voltageme5";
$result = $mysqli->query("call usernameCheck($username)");

returns
string(43) "Unknown column 'voltageme5' in 'field list'"

Here is the stored routine:

Code: [Select]
CREATE PROCEDURE `database`.`table` (IN memUsername varchar(45))
BEGIN
select count(*) as total from members where username = memUsername;
END

Whats weird is that in the PHP code if i replace the variable with a string, it works. It's only with the variable in the call that it errors out like that. I'm new to this stored procedure thing so I'm sure I'm missing something stupid.

Hi Everyone,

I have this php page that runs couple of MS SQL stored procedures to fetch me values from SQL Server, however I have run into a problem where not more then 2 stored procedures are executed at same time. For instance below mentioned code only fetches me values for 1st and 2nd SP's. If I need values from the 3rd stored procedure then I would have to comment either one of the first two stored procedure.   Can someone please tell me what is that I am doing wrong.   I am relatively new to PHP, so please be gentle. Any help would be highly appreciated.

Thanks.

<?php


if($conn = mssql_connect('host', 'user', 'pass')) echo 'Connected to SQLEXPRESS<BR>';
if(mssql_select_db("database",$conn)) echo 'Selected DB: SomeDatabase<BR>';

$variable1=something;

$sql_statement =  mssql_init("stored_procedure1 '$variable1'", $conn);
$result=mssql_execute($sql_statement);

$x=0;

while ($row = mssql_fetch_assoc($result))
    {
    $column2[$x]= $row['column2'];
    $column1= $row['column1'];
    
$x++; }

    
echo "Value 1: $column1      </br>";
echo "Value 2: $column2[0]  </br>";
echo "Value 3: $column2[1]  </br>";
echo "Value 4: $column2[2]  </br>";
echo "Value 5: $column2[3]  </br>";
echo "Value 6: $column2[4]  </br>";
echo "Value 7: $column2[5]  </br>";


mssql_free_statement($sql_statement);



$sql_statement =  mssql_init("stored_procedure2 '$variable1'", $conn);
$result=mssql_execute($sql_statement);


$x=0;

while ($row = mssql_fetch_assoc($result))
    {
    $someval1[$x]= $row['somecolumn1'];
    $someval2[$x]= $row['somecolumn2'];
    $someval3= $row['somecolumn3'];
    $someval4= $row['somecolumn4'];
    $someval5= $row['somecolumn5'];
    $someval6= $row['somecolumn6'];

$x++; }

    
echo "Something1: $someval1[0]</br>";
echo "Something2: $someval3 </br>";
echo "Something3: $someval2[0] </br>";
echo "Something4: $someval4 </br>";
echo "Something5: $someval6 </br>";
echo "Something6: $someval5 </br>";


mssql_free_statement($sql_statement);


$sql_statement =  mssql_init("stored_procedure3 '$variable1'", $conn);
$result=mssql_execute($sql_statement);


$x=0;

while ($row = mssql_fetch_assoc($result))
    {
    $somevaluecheck= $row['somecolumncheck'];

$x++; }
    
echo "SomethingCheck: $somevaluecheck </br>";


mssql_free_statement($sql_statement);


?>

Often times I need to convert between PHP Arrays, MySQL, XML, JSON sqlite etc. Lately I've been just building PHP arrays with all the data. Its a big hassle though when theres a lot of data. I'm thinking I should have one central location that I store data in, then export to other formats from there, but I dont know what that central location should be. I like MySQL because I'm used to it. Sometimes its not an option though, like if I need to make a really light script, I dont want the hassle of connecting to MySQL. Would XML be the best place to store data, then from the XML file I can convert it to whatever format I want?

Hey guys,

I have been banging my head against a wall here with this. I am saving my sessions in my database via session_set_save_handler(). So let me walk you through what I have here, what works, and what the issue seems to be.

basically, the problem is the $_SESSION array is empty on page load.

common.php:
I have the open / close / read / write / destroy / and gc functions. These all work properly as when i use a session variable it stores into the database and i can see all of the information in there..

inside of common.php i have session_start().. I am positive that the session_start() is running becasue common.php is included into index.php and i tried adding session_start() to index.php again and i got an E_NOTICE saying the session already began.

(yes, for the read function i am returning a string... i included that below).

for the table itself, i have set the session_data as both text and blob, same issue with both.


index.php:
includes common.php. I know it's included as other aspects of the file are included and work properly.

if i call var_dump($_SESSION) i get an empty array.  and i prited out the session_id() and it matched my session id in the database. and the values that are stored in there are correct. i have for example:

count|i:0

now with that value actually in the database and when calling session_id() and i get the ID that matches in the table. so i will get an E_NOTICE of an undefined index..

i was trying something like:


if(!isset($_SESSION['count']))
     $_SESSION['count'] = 0;
else
     $_SESSION['count']++;

echo $_SESSION['count'];


Everytime the page is reloaded, count is reset to 0.. I can tell that it is reset to 0 as the expired time changes in the database after every load of the page (which is part of the write function).  I double checked that it wasn't a problem for some reason with the ++ by adding in a variable that sets to 1 when in the if, and 0 if in the else, and it always outputs a 1.

i have included here my read function since that apparently is the issue..

function sess_read($sess_id)
{
      global $DB;      

      $sql = "SELECT `session_data` FROM `sessions` WHERE
                session_id = '".$sess_id."' AND
                session_agent = '".$_SERVER["HTTP_USER_AGENT"]."' AND
                session_expire > '".time()."';";                

       $query = $DB->query($sql);       

       if($DB->num_rows($query) > 0)       
       {

       $r = $DB->fetch($query);       
           return settype($r['session_data'], 'string');           

   }       

   

        
       return '';
}

I tried also with removing the agent and expire check to see if it was an issue there but same problem.

I probably have missed something really dumb but i can't for the life of me figure it out and I have googled around for a similar issue. The actual output of the page is correct.. all of the HTML and CSS information loads properly.. no errors are reported (and i have E_ALL on).

Thanks

I am writting a php function that uses mysql to get user data - pretty common, right

Well, my issue is that I need to run a check in my file system.  Users profile pictures are stored in my image directory as .png's.  I need to have my function check that directory and if an image matches their id, then return their information.  I only want the user data if they have an image uploaded.

Here is my current function:

Code: [Select]
function fetch_users_login($limit)
{
$limit = $limit(int);

$sql = "SELECT
                `users`.`id`,
                `users`.`firstname`,
                `users`.`lastname`,
                `users`.`username`,
`user_privacy`.`avatar`
            FROM `users`
LEFT JOIN `user_privacy`
            ON `users`.`id` = `user_privacy`.`uid`
WHERE `users`.`status` > 2
AND `user_privacy`.`avatar` = 1
ORDER BY `users`.`id` DESC
LIMIT 0, {$limit}";

$result = mysql_query($sql) or die(mysql_error());

$users = array();

$i = 0;

while(($row = mysql_fetch_assoc($result)) !== false)
{
$users[$i] = array(
'id' => $row['id'],
'firstname' => $row['firstname'],
'lastname' => $row['lastname'],
);

$users[$i]['avatar'] = getUserAvatar($row['username']);

$i++;
}

return $users;
}

How can I run php code that is stored in a database?

I have my pages created by grabbing the contents of a pageBody mySQL table cell, but some pages require further php to be able to display correctly.

For example, I have a players page, which will list all players, and some information about them. The players and information is all saved in a players table in my database (separate to the pages table where pageBody is stored). I use simple php to grab all the players and format all of their information so it can be displayed on the page.

This is the flow of information that I would like:
User clicks on players page browser loads content page (this is a template page), and grabs the pageid from $_GET browser then reads pages table in database to get the pageBody associated with the pageid The pageBody will contain more php, which will run the players script to retrieve the list, and display
Doing it the above way will make it much easier to extend the website to include more types of pages that has to run additional php scripts.
The only way I can think of this working is by doing this:
user clicks on players page
browser loads content page, grabs pageid from $_GET browser checks the pageid for the one associated with players (hard coded into the php script) browser then loads the players.php script instead of going to the database This above way means that I will need to edit the index.php page everytime I add a new list type (example, coaches, volunteers etc).

Anyone have any suggestions? I know my question is long, but I was finding it hard to explain it in an easy to understand way, but I'm still not sure if I have :S.

Cheers
Denno

hey guys

i have this code

FILE NAME "index.php"
Code: [Select]
<?php

// make a connection to the database
mysql_connect ("localhost", "root", "vertrigo") or die ('Error: I Failed To Connect To The Database ' . mysql_error());
mysql_select_db ("test");

// Get Data
 $query = mysql_query("SELECT * FROM TestTable");

// display the data and loop
while ($row = mysql_fetch_array($query)) {
echo "<br /> ID: ".$row['ID']."<br /> First Name: ".$row['FName']."<br /> Last Name: ".$row['LName']."<br /> Contact Number: ".$row['CNumber']."<br />";}


?>

<form method="post" action="update.php">
<table border="1" align="center">
  <tr>
    <td align="right" width="220">ID:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="ID" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220">First Name:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="FName" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220">Last Name:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="LName" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220">Contact Number:&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="text" name="CNumber" size="30" /></td>
  </tr>
  <tr>
    <td align="right" width="220"><input type="reset" value="Reset" />&nbsp;</td>
    <td align="left" width="220">&nbsp;<input type="submit" value="Update Database" /></td>
  </tr>
</table>
</form>

and i also have this code

FILE NAME "update.php"
Code: [Select]
<?php
$ID = $_POST['ID'];
$FName = $_POST['FName'];
$LName = $_POST['LName'];
$CNumber = $_POST['CNumber'];

mysql_connect ("localhost", "root", "vertrigo") or die ('Error: I Failed To Connect To The Database ' . mysql_error());
mysql_select_db ("test");

$query="INSERT INTO testtable (ID, FName, LName, CNumber)VALUES ('".$ID."','".$FName."', '".$LName."', '".$CNumber."')";

mysql_query($query) or die ('Error Updating Database');

echo "Database Updated Sucsessfully With: ".$ID." ".$FName." ".$LName." ".$CNumber ;

?>

ok so the script is working like a charm
its sending the data to the database as i want it to.
the problem i have is that i want to be able to update the info that is already on the database

lets say i want to change a phone/contact number
i have typed the ID number into the ID text field and the same first and last name into there correct boxes and then typed in the new phone number
i then click submit and i get the error ""Error Updating Database""
i have looked all over the forum and net to see what i have done wrong to not allow this code to update

can anyone help me out here please
im quite new to the php language and could really do with some pointers

thanks
Steve

I am trying to make a  setup file for a website I'm developing, and am having the database tables and stored procedures created automatically.  However, I'm having issue getting the stored procedures to be created.  Here is my code:
Code: [Select]
$db->Q("
DELIMITER $$
CREATE PROCEDURE `Database`.`Procedure_Name`(in sp_uid mediumint(20) unsigned, in sp_user varchar(15), in sp_pass varchar(20), in sp_email varchar(30))
BEGIN
Insert Into Table Values (sp_uid, sp_user, md5(sp_pass), sp_email, '1', '1', '0');
Select true;
END$$
");
Assume that the "$db->Q()" works just fine, as I'm having issues no where else with it.  This automatically connects to the database and runs a query with whatever is inside the "()".  The tables are being created just fine, but no stored procedures are being created.  I've tried everything I can think of, and googled my question many different ways without finding an answer or work-through.  Does anyone know what I am doing wrong?

Thanks in advance.

Hey Guys,

I have got 3 chained select boxes working. Basically what you do is check for a region with the country, then once you pick a region, you select a club within that region. Once you have selected the club, you can then choose a team from within that club.

Screenshot: Attchment


As part of this chained select boxes's, a user can register. Although, the user has to FIRST check if the TEAM has already been registered in the database.

I have taken a screenshot of my database, which shows the regions, clubs, and teams from the chained select boxes. What i want to do now is be able to check if a TEAM is already registered in the database. So as you can see in the database, the team 'NPOB, Senior As' has already been taken.

Database Screenshot: Attachment


*** How do i check if a user has been registered to one of the teams? And if there is not a registered user to that team, they can then register it.

Here is my code:


<?php
include"database.php";
?>

<script type="text/javascript">

/*
Triple Combo Script Credit
By Philip M: http://www.codingforums.com/member.php?u=186
Visit http://javascriptkit.com for this and over 400+ other scripts
*/

var categories = [];
categories["startList"] = ["Taranaki","Auckland"]
// Regions + Clubs
categories["Taranaki"] = ["NPOB","Tukapa"];
categories["Auckland"] = ["Marist","Takapuna"];
// Clubs + Teams within that Club
categories["NPOB"] = ["Senior As","Senior Bs","Colts U21s"];
categories["Tukapa"] = ["Senior As","Senior Bs","Colts U21s"];
categories["Marist"] = ["Senior As","Senior Bs","Colts U21s"];
categories["Takapuna"] = ["Senior As","Senior Bs","Colts U21s"];

var nLists = 3; // number of select lists in the set

function fillSelect(currCat,currList){
var step = Number(currList.name.replace(/\D/g,""));
for (i=step; i<nLists+1; i++) {
document.forms['tripleplay']['List'+i].length = 1;
document.forms['tripleplay']['List'+i].selectedIndex = 0;
}
var nCat = categories[currCat];
for (each in nCat) {
var nOption = document.createElement('option'); 
var nData = document.createTextNode(nCat[each]); 
nOption.setAttribute('value',nCat[each]); 
nOption.appendChild(nData); 
currList.appendChild(nOption); 
} 
}

// function getValue(L3, L2, L1) {
// alert("Your selection was:- \n" + L1 + "\n" + L2 + "\n" + L3);
// }

function init() {
fillSelect('startList',document.forms['tripleplay']['List1'])
}

navigator.appName == "Microsoft Internet Explorer" ? attachEvent('onload', init, false) : addEventListener('load', init, false);

</script>


<form name="tripleplay" action="testingdropdown.php" method="post">
<select name='List1' onchange="fillSelect(this.value,this.form['List2'])">
<option selected>Choose Region</option>
</select><br /><br />

<select name='List2' onchange="fillSelect(this.value,this.form['List3'])">
<option selected>Choose Club&nbsp;&nbsp;&nbsp;</option>
</select><br /><br />

<select name='List3' onchange="getValue(this.value, this.form['List2'].value, 
this.form['List1'].value)">
<option selected >Choose Team&nbsp;&nbsp;</option>
</select>
<input type="submit" name="tripleplay" value="Register">
</form>


<?php
     if (isset($_POST['tripleplay'])) {
         
         
     $region = addslashes(strip_tags($_POST['List1']));
     $club = addslashes(strip_tags($_POST['List2']));
     $team = addslashes(strip_tags($_POST['List3']));

    $email = 'email';

$check = mysql_query("SELECT * FROM managers WHERE email='$email'");
           if ($email == '') {
         echo "You can register that club";
         } else {
echo "Sorry that team has already been registered";
}
}

?>

Hello,

Here's my system. Once a user is successfully logged in, a new instance of a User class is created. The constructor of this class grabs the details of the logged-in user from a database and stores them inside properties in the User class.

The problem is, obviously I'd want to access these properties from any page I require them to be able to display user data, so I looked into storing the User object in a Session.

When I tried implementing this, I ran into a bunch of errors and I couldn't figure it out.

Here's an example:

After a user has logged in, I had the following code:
Code: [Select]
$_SESSION['user'] = new User($this->username);
I was under the impression that this assigns a user object to a session. But it's not working as I receive this error:

Quote

Notice: Undefined index: user in ../v2/admin/index.php on line 18



Then on the page I want to display the name of the current user logged-in, I had this code:
Code: [Select]
$_SESSION['user']->get_Name();
But then I get this error:
Quote

Fatal error: Call to a member function get_IP() on a non-object in ../v2/admin/index.php on line 18



Can tell me what I have to do, to make this work?


Thanks.