PHP - Working With Times Stored With One Separate Date.

 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);

 

I have a piece of .php that is supposed to create a type of calendar but it seems to be getting the date wrong and thinks that the date I've selected is 12/31/1969.

Any ideas on how to get it to recognize the date I'm selecting in the form items?

Thanks!

Morgan

[attachment deleted by admin]

Hi, I'm making an RSS feed

http://dev.subverb.net/mixes_rss.php

and as you see the date('r', $row['date']) function is not converting it. I've echo'd $row['date'] into the description to show what format the date is in (just mysql datetime. Am I missing something?

Thanks

I am trying to check if a credit card has expired.

My criterion is whether or not the date submitted is prior to this month if the year matches 2011.

Code: [Select]
// Check for Expired Card.
if (($expYear = date('Y')) && ($expMonth < date('M'))){
$errors['expDate'] = 'Expiration Date cannot be in the past.';
}

Why is this not working?

I chose March 2011 and it fails.

In fact, it fails for any date?!   



Debbie

is there an easy way to add weekdays to a stored date ... so far i have

echo date ( 'Y-m-j' , strtotime ( '5 weekdays' ) );

this adds 5 weekdays to the current date , can i have it add 5 weekdays to say $TableDate 1;

Thanks in advance...

Hi all,

I am trying to figure out how to calculate 5 working days prior to a given date.

I have done some googling but can only see examples of how to add 5 working days onto a date, such as this:

Code: [Select]
$holidayList = array();
$j = $i = 1;

while($i <= 5)

{
    $day = strftime("%A",strtotime("+$j day"));
    $tmp = strftime("%d-%m-%Y",strtotime("+$j day"));
    if($day != "Sunday" and $day != "Saturday" and !in_array($tmp, $holidayList))
    {
        $i = $i + 1;
        $j = $j + 1;
    }
    else
        $j = $j + 1;
}
    $j = $j -1;
echo strftime("%A, %d-%m-%Y",strtotime("+$j day"));
Does anyone know how to calculate 5 working days prior to a date?

Many thanks,

Greens85

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

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.

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?

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);


?>

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>

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

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.

I have a PHP page that offers various information from a single text file. This text file is

encrypted on the server HD.

Upon initial entry into the page, the user enters an encryption/decryption KEY and the

encrypted file is decrypted to clear text and it is available for viewing.

I have some parameters that I store in PHP session variables. I do this since various

subsequent actions by the user will require these parameters. The code is written and the whole process seems to

work well.

Since the info in these session variables is sensitive, I need to understand WHERE they are

stored. I know that it is a file on the HD, but after hours of reading the PHP Manual on

sessions, I am not finding where (HD directory) that storage is.

I have a typical shared hosting account for my web site. Mostly I want to discover is, are

the session variables in y User/file hierarchy, or are they stored in a system area where

the PHP is installed.

Whew. Sorry this was so long.

Thank you,
xphp

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";
}
}

?>