PHP - Php Data Specific Variables On Page.

Hi guys ..   please help me .. I don't know how to do this and I tried but there were no satisfied  results..   I want to retrieve a Title (ing_title) from a database called k_db2 , in a table called content_langs  depending on its ID , which called ing_contID   example: if ing_contID=1 , then show the ing_title with this id ing_contID   the above code should be in a php file ..   then I want to include this php file inside the header of my website.. by importing the ing_contID from the database and depending on it the title should be shown..     I really tried but I couldn't find any solution ..   if you could help me in the first part of this problem I'll be glad ..

I am trying to get specific data from a MySQL table but cannot seem to find a proper command.

Code: [Select]
                $link = mysqli_connect('#####', '########', '########');
$user = $_SESSION['username'];
$email = mysqli_query($link,"select email from members where username='$user'");
echo $email;

Specifically, I am trying to get the email address stored for the user specified by the session, and display that address.
However, I do not get any output with the current code, and am not sure what to try next. I have tried mysqli_fetch_row() but it only returns an error.

Hello All,

Please excuse my lack of knowledge in advance, I'm a beginner but pick things up relatively quickly, and tend to do things by trial and error.

I would appreciate any help that anyone could offer with the following:

I would like to retrieve two pieces of data from a "text file" and use them to calculate a result from a function I have in javascript. An example of the javascript code is:

<script type="text/javascript">
function calculate() {
var drybulb = document.calc_form.drybulb.value;
var relhum = document.calc_form.relhum.value;
var answer = '';
if (drybulb !== '' && relhum !== '') {
answer = (0.567*drybulb*1) + (0.393 * (relhum*1/100 * 6.105 * Math.exp(17.27 * drybulb / (237.7 + drybulb*1)))) + 3.94;
}
document.calc_form.answer.value = answer;
return false;
}
</script>

Currently this is evaluated with entry from a simple html form, but I would like to have this performed "automatically".


The "text file" that I would like to access is here, not on my server:

http://www.bom.gov.au/fwo/IDV60901/IDV60901.94870.axf

I would like to extract the "air_temp" and "rel_hum" values under the [data] section for use in my function. I just need the "most recent" values (i.e. first), not all those contained in the file. This is a single record from that section (sorry for the mess this no doubt makes):

[data]
sort_order,wmo,name[80],history_product[80],local_date_time[80],local_date_time_full[80],aifstime_utc[80],air_temp,apparent_t,cloud[80],cloud_base_m,cloud_oktas,cloud_type[80],cloud_type_id,delta_t,dewpt,gust_kmh,gust_kt,lat,lon,press,press_msl,press_qnh,press_tend[80],rain_trace[80],rel_hum,sea_state[80],swell_dir_worded[80],swell_height,swell_period,vis_km[80],weather[80],wind_dir[80],wind_spd_kmh,wind_spd_kt
0,94870,"Moorabbin Airport","IDV60901","27/10:00pm","20120227220000","20120227110000",18.8,19.3,"Partly cloudy",510,3,"-",-9999,0.8,17.5,13,7,-38.0,145.1,1013.5,-9999.0,1013.5,"-","11.4",92,"-","-",-9999.0,-9999,"10","-","S",11,6



Would it be possible to obtain these values using PHP?, and if so any advice on how this could be done (noting my minimal knowledge) would be greatly appreciated.

Cheers.

This topic has been moved to Microsoft SQL - MSSQL.

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

Hello,   First of all I'd like to say thank you for all the great information on the forums, I've been reading a lot on here lately.   I've started to make a website where users can log in and submit items to a database, which is then displayed on another page. If Tom and Bill both post 10 items, all 20 items will be displayed on the "listings" page, however on the main log in screen Tom will only see his own 10 items and Bill will see his own 10 items.   This is all working perfectly, however, I now need to add a delete button so that they can delete specific items. I have loosely followed this tutorial here to get the table to display as I want it (amongst a few other things, such as the user logins) http://www.wickham43...mphptomysql.php I've added the delete button in the PHP loop for each row, I just can't figure out how to delete the specific row when clicked.   Any help would be really appreciated
Edited by eklem, 22 October 2014 - 08:10 AM.

SELECT * FROM `booking_tbl` WHERE booking_status = 'Check In' AND departure_date_time = NOW()"

I use the datetime datatype for the departure_date_time so i can get data from that data because it checking the date and time   but i want it to check on the date from the datetime datatype   So how can i get the data only with that date without the time in the mysql datetime datatype

