3
Contributors
16
Replies
47
Views
2 Years
Discussion Span
Last Post by diafol
Featured Replies
0

What do you want us to do with this zip file? Not install it I hope? Post your code so we can see it. Untrusted sources (i.e. you) cannot be deemed safe. Besides, why make us work hard to help you?

0

This file contains subfolders if i do code will be lots of snipets,to understand what i need.I will try to do ,but will be lots of code

0

but will be lots of code

No it shouldn't be. Just the relevant bits. Don't dump your whole site here. This is probably a trivial issue, so just show us what we need and nothing else.

0

Please post your codes here instead of giving a link bunch of your sites.. we're trying to help not to complicated this.. :)

0

This are my functions regarding database with php,i include image how it looks like, so i need to add edit buttonwith functional to edit data to the row ,except IDnum.

<?php
//helper functions for database interaction

function queryInsert($connection,$sql)
{
    try {
        if ($connection->query($sql)===TRUE)  //execute the insert sql
        {
        return 1;  //if successful
        }
        else
        {
        return 0;  //if not successful
        }
    }
    //catch exception
    catch(Exception $e) {
        if (__DEBUG==1) 
            { 
            echo 'Message: ' .$e->getMessage();
            exit('<p class="warning">PHP script terminated');
            }
        else
            {   
            header("Location:".__USER_ERROR_PAGE);
            }
    }
}


function deleteRecord($connection,$sql)  //identical to above so we dont really need it
{
    try {
        if ($connection->query($sql)===TRUE)  //execute the sql
        {
        return 1;  //if successful
        }
        else
        {
        return 0;  //if not successful
        }
    }
    //catch exception
    catch(Exception $e) {
        if (__DEBUG==1) 
            { 
            echo 'Message: ' .$e->getMessage();
            exit('<p class="warning">PHP script terminated');
            }
        else
            {   
            header("Location:".__USER_ERROR_PAGE);
            }
    }
}

function query($connection,$sql)  //generic version
{
    try {
        if ($connection->query($sql)===TRUE)  //execute the  sql
        {
        return 1;  //if successful
        }
        else
        {
        return 0;  //if not successful
        }
    }
    //catch exception
    catch(Exception $e) {
        if (__DEBUG==1) 
            { 
            echo 'Message: ' .$e->getMessage();
            exit('<p class="warning">PHP script terminated');
            }
        else
            {   
            header("Location:".__USER_ERROR_PAGE);
            }
    }
}


?>



<?php
//helper functions

function getTableData($connection,$sql)
{
    try {
        $rs=$connection->query($sql);
        return $rs;
    }
    //catch exception
    catch(Exception $e) {
        if (__DEBUG==1) 
            { 
            echo 'Message: ' .$e->getMessage();
            exit('<p class="warning">PHP script terminated');
            }
        else
            {   
            header("Location:".__USER_ERROR_PAGE);
            }
    }
}

function checkResultSet($rs)
    {
    if($rs === false) {
        if (__DEBUG==1)
        {
        echo 'Wrong SQL: ' . $sql . ' Error: ' . $conn->error;
        exit('<p class="warning">PHP script terminated');
        }
        else
            {   
            header("Location:".__USER_ERROR_PAGE);
            }
    } else {
        $arr = $rs->fetch_all(MYSQLI_ASSOC);  //put the result into an array
        return $arr;
    }
}

function generateTable($tableName, $titlesResultSet, $dataResultSet)
{
    //use resultsets to generate HTML tables

    echo "<table border=1>";

    //first - create the table caption and headings
    echo "<caption>".strtoupper($tableName)." TABLE - QUERY RESULT</caption>";
    echo '<tr>';
    foreach($titlesResultSet as $fieldName) {
        echo '<th>'.$fieldName['Field'].'</th>';
    }
    echo '</tr>';

    //then show the data
    foreach($dataResultSet as $row) {
        echo '<tr>';
        foreach($titlesResultSet as $fieldName) {
            echo '<td>'.$row[$fieldName['Field']].'</td>';}
        echo '</tr>';
        }
    echo "</table>";
}

