[[SOLVED] Quick Question]

Don't forget to mark topic as SOLVED

 

Ray

[[SOLVED] Convert H:M:S to Seconds]

Sorry forgot you were using access and odbc

 

replace with this

$time = array();
$sql = "SELECT Date, Extension, Duration
FROM AllInfo 
WHERE Extension = '$ex' AND Date=#$id#
GROUP BY Date, Extension";
$result = odbc_exec($odbc, $sql) or die(odbc_error());
while($r = odbc_fetch_array($result)){
$time[] = $r['Duration'];
}

 

Ray

[[SOLVED] Increment all records by 1]

LOL I don't ask how his data is setup, just answer the question. I know the potential problems with something like this, but I just help give the answer.

 

Ray

[Disable buttons in form]

you would query the database first to get the number of clicks then just use a simple if statement.

 

<?php
$disabled = $r['tablefield'] > 1 ? "disabled=\"disabled\"" : "";
echo "<input type=\"submi\"t name=\"submit\" value=\"submit\" $disabled />\n";
?>

 

Ray

[[SOLVED] Quick Question]

format is like this

 

$query = "SELECT player_id, type, price, username, crew, crewname
          FROM dom_london
          INNER JOIN user_info ON user_info.id = dom_london.player_id
          INNER JOIN crews ON user_info.crew = crews.id
          WHERE dom_london.id = '$section'";

 

Ray

[[SOLVED] Database Connection Error]

look at your db class and make sure your variables are in the right locations.

 

$db = new Database('localhost','database name','password','database name');

 

It is probably a mistype but you have database name in there twice. want to make sure your values are in the right place

 

Ray

 

 

[[SOLVED] Increment all records by 1]

<?php
$sql = "UPDATE `tablename` SET `Number` =  `Number`+1";
mysql_query($sql) or die(mysql_error());
?>

 

Ray

 

[[SOLVED] Quick questions]

sanatize() is probably a custom function someone has made, and the @ in front of the POST variable will suppress generating an error if the variable is not set.

 

Ray

[Tidy and Modern Web Address question]

It can also be a script which seperates the url into parts then includes a certain part of the url as a page.

 

example

You start of in www.acme.com/index.php. on that page you have a link which goes to www.acme.com/about. At the top of index.php you have something like this

<?php
$uri_split = explode("/", $_SERVER['REQUEST_URI']);
$tmp = array();
foreach($uri_split as $key => $val)
{
	if(!empty($val) || $val != "")
	{
		$tmp[count($tmp)] = $val;
	}
}
$uri_split = $tmp;
if(!isset($uri_split[0]))
{
	$uri_split[0] = "about_us";
}?>

 

Now you just include the page in index.php

include($uri_split[0]);

 

hope I got that right. Just grabs bits from one of my scirpt.

 

Ray

 

[How to send data in a form]

since you came out of php for your link you have to go back in to get the value

 

?><a href='menulist.php?resid=<?php echo $row->clientID; ?>'>View menu</a><?

 

Ray

[[SOLVED] Convert H:M:S to Seconds]

What type of column is the Duration field. If it is just a text or varchar field, you will get the error. problem is the duration column can't be summed because it has those special characters in it. so a function will have to be made to add them up. try this out

 

<?php
function get_seconds($t){
$seconds = 0;
  if(is_array($t)){
    foreach($t as $v){
    $array = array();
    $pt1 = array();
    $pt2 = array();
    $array = explode(':', $v);
    $pt1[] = $array[0];
    $pt2 = explode("'", $array[1]);
    $time = array_merge($pt1, $pt2);
    $sec = $time[2];
    $min = $time[1]*60;
    $hour = $time[0]*60*60;
    $seconds += ($sec+$min+$hour);
    }
  } else {
  $array = explode(':', $t);
  $pt1[] = $array[0];
  $pt2 = explode("'", $array[1]);
  $time = array_merge($pt1, $pt2);
  $sec = $time[2];
  $min = $time[1]*60;
  $hour = $time[0]*60*60;
  $seconds += ($sec+$min+$hour);
  }
return $seconds;
}
$time = array();
$sql = "SELECT Date, Extension, Duration 
	FROM AllInfo 
	WHERE Extension = '$ex' AND Date=#$id#				
	GROUP BY Date, Extension";
$result = mysql_query($sql) or die(mysql_error());
while($r = mysql_fetch_assoc($result)){
$time[] = $r['Duration'];
}