Hello. I'm a newbie so sorry if this isn't the best forum to post my problem.   I am using a MySQL and PHP to create a web app. I have authentication, and I can register users. I also have a form that users provide information and it is successfully inserting data into a table in my database.   I will use fictional fields for my database table called meal_info:   username dateStartedDiet numberMealsPerDay costPerMeal   Problem: Select user-specific data from the MySQL database, using Session username to select only the current user's data, then display it and do some calculations.   Here is thecode at the top, and I am fairly sure it's working:   session_start(); //execute commone code require("common.php"); //includes code to connect to database, etc. if(empty($_SESSION['user'])) 

I am not sure if the title is correct; I tried my best. I'm a PHP/MySQL beginner and I really need some help. I have a small script that I am using for sending SMS. I recently added a phonebook. The problem with the phonebook right now is that it's available to all users, i.e. they can all update and delete all rows. What I would like to do is make it so that each user can update and delete only their own contacts. I have a table call contacts. Inside that table there is first name, last name, company and phonenumber. How can I accomplish this with PHP & MySQL?

CREATE TABLE IF NOT EXISTS `contacts` (
`contact_id` int(10) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`company` varchar(255) NOT NULL,
`cell_no` text NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(30) NOT NULL,
`uname` varchar(30) NOT NULL,
`u_pass` varchar(60) NOT NULL,
`utype` varchar(30) NOT NULL,
`timezone` varchar(30) NOT NULL,
`uapi_user` varchar(30) NOT NULL,
`uapi_pass` varchar(60) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

<?php
if (isset($_POST['submit'])){
    //form has been submitted1
    $firstname  = trim($_POST['firstname']);
    $lastname   = trim($_POST['lastname']);
    $company    = trim($_POST['company']);
    $cellno = trim($_POST['cell_no']);

    if($firstname == ''){
        echo '<div class="alert alert-danger">First Name is not Valid!</div>';
        exit;
    }elseif($lastname == ''){   
        echo '<div class="alert alert-danger">Last Name is not Valid!</div>';
        exit;
    }elseif($company == ''){    
        echo '<div class="alert alert-danger">Company is not Valid!</div>';
        exit;
    }elseif($cellno == ''){ 
        echo '<div class="alert alert-danger">Cellphone Number is not Valid!</div>';
        exit;

    }else{

        $query = "Select cell_no from contacts where cell_no = '".$cellno."' ";
        $result = mysql_query($query);
        if (!mysql_num_rows($result)) {

        $sql = "INSERT INTO contacts(firstname, lastname, company, cell_no)
                            values('{$firstname}','{$lastname}', '{$company}', '{$cellno}')";
        $result = mysql_query($sql);
        confirm_query($result);

        //echo '<div class="alert alert-success">Successfully added.</div>';
        //exit;
        ?>
                    <script type="text/javascript">
            window.location = "contact_list.php";
        </script>
    <?php
    }
    else{

        echo '<div class="alert alert-danger">Username. already exist!.</div>';
        echo '<p><a href="new_contact.php" class="btn btn-success"> Back </a></p>';
        exit;

    }}

}else{
    $firstname  = "";
    $lastname   = "";
    $company    = "";
    $cellno = "";
}

?>

I have a table and the structure is Code: [Select]
ID, UID, Site, Uname, PassI already have this <?php

$result = mysql_query(sprintf("SELECT * FROM Logins WHERE UID = %d", $_COOKIE['UID_WatsonN']));
//check login table against cookie
if(($num = mysql_num_rows($result)) > 0){
mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>ID</th>
<th>UID</th>
<th>Site</th>
<th>Uname</th>
<th>Pass</th>
</tr>
<center>
<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"ID");
$f2=mysql_result($result,$i,"UID");
$f3=mysql_result($result,$i,"Site");
$f4=mysql_result($result,$i,"Uname");
$f5=mysql_result($result,$i,"Pass");
?>

<tr>
<td><?php echo $f1; ?></td>
<td><?php echo $f2; ?></td>
<td><?php echo $f3; ?></td>
<td><?php echo $f4; ?></td>
<td><?php echo $f5; ?></td>
</tr>

<?php
$i++;
}
}
?>

which only gets the data from that one person. What is in the table is usernames and passwords for diffrent sites and i want to take all the usernames and passwords and put them into variables to pass on to the login form.

I have two table in my database combined by using  UNION, when it come to searching via search form, all data are retrieved as expected, but the problem come when i click the link that has the data from second table it redirecting to the page with first table details.

Assume i have  retrieved data using while loop and the UNION.

 while($search = $query->fetch()) {?> 
       <div>
       	<a href="pageone.php?po=<?php echo $search['pr_id'];?>">Read More...</a>             
       </div>
<?php }?>

//the result become

<a href="pageone.php?po=1">Read More...</a>             
<a href="pageone.php?pt=3">Read More...</a>

//But what if data come from both first and second table in a database, i want the link become to be as