function generateDeleteTable($tableName, $primaryKey, $titlesResultSet, $dataResultSet)
{
    //use resultsets to generate HTML tables

    echo "<table border=1>";

    //first - create the table caption and headings
    echo "<caption>".strtoupper($tableName)." TABLE - QUERY RESULT</caption>";
    echo '<tr>';
    foreach($titlesResultSet as $fieldName) {
        echo '<th>'.$fieldName['Field'].'</th>';
    }
    echo '<th>DELETE</th>'; 
    echo '<th>EDIT</th>'; //////////////////////////////////////////////////////////////////
    echo '</tr>';

    //then show the data
    foreach($dataResultSet as $row) {
        echo '<tr>';
        foreach($titlesResultSet as $fieldName) {
            echo '<td>'.$row[$fieldName['Field']].'</td>';}
        echo '<td>';
        //set the button values and display the button ton the form:
        $id=$row[$primaryKey];  //get the current PK value
        $buttonText="Delete";
        include 'FORMS/buttonWithText2.txt';
        echo '</td>';
        echo '</tr>';
        }



    echo "</table>";
}

function generateDeleteTableCheckBox($tableName, $titlesResultSet, $dataResultSet)
{
    //use resultsets to generate HTML tables

    echo "<table border=1>";

    //first - create the table caption and headings
    echo "<caption>".strtoupper($tableName)." TABLE - QUERY RESULT</caption>";
    echo '<tr>';
    foreach($titlesResultSet as $fieldName) {
        echo '<th>'.$fieldName['Field'].'</th>';
    }
    echo '<th>DELETE</th>';
    echo '</tr>';

    //then show the data
    foreach($dataResultSet as $row) {
        echo '<tr>';
        foreach($titlesResultSet as $fieldName) {
            echo '<td>'.$row[$fieldName['Field']].'</td>';}
        echo '<td>';
        $buttonText="1";
        include 'FORMS/checkbox.txt';
        echo '</td>';
        echo '</tr>';
        }
    echo "</table>";
}



?>


here is the functions for form:

<div><p>
<form  class="button" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
<input name="newTable" type="submit" id="sendButton" value="<?php echo $buttonText?>">
</form>
</div>



<form  class="small_button" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
<button class="smallBtn" name="delrecord" type="submit" value="<?php echo $id;?>"><?php echo $buttonText; ?></button>
</form>


<form class="register" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
<div>
<h2>New Lecturer Registration Form</h2>
<table class="form">
<tr><td>
<label>
<span>Lecturer ID</span><input name="lectID" type="text" >
<span>First Name</span><input name="lectFirstName" type="text" >
<span>Last Name</span><input name="lectLastName" type="text" >
<span>Password</span><input name="lectPass1" type="password" >
<span>Re-enter Password</span><input name="lectPass2" type="password" >
</label>
</td></tr>

<tr><td>
</td></tr>

<tr><td>
<label>
<span>Hit Enter to Register</span>
<input name="send" type="submit" id="sendButton" value="Enter">
</label>
</td></tr>
</table>
</div>
</form>




<form class="register" method="post" autocomplete="off" action="<?php echo $_SERVER['PHP_SELF'];?>">
<div>
<h2>New Lecturer Registration Form (with validation)</h2>
<table class="form">
<tr><td>
<label>
<span>Lecturer ID</span><input name="lectID" type="text" required="true"  title="Lecturer ID (10 Characters)" pattern="[a-zA-Z0-9]{1,10}" data-tip="Enter Characters A-Z,a-z and/or numbers 0-9">
<span>First Name</span><input name="lectFirstName" type="text" required="true" title="First Name (up to 45 Characters)" pattern="[a-zA-Z0-9σαιν']{1,48}">
<span>Last Name</span><input name="lectLastName" type="text" required="true" title="Last Name (up to 45 Characters)" pattern="[a-zA-Z0-9σαιν']{1,48}">
<span>Password</span><input name="lectPass1" type="password" required="true" title="Password (min 5 to 8 Characters)" pattern="[A-Za-z-0-9_]{5,8}">
<span>Re-enter Password</span><input name="lectPass2" type="password" required="true" title="Password (5 to 8 Characters a-z,A-Z,0-9 and underscore)" pattern="[A-Za-z-0-9_]{5,8}">
</label>
</td></tr>