$seconds = get_seconds($time);
echo "<td class=\"borderTable\"><center>".date("H:i:s", mktime(0, 0, $seconds))."</center></td class=\"borderTable\"></table><p></p>";
?>

 

Ray

[[SOLVED] is there anything like implode, but vertically?]

my bad I forgot <h> tags don't start a new line.

<?php
$s = array(33,34,35,36);
$values = implode("', '", $s);
$query="SELECT * FROM $tbl_name WHERE id IN ('$values')";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result))
{
echo '<h5>', ($row['rem1']), '</h5><br />';
}
mysql_free_result($result);
?>

 

Ray

[how to enable windows login dialog in php/apache]

Try this here

 

http://sourceforge.net/projects/mod-auth-sspi

 

Ray

[MySQL Queries]

There is no need to count rows to get the loop to end. The while statement will only run as long as rows are being returned. It will stop on it's own when the end is reached.

 

Also remember that field names and table names should be in backticks (`) and field values should be in single quotes (').

 

<?php
$totalweight = 0;
$query = "SELECT `weight` FROM `sites` WHERE `user` = '$user'";
$result = mysql_query($query) or die(mysql_error());
while ($sites = mysql_fetch_assoc($result)){
$totalweight += $sites['weight'];
}
$query = "UPDATE `user` SET `weight` = '$totalweight' WHERE `user` = '$user'";
$result = mysql_query($query) or die(mysql_error());

?>

 

Ray

[Simple checkbox to database question]

Thing with checkboxes is they are not passed if they are not checked. so you will have to put a check before you insert into the database

 

$SubscribeToNewsletter = isset($_POST['SubscribeToNewsletter']) ? "1" : "0";

 

Now if it is set $subscribeToNewletter will equal 1 if not is will be equal to 0;

 

Ray

 

[[SOLVED] Convert H:M:S to Seconds]

First thing you should know is this.

you can get the minutes from using the date and mktime function

 

echo "<td class=\"borderTable\"><center>".date("g:i", mktime(0, $row["CountOfDuration"]))."</center></td class=\"borderTable\"></table><p></p>";	}

 

does this return just one row??

Duration contain seconds or minute??

DurationS holds ??

Do you want to show a running total or something like that??

 

Ray

 

 

 

 

[error in a php, mysql script]

try using 775 not 777. Some hosts won't allow 777.

[error in a php, mysql script]

Try using the absolute path for your directory locations.

 

Example

$path = '/var/www/html/panel/modules/mysql/'.$row_User['homedir'].'/_Backups';

 

Also when working with directories leave out the last slash

 

Ray

[MySQL Queries]

Probably your best bet. Not sure how often the API information changes. You could set up a script to run from a cron job to update the database once a day or something. Then querying the database would take milliseconds.

 

Ray

[MySQL Queries]

the query is very simple and should not take any time at all, I would think it is the API's that are taking time to retrieve the information.

[[SOLVED] Convert H:M:S to Seconds]

try this

<?php
function get_seconds($time){
$array = explode(':', $time);
$pt1[] = $array[0];
$pt2 = explode("'", $array[1]);
$time = array_merge($pt1, $pt2);
$sec = $time[2];
$min = $time[1]*60;
$hour = $time[0]*60*60;
$seconds = $sec+$min+$hour;
return $seconds;
}

$time = "2:20'13";
echo get_seconds($time);
?>

 

Ray

[MySQL Queries]

Try this out

 

<?php
$query = "SELECT `impressions`, `url` FROM `sites`";
$result = mysql_query($query) or die(mysql_error());
while ($sites = mysql_fetch_assoc($result)){
$url = $sites['url'];
$impessions = $sites['impressions'];
$weight = ceil($dmozbonus*$indexed*($impressions*$siteprbonus*5996)/(750000 - $impressions));
$update = "UPDATE `sites` SET `weight` = '$weight' WHERE `url` = '$url'";
mysql_query($update) or die(mysql_error());
}
?>

 

Ray

[MySQL Queries]

I edited my post above but to help out more you may want to show your table data and let us know what you want to accomplish. Or should I say what your final result should be.

 

Ray

[MySQL Queries]

Where is the weight value coming from??

 

Also where is the url value coming from?? It looks like you are comparing the url to each field in each row that is returned.

 

Ray

[MySQL Queries]

You seem to be complicating things here.

 

Are you trying to update the weight field for all your rows??