Click here to Skip to main content
15,867,568 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: How to get USB token Client Digital Certificate in ASP.net ? Pin
Richard MacCutchan1-Jul-15 3:09
mveRichard MacCutchan1-Jul-15 3:09 
Question.Net Web Development tutor needed Pin
Harry Real29-Jun-15 12:25
Harry Real29-Jun-15 12:25 
AnswerRe: .Net Web Development tutor needed Pin
Anil Vaghasiya14-Jul-15 21:06
professionalAnil Vaghasiya14-Jul-15 21:06 
QuestionInsert the Calender park Schedule ,Change all the calender in different colour to block the date for any event, park close and etc.by using mvc with entity frame work for database Pin
Member 1176716728-Jun-15 16:10
Member 1176716728-Jun-15 16:10 
QuestionRe: Insert the Calender park Schedule ,Change all the calender in different colour to block the date for any event, park close and etc.by using mvc with entity frame work for database Pin
Richard MacCutchan28-Jun-15 21:38
mveRichard MacCutchan28-Jun-15 21:38 
AnswerRe: Insert the Calender park Schedule ,Change all the calender in different colour to block the date for any event, park close and etc.by using mvc with entity frame work for database Pin
Member 118111563-Jul-15 0:47
Member 118111563-Jul-15 0:47 
GeneralRe: Insert the Calender park Schedule ,Change all the calender in different colour to block the date for any event, park close and etc.by using mvc with entity frame work for database Pin
Richard MacCutchan3-Jul-15 2:43
mveRichard MacCutchan3-Jul-15 2:43 
Questionhelp w/updating mysqli Pin
Charlie Kirk27-Jun-15 17:15
Charlie Kirk27-Jun-15 17:15 
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
    <?php
echo "<center>";echo date('m/d/y');echo "</center>";
$id="''";
 $periodic = '';
 $duedate = '';
$con=mysqli_connect("localhost","user","passwd","mydb");
// ============== check connectiont
    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>";}

// ----------------------------------------

   // output data of each row
   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'");
?>

AnswerRe: help w/updating mysqli Pin
Richard MacCutchan27-Jun-15 21:18
mveRichard MacCutchan27-Jun-15 21:18 
QuestionRe: help w/updating mysqli Pin
Charlie Kirk28-Jun-15 10:06
Charlie Kirk28-Jun-15 10:06 
AnswerRe: help w/updating mysqli Pin
Sascha Lefèvre28-Jun-15 10:20
professionalSascha Lefèvre28-Jun-15 10:20 
AnswerRe: help w/updating mysqli Pin
Richard MacCutchan28-Jun-15 21:37
mveRichard MacCutchan28-Jun-15 21:37 
Questionsearchable dropdown with large dataset Pin
byka26-Jun-15 1:59
byka26-Jun-15 1:59 
AnswerRe: searchable dropdown with large dataset Pin
F-ES Sitecore26-Jun-15 2:40
professionalF-ES Sitecore26-Jun-15 2:40 
QuestionUser Can't Get To Classic ASP Web Site Pin
GenJerDan24-Jun-15 5:34
GenJerDan24-Jun-15 5:34 
SuggestionRe: User Can't Get To Classic ASP Web Site Pin
Richard Deeming24-Jun-15 6:18
mveRichard Deeming24-Jun-15 6:18 
GeneralRe: User Can't Get To Classic ASP Web Site Pin
GenJerDan24-Jun-15 6:30
GenJerDan24-Jun-15 6:30 
AnswerRe: User Can't Get To Classic ASP Web Site Pin
Aladár Horváth3-Aug-15 3:40
professionalAladár Horváth3-Aug-15 3:40 
GeneralRe: User Can't Get To Classic ASP Web Site Pin
GenJerDan3-Aug-15 3:54
GenJerDan3-Aug-15 3:54 
QuestionAny one using spark API Pin
Rahul Singh Tomar19-Jun-15 23:36
Rahul Singh Tomar19-Jun-15 23:36 
Questionfeeling frustrated please help me Pin
Member 1177761319-Jun-15 1:35
Member 1177761319-Jun-15 1:35 
AnswerRe: feeling frustrated please help me Pin
Richard Deeming19-Jun-15 2:18
mveRichard Deeming19-Jun-15 2:18 
AnswerHtml not well formed Pin
Ferd Really23-Jun-15 7:30
Ferd Really23-Jun-15 7:30 
AnswerRe: feeling frustrated please help me Pin
Anil Vaghasiya14-Jul-15 21:43
professionalAnil Vaghasiya14-Jul-15 21:43 
QuestionWireframe / Mockup tools Pin
C-P-User-317-Jun-15 7:10
C-P-User-317-Jun-15 7:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.