<tr><td>
</td></tr>

<tr><td>
<label>
<span>Hit Enter to Register</span>
<input name="send" type="submit" id="sendButton" value="Enter">
</label>
</td></tr>
</table>
</div>
</form>




<form class="register" method="post" autocomplete="off" action="<?php echo $_SERVER['PHP_SELF'];?>">
<div>
<h2>New Lecturer Registration Form (with validation)</h2>
<table class="form">
<tr><td>
<label>
<span>Lecturer ID</span><input name="lectID" type="text" required="true"  title="Lecturer ID (10 Characters)" pattern="[a-zA-Z0-9]{1,10}" data-tip="Enter Characters A-Z,a-z and/or numbers 0-9">
<span>First Name</span><input name="lectFirstName" type="text" required="true" title="First Name (up to 45 Characters)" pattern="[a-zA-Z0-9σαιν']{1,48}">
<span>Last Name</span><input name="lectLastName" type="text" required="true" title="Last Name (up to 45 Characters)" pattern="[a-zA-Z0-9σαιν']{1,48}">
<span>Password</span><input name="lectPass1" id="password" type="password" required="true" title="Password (min 5 to 8 Characters)" pattern="[A-Za-z-0-9_]{5,8}">

<span>Re-enter Password</span><input name="lectPass2"  type="password" required="true" title="Password (5 to 8 Characters a-z,A-Z,0-9 and underscore)" pattern="[A-Za-z-0-9_]{5,8}">

</label>
</td></tr>

<tr><td><span style="color:#E31717" >Password Strength Indicator-->: </span><span id="result"></span>
</td></tr>

<tr><td>
<label>
<span>Hit Enter to Register</span>
<input name="send" type="submit" id="sendButton" value="Enter">
</label>https://www.mymeteor.ie/
</td></tr>
</table>
</div>
</form>



<div><p>
<form  class="button" action="<?php echo $_SERVER['PHP_SELF'];?>">
<input name="newTable" type="submit" id="sendButton" value="Select Another Table">
</form>
</div>



<form class="getinput" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
<div>
<h2>Select Table Form</h2>
<table class="form">
<tr><td>
<label>
<span>Enter TABLE name</span><input name="tableName" type="text" id="tableField">
</label>
</td></tr>

<tr><td>
</td></tr>
<tr><td>
<label>
<span>Hit Enter to display table</span>
<input name="send" type="submit" id="sendButton" value="Enter">
</label>
</td></tr>
</table>
</div>
</form>

I know looks too much,but will appreciate
if someone could help to add edit button,with functional.

Edited by PulsarScript

0

Ok your code and markup all mixed up. What exactly do you want and where ? Which part of the 356 lines are relevant to your question?

<button name="edit">Edit</button>

But I suspect you want more than that. Without a full explanation, I doubt very much whether you will get an answer that meets your needs.

0

well,if you try to open last zip,its jpg of page and right on side need button edit,same,like delete.

1

sorry not opening any zips. I don't trust you - nothing personal

0

Without picture,i am not able to explain exactly the problem.Ok,thanks anyway,try to get help from different forums.

0

You can upload pictures via this editor.

0

I'm assuming that you want an edit button next to the delete button?

0

Sorry to say but this code is a bit of a mess with the various txt file includes. I think you're looking at

line 174:

    echo '<td>';
    //set the button values and display the button ton the form:
    $id=$row[$primaryKey];  //get the current PK value
    $buttonText="Delete";
    include 'FORMS/buttonWithText2.txt';
    echo '</td>';

I have an inkling that you need to place something here, but not sure what as we need to see the file FORMS/buttonWithText2.txt

0

Thats why i had a zip,where everything in folders and labeled for easy understanding.

0

Not back to that again are we? Most of us - well those of us who care about security - will not download random stuff from the internet. If you want prompt help, lay out all the releveant information in the forum. After all, this is why we have "code tags" and image uploading facilities in the editor. Don't make people work hard to help you. In the time it took you to reply above, you could have posted the content of the text file.

OK, I've had enough here, good luck with it.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.