<a href="pageone.php?po=1">Read More...</a>             
<a href="pagetwo.php?pt=3">Read More...</a>

// any idea please

 

 

is it possible to disable warnings on a specific page?
php.ini set to show warnings

Hi Everyone,

I'm trying to convert my MySql data into variables so I can use them on my website. For example, if I want to convert a city or even first or last name into a variable. How would I go about doing that? Thanks everyone!

Hey all,

I am having a situation where I have a singleton class with a static array in it.  I insert an element into that array, and then I redirect the user to another page.  At that page, I then retrieve that array (it's stored in the session vars), but the array is then empty when I retrieve it.  I can't figure out why.

Here are some pertinent code snippets.

First, the class with the static array:

class Logger
{

private static $instance = NULL;

private static $messages = array();

//Private constructor to prevent this class from being instantiated multiple times

private function __construct()

{

}

//The clone function is private to prevent cloning of this class

private function __clone()

{

}

//Returns the singleton instance of this class

public static function GetInstance()

{

if (!self::$instance)

{

self::$instance = new Logger;

}

return self::$instance;

}

public static function GetMessageCount()

{

return count(self::$messages);

}

public static function LogMessage($new_message)

{

self::$messages[] = $new_message;

}

public static function GetMessages()

{

return self::$messages;

}

public static function ClearMessages()

{

self::$messages = array();

}
}


Here is the code where I insert something into the aformentioned array (the process is that a user tries to log in, but the login fails, and so we insert a message into the array saying that the login credentials failed).


//Retrieve the message logging instance from the session data to be able to pass messages to the user.
$message_log = $_SESSION['user_messages'];
$user = $_SESSION['user_account'];

//Create a new instance of the database management class and
//try to connect to the database
$dbm = new DBM();
if ( !$dbm->isConnected() )
{

$message_log::LogMessage("We are sorry, but we are unable to access the database at this time.  Please try again later.");
}
else
{

//Retrieve the user login information

$useremail_dirty = $_POST['useremail'];

$password_dirty = $_POST['userpassword'];

//Check to see if the email we were given exists in the database, and if the password matches

$doesPasswordMatch = $dbm->doesPasswordMatch ( $useremail_dirty, $password_dirty );

if ( $doesPasswordMatch )

{

//Correct login information was received.  Login the user and redirect appropriately.

$user->Login();

header ( "Location: ".BASE_URL."/userpage.php" );

exit;

}

else

{

//If an incorrect email or password was given, report that information to the user.

$message_log::LogMessage("Incorrect login information.");

}
}

//The user has failed to login.  Redirect to the appropriate page.
header ( "Location: ".BASE_URL."/loginfailed.php" );


And finally, given an unsuccessful login attempt, this is where I pick back up the array of messages to display the messages to the user:

$message_log = $_SESSION['user_messages'];
$all_messages = $message_log::GetMessages();

print $message_log::GetMessageCount()."<br>";
print count($all_messages)."<br>";

foreach ($all_messages as $message_string)
{

$prepared_string = prepare_text_for_html_output($message_string);

echo $prepared_string."<br>";
}

$message_log::ClearMessages();


Unfortunately, the "all_messages" variable has nothing in it...it's like the messages that I logged in the previous PHP script never even existed.  I am calling session_start, so don't worry about that (even though it's not seen in these code snippets).  What could be going wrong?

warning: I'm a self taught advanced newbie.

I'm working on a multipage PHP app that has need to pass values between pages, usually very small text strings or small integers.  I've designed it primarily using _SESSION variables to pass these bits of data.  Some of them are written to SQL, but most of them are temporary in nature.

Is using _SESSION variables in this capacity considered reasonable?  Is there something else or a different way to go about this?

(Page A writes a value into $_SESSION['myvalue'], and then page B grabs that data and does something with it.)

Hi All,

I have done a select from my DB and the data contains a '.

echo "<td><a class='btn btn-primary col-sm-12' data-toggle='modal' data-userid='" . $uid . "' href='#userModal' data-firstname='" . $ufn ."' data-lastname='". $uln."' data-email='" . $ue . "' data-accountlevel='" . $ualid . "' data-mobile='".$um ."'data-role='".$urid."' data-active-sheets='".$ename."'>Manage</a></td>";

outputs

<a class="btn btn-primary col-sm-12" data-toggle="modal" data-userid="2" href="#userModal" data-firstname="Chelsea" data-lastname="Hockley" data-email="chelsea@hotmail.com" data-accountlevel="1" data-mobile="0774882" data-role="1" data-active-sheets="A new event,Chelsea" s="" event'="">Manage</a>

the issue part

data-active-sheets="A new event,Chelsea" s="" event'=""

Should be

data-active-sheets="A new event,Chelsea's event"

How do i prevent the ' from causing me this issue?