|
i want to know about insert tbl
|
|
|
|
|
Member 11811156 wrote: i want to know about insert tbl Well, whatever that means, I suggest using Google to search for information.
|
|
|
|
|
I've run out of ideas with this project. My object is just to update
fields in a database table. The 3 records in the table are shown in the
subsequent report. All the fields have a value and the recur values are 'Y', payrec 'P' and periodic '1 or 6' but nothing is updated.
No errors indicated.
Any help?
<?php
echo "<center>";echo date('m/d/y');echo "</center>";
$id="''";
$periodic = '';
$duedate = '';
$con=mysqli_connect("localhost","user","passwd","mydb");
if(mysqli_errno($con))
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
else
{echo "connected to database</br>";}
$fetch="SELECT
acctno, recur, pd, payrec, bname, duedate, datepaid, purpose, amtdue
FROM testbl
WHERE recur = 'Y' AND payrec = 'P'";
$result = mysqli_query($con,$fetch);
if(!$result)
{echo "Error:".(mysqli_error($con));}
else
{echo "database table selected</br>";}
while($data=mysqli_fetch_row($result))
{
if($periodic == 1)
{ $duedate = date('Y-m-d', strtotime('+4 week')) ."\n"; }
if($periodic == 6)
{ $duedate = date('Y-m-d', strtotime('+25 week')) ."\n"; }
$pd = 'P'; $dayslate = 0;
$sql = "UPDATE testbl SET
duedate = $duedate,
pd = $pd,
dayslate = $dayslate,
datepaid = NOW()
WHERE recur = 'Y' AND payrec = 'P'";
}
header( "refresh:3;url='http://localhost/invoice/autolist.php'");
?>
|
|
|
|
|
You created the UPDATE statement but you forgot to execute it against the database.
|
|
|
|
|
I'm sorry but I don't understand what you're saying?
|
|
|
|
|
You execute the SELECT-query with:
$result = mysqli_query($con,$fetch);
You build the UPDATE-statement:
$sql = "UPDATE testbl SET .... (etc)
..but unlike the SELECT-query you never execute it. Your PHP-code simply ends after building the UPDATE-statement-string.
Sidenote: You replied to your own question instead of Richard's reply, so he didn't get a notification.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
The statement
$sql = "UPDATE testbl SET ...
merely creates a string variable, and then continues the while loop. You never send the string to MySQL to update the database.
|
|
|
|
|
I have a data of more that 500000 records which want to search data and fill in dropdown list. I am using dropdown list its working buts it is very slow
<script type = "text/javascript">
var ddlText, ddlValue, ddl, lblMesg;
function CacheItems() {
ddlText = new Array();
ddlValue = new Array();
ddl = document.getElementById("<%=ddlItems.ClientID %>");
lblMesg = document.getElementById("<%=lblMessage.ClientID%>");
for (var i = 0; i < ddl.options.length; i++) {
ddlText[ddlText.length] = ddl.options[i].text;
ddlValue[ddlValue.length] = ddl.options[i].value;
}
}
window.onload = CacheItems;
function FilterItems(value) {
ddl.options.length = 0;
for (var i = 0; i < ddlText.length; i++) {
if (ddlText[i].toLowerCase().indexOf(value) != -1) {
AddItem(ddlText[i], ddlValue[i]);
}
}
lblMesg.innerHTML = ddl.options.length + " items found.";
if (ddl.options.length == 0) {
AddItem("No items found.", "");
}
}
function AddItem(text, value) {
var opt = document.createElement("option");
opt.text = text;
opt.value = value;
ddl.options.add(opt);
}
</script>
<asp:TextBox ID="txtSearch" runat="server"
onkeyup = "FilterItems(this.value)"></asp:TextBox><br />
<asp:DropDownList ID="ddlItems" runat="server" DataTextField="Description" DataValueField="NumericCode" >
</asp:DropDownList>
|
|
|
|
|
If you're showing 500000 items then a dropdown is the wrong thing to use. Use an autocomplete textbox instead. Google for how to write one.
|
|
|
|
|
Server 2008 R2, IIS 7.5
I've got a user that can't get a website to work for them. Below is the error received. It says "Anonymous"?
??? Anonymous auth is disabled.
I can get to it, so ASP itself is enabled. The server also has multiple classic ASP sites that work fine.
The user is using IE 11 (as am I)
Any ideas?
HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.
Detailed Error Information
Module
IIS Web Core
Notification
MapRequestHandler
Handler
ASPClassic
Error Code
0x80070002
Requested URL
<a href="http://<redacted>/default.asp">http:
Physical Path
C:\inetpub\wwwroot\<redacted>\default.asp
Logon Method
Anonymous
Logon User
Anonymous
|
|
|
|
|
That error does imply that the physical file doesn't exist - the other common causes of a 404 error would typically have a different sub-status code[^].
Are you absolutely sure that you're loading exactly the same URL as the user, and that the host name is resolving to the same IP address / server?
Try using Failed Request Tracing[^] to capture the details of the failed request, to see if there's anything obvious that you've missed.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I sent them the link the click, so it had better be the same URL. :p
The DNS should be ok, the URL in the error is correct, so they at least attempted to hit the right one.
I'll try the tracing.
It's such a pita to troubleshoot users who are umpty miles away. You can't whack them on the back of the head easily.
Thanks
|
|
|
|
|
What about use Fiddler to check traffic?
|
|
|
|
|
Oh, we're not allowed to do anything like that.
Seriously. Government work is SO much fun.
Anyway, the problem was either fixed or no one cares anymore. I'm not even sure which. :p
|
|
|
|
|
|
hi i havent been coding long, im learning on my own using the internet, youtube etc.
i am trying to us all the knowledge ive learn so far to code a basic website. i have having a couple of problems.
1/ first this error message is appearing on the console when i inspect the webpage i am creating??
Uncaught SyntaxError: Unexpected token <
2/ second i cant seem to do simple actions with css on my html using the bootstrap classes, i know its all correct in terms of the files being connected to sublime as i can copy and paste from bootstrap and the nav bars with drop downs work fine. (i assume that if they work that it all set up properly on my text editer?)
i am trying to centre the logo, heading and menu at the moment.
This is my html code.....
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Cupcake Fixation</title>
<link href='http://fonts.googleapis.com/css?family=Indie+Flower' rel='stylesheet' type='text/css'>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="logo" "col-md-2">
<img src="http://www.drawingnow.com/file/videos/image/1376476137.jpg"/>
</div>
<header class="container">
<h1>Cupcake Fixation</h1>
<p><strong>"We take your addiction seriously!"</strong></p>
</header>
<div class="container-fluid">
<ul class="nav navbar-nav" "navbar-default" >
<li class="nav" class="active"><a href="#">Home<span class="glyphicon glyphicon-heart"</span></li></a>
<li class="nav"><a href="#">About<span class="glyphicon glyphicon-heart"</span></li></a>
<li class="nav"><a href="#">Recipies<span class="glyphicon glyphicon-heart"</span></li></a>
<li class="nav"><a href="#">Frosting<span class="glyphicon glyphicon-heart"</span></li></a>
<li class="nav"><a href="#">Contact Us</li></a>
</ul>
</div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script type="text/javascript" src="http://twitter.github.io/bootstrap/assets/js/bootstrap-dropdown.js"></script>
</body>
</html>
|
|
|
|
|
The first problem is most likely caused by the "drop downs" script at the bottom:
http://twitter.github.io/bootstrap/assets/js/bootstrap-dropdown.js[^]
That URL gets redirected to the Bootstrap 2.3.2 home-page[^], which isn't a javascript file.
It looks like that script was build for Bootstrap v2. Assuming you're using Bootstrap v3[^] - which you should be, since v2 is no longer supported - the old script wouldn't work anyway. Bootstrap v3 already includes support for drop-downs, so you can simply remove that script tag.
Your "logo" tag is incorrect - the "col-md-2" should be part of the class attribute:
<div class="logo col-md-2">
That class means that the logo will take up 1/6th of the page width. It doesn't have anything to do with centring the element.
Bootstrap : Grid system[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
You need to close the anchor tag before closing the listitem tag
li a /li /a <-- should be --> li a /a /li
There are strangers on the Plain, Croaker
|
|
|
|
|
Just Wellformed your html and Close your span tag that is not closed inside UL and Li.
Use the Below Code
<ul class="nav navbar-nav" "navbar-default" >
<li class="nav" class="active"><a href="#">Home</li></a>
<li class="nav"><a href="#">About</li></a>
<li class="nav"><a href="#">Recipies</li></a>
<li class="nav"><a href="#">Frosting</li></a>
<li class="nav"><a href="#">Contact Us</li></a>
</ul>
|
|
|
|
|
I asked Google and Bing, "WEBSITE MOCKUP TOOL"
They found me...
Good and bad opinions on any of these are welcome.
The overriding goal for me is a short learning curve.
"Features" will be gladly sacrificed for simplicity in this case.
modified 17-Jun-15 14:03pm.
|
|
|
|
|
Hello, I have a page on a label applied CKEditor, HTML code as follows:
<textarea id="MyHtmlEditor" class="ckeditor" cols="80" rows="10" name="MyHtmlEditor"></textarea>
When I upload and then insert a picture, you can see the pictures in normal CKEditor, the viewing source will appear <img alt = "" src = File Name /> tag code.
Because it will put more than one picture, if I want to do in a certain period of time to execute javascript, you can get all the content in the editing area where CKEditor <img alt = "" src = filename /> src attribute values
That is made all the pictures of connecting position.
I found a CKEditor stall, it seems that only the editorial content replace () method can be used.
Some people know how to reach this level?
|
|
|
|
|
Hello.
I´m building a web page that have an administrator user, he can create new users with specific fields. All of this in html5, php and MySQL.
The question is.. Do you know a framework or process that show to the administrator the list of users that he created, with some fields with options to modify, in other tab of the web page.
I appreciate your help .
|
|
|
|
|
You are thinking of a database file (.db), which you create in Microsoft Access (or any other database editing software), then you host that file on the internet along with all your other files. Then whenever you want to create a new user, you can add another row into the database table.
|
|
|
|
|
$latlayer = array(
array('minW' => 0 , 'minH' => 0 , 'maxW' => 8.5 , 'maxH' => 4.8 , 'val' => 'lat1' ),
array('minW' => 8.5 , 'minH' => 4.8 ,'maxW' => 17 , 'maxH' => 9.6 , 'val' => 'lat2' ),
array('minW'=> 17 , 'minH' => 9.6, 'maxW' => 25.5 , 'maxH' => 14.4 , 'val' => 'lat3' ),
array('minW' => 25.5 , 'minH' => 14.4, 'maxW' => 34 , 'maxH' => 19.2 , 'val' => 'lat4' ),
array('minW' => 34 , 'minH' =>19.2, 'maxW' => 42.5 , 'maxH' => 24 , 'val' => 'lat5' ),
array('minW' => 42.5 , 'minH' => 24, 'maxW' => 51 , 'maxH' => 28.8 , 'val' => 'lat6' ),
array('minW' => 51 , 'minH' => 28.8, 'maxW' => 59.5 , 'maxH' => 33.6 , 'val' => 'lat7' ),
array('minW' => 59.5 , 'minH' => 33.6, 'maxW' => 68 , 'maxH' => 34.8 , 'val' => 'lat8' ),
array('minW' => 68 , 'minH' => 34.8, 'maxW' => 76.5 , 'maxH' => 43.2 , 'val' => 'lat9' ),
array('minW' => 76.5 , 'minH' => 43.2, 'maxW' => 85 , 'maxH' => 48 , 'val' => 'lat10' ),
array('minW' => 85 , 'minH' => 48, 'maxW' => 93.5 , 'maxH' => 52.8 , 'val' => 'lat11' ),
array('minW' => 93.5 , 'minH' => 52.8, 'maxW' => 100 , 'maxH' => 50 , 'val' => 'lat12' ),
);
$wimg = 20;
$himg = 9.6;
foreach($latlayer as $current)
{
if( $wimg >= $current['minW'] and $wimg <= $current['maxW'])
{
echo $current['val'];
break;
}
}
result lat 2 OK no problem one value checked
The problem with checking the tow value of the array
minW-maxW and minH-maxH = lat?
|
|
|
|
|
$wimg = 20;
$himg = 9.6;
foreach($latlayer as $current)
{
if( $wimg >= $current['minW'] and $wimg <= $current['maxW'] and himg >= $current['minH'] and $himg <= $current['maxH'])
{
echo $current['val'];
break;
}
}
Result : Error no parametrs
|
|
|
|
|