|
PHP - Moved: Pagination With Sql Server 2008
This topic has been moved to Microsoft SQL - MSSQL.
http://www.phpfreaks.com/forums/index.php?topic=358946.0 Similar TutorialsThis topic has been moved to Installation in Windows. http://www.phpfreaks.com/forums/index.php?topic=318822.0 For reasons unknown to me I installed this version of MSSQL 2008 R2 yesterday and it came with an attached database for which I was able to add my own database to. I had to uninstall and reinstall this version because I was having some permissions conflicts....now when I reinstalled the 2008 R2, there is no database attached. There is no preinstalled db engine. I do not know how to create this or drop my db into the object explorer because there is no db attached. I hope this makes sense.
What I am trying to do is set up a test server on my home computer. I saved the actual db from a work computer onto a thumbdrive. Now, I want to attach it to my home server. That option is not there to connect now. Thank you for any help.
To access MySql tables from PHP, I use the PHP code and the function below. If I make these changes, would this code work for SQL Server 2008? mysql_fetch_array to mssql_fetch_array mysql_connect to mssql_connect mysql_select_db to mssql_select_db mysql_query to mssql_query PHP code -------------------------------------------------------------------------------- $sql = "SELECT mast_id FROM district_mast WHERE mast_district = '".$dist_num."'"; $result = func_table_access($sql); $rows = mysql_fetch_array($result); Function -------------------------------------------------------------------------------- FUNCTION func_table_access($sql) { $db = "aplustutoru"; $host = "localhost"; $user = "root"; $pass = ""; IF (!($conn=mysql_connect($host, $user, $pass))) { PRINTF("error connecting to DB by user = $user and pwd=$pass"); EXIT; } $db3 = MYSQL_SELECT_DB($db,$conn) or die("Unable to connect to local database"); IF ($sql <> "justopendb") { $result = MYSQL_QUERY($sql) OR DIE ("Can not run query because ". MYSQL_ERROR()); RETURN $result; } } This topic has been moved to Installation in Windows. http://www.phpfreaks.com/forums/index.php?topic=358758.0 Hey guys, i was wondering if any1 cud help me. I have a database search engine that I'm currently working on, everything seems to be working fine locally including pagination but as soon as i upload the site online, the pagination doesn't work properly. when you use the search bar the results on the first page are correct, but as soon as you click next or page 2 it automatically returns wrong data. how can i fix this since it works fine locally???
This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=349156.0 This topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=315683.0 This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=358297.0 This topic has been moved to mod_rewrite. http://www.phpfreaks.com/forums/index.php?topic=314170.0 This topic has been moved to Other Web Server Software. http://www.phpfreaks.com/forums/index.php?topic=317797.0 This topic has been moved to PHP Installation & Configuration. http://www.phpfreaks.com/forums/index.php?topic=330078.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=314251.0 Great conversation, wrong board. This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=357967.0 This topic has been moved to PHP Installation & Configuration. http://www.phpfreaks.com/forums/index.php?topic=345977.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=352526.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=310661.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=321861.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=333230.0 Hello everyone. I'm trying to learn php here on the fly because i've been tasked with moving an existing internal website to a new server because the old one is failing fast. The failing server is very old and running a much older version of php. This form when submitted should send an email but the submit button doesn't even show when running the form on the new server. Also, right now all the text fields are showing the VALUE= value. I notice if I remove VALUE= from each part that removes the text but I'm not sure if that's the proper way to fix it.
Also, after the "Please wait for confirmation..." message, there is one text box prepopulated with \"ds\", then one below it with \"Click, then it appears to dump the rest of the code after </FORM> up to the last ?> onto the webpage as text.
I'm guessing some coding methods changed between php4 and whatever the newest version of php is that comes with a fresh linux server install. Can anyone offer any tips or fixes? Thanks in advance.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Update My Phone Number</title>
</head>
<body bgcolor="White" >
<table width="640">
<tr><td><hr width="640" size="2" color="Red" align="left"></td></tr>
<tr><td align="left"><font size="+3"><strong>Update Employee Telephone Numbers</strong></font></td></tr>
<tr><td><hr width="640" size="2" color="gray" align="left"></td></tr>
</table>
<br>
<?
$form_block = "
<FORM METHOD=\"post\" ACTION=\"$PHP_SELF\">
<p><strong>Employee name: <font size=\"-1\"><em>(Exactly as it should be listed)</em></font> <font color=\"#FF0000\">**Required</font></strong><br>
<INPUT TYPE=\"text\" NAME=\"employee\" VALUE=\"$employee\" SIZE=\"75\" MAXLENGTH=\"100\"></p>
<p><strong>Department: <font size=\"-1\"><em>(Exactly as it should be listed)</em></font> <font color=\"#FF0000\">**Required</font></strong><br>
<INPUT TYPE=\"text\" NAME=\"department\" VALUE=\"$department\" SIZE=\"75\" MAXLENGTH=\"50\"></p>
<p><strong>Work Phone Number <font color=\"#FF0000\">**Required</font></strong><br>
<INPUT TYPE=\"text\" NAME=\"work\" VALUE=\"$work\" SIZE=\"15\" MAXLENGTH=\"15\"></p>
<p><strong>Cell Phone Number <font color=\"#FF0000\">**Required -- enter \"na\" for not applicable</font></strong><br>
<INPUT TYPE=\"text\" NAME=\"cell\" VALUE=\"$cell\" SIZE=\"15\" MAXLENGTH=\"15\"></p>
<p><strong>Home Phone Number <font color=\"#FF0000\">**Required -- enter \"na\" for not applicable</font></strong><br>
<INPUT type=\"text\" Name=\"home\" VALUE=\"$home\" SIZE=15 \" MAXLENGTH=\"15\"> </p>
<p><strong>Pager Number <font color=\"#FF0000\">**Leave blank if you don't have a pager</font></strong><br>
<INPUT type=\"text\" Name=\"pager\" VALUE=\"$pager\" SIZE=15 MAXLENGTH=\"15\"> </p>
<p><strong>Comments:</strong><br>
<TEXTAREA NAME=\"message\" ROWS=5 COLS=50 WRAP=virtual>$message</TEXTAREA></p>
<br>
<p><em>Please wait for confirmation - this may take a few seconds.</em></p>
<INPUT type=\"hidden\" name=\"op\" value=\"ds\">
<p><INPUT TYPE=\"submit\" NAME=\"submit\" VALUE=\"Click here to send this report\"></p>
<br>
</FORM>
";
if ($op != "ds") {
//they need to see the form
echo "$form_block";
} else if ($op == "ds") {
if ($employee == "") {
$employee_err = "<font color=red>Please enter employee name! **REQUIRED</font><br>";
$send = "no";
}
if ($department == "") {
$department_err = "<font color=red>Please enter your department! **REQUIRED</font><br>";
$send = "no";
}
if ($work == "") {
$work_err = "<font color=red>Please enter your work phone! **REQUIRED</font><br>";
$send = "no";
}
if ($cell == "") {
$cell_err = "<font color=red>Please enter your cell phone! ** REQUIRED, enter \"na\" for not applicable</font><br>";
$send = "no";
}
if ($home == "") {
$home_err = "<font color=red>Please enter your home phone! *REQUIRED, enter \"na\" for not applicable!</font><br>";
$send = "no";
}
if ($send != "no") {
// it's okay to send
$msg = "Please update the following phone numbers for: \t$employee\n\n";
$msg .= "Employee name:\t$employee\n\n";
$msg .= "Department:\t$department\n\n";
$msg .= "Work:\t$work\n\n";
$msg .= "Cell:\t$cell\n\n";
$msg .= "Home:\t$home\n\n";
$msg .= "Pager:\t$pager\n\n";
$msg .= "Comments:\t$message\n\n";
$to = "me@me.com";
$subject = "Phone Update: \t$employee, - \t$department\n";
$mailheaders = "From: UpdateMyPhone\n\n";
mail($to, $subject, $msg, $mailheaders);
echo "<h1><font color=blue>Thank you! Your phone update has been filed. </font></h1><br> $form_block ";
} else if ($send == "no") {
echo "$employee_err";
echo "$department_err";
echo "$work_err";
echo "$cell_err";
echo "$home_err";
echo "$pager_err";
echo "$message_err";
echo "$form_block";
}
}
?>
</body>
</html>
This topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=333987.0 |
|||||||