Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    PHP


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





How To Access And Modify And Add Records In MySQL Table From A Windows Client?


The MySQL table is located in a Linux Server OS, so I need the
information from that table for updating Paradox tables in Windows OS.
If a PHP program in the Linux Server can save a file with the
information I need, can I make a PHP program in Windows OS to get the
saved file or even better, to access the table in the Linus Server OS?...




View Complete Forum Thread with Replies

Related Forum Messages:
How To Control Access To Specific Mysql Records For A User
I am just trying out a php form, when posted submits data to database. The system is we allow everyone to submit the form. As administrator I can view and edit the records. But whoever submits the form should be a registered user and he should be able to only view his records but not edit.

View Replies !
Having Trouble Looping Through Records In A MySQL Table
I'm having some trouble looping through the records of a MySQL table using PEAR DB. Here is my code:

$navigationSql = "SELECT * FROM nav";
$navigation =& $db->query($navigationSql);
while ($navigation->fetchInto($nav)){
define("NAVIGATION", "<a href="$nav[2]" target="$nav[3]" title="$nav[1]">$nav[1]</a><br />"); }

The when I enter:
print NAVIGATION;

into any of my PHP scripts it should loop through the stuff in table named nav, but it is only displaying the first record and so far everything I've tried does not seem to make it loop through all of the records in the table and I can't figure out why not.

View Replies !
Transfer Edited Records From One MySQL Table To Another
What I need is for a user to search a certain database table for a purchase order #. The results then need to be displayed in textboxes so they can be edited as needed.

Then the edited records need to be inserted into another table, and deleted from the former. I have the first two steps coded, but am having trouble figuring out how to do the third correctly. Here is my code:

View Replies !
How To Modify Records With A Button Or Check Box...?
I need some help creating a "modify / update records" page. Something that will grab a record and allow the user to post information into the fields that haven't been filled yet.

I already have my create record page, I just don't know how to make a modify page. I'm also not sure if I should use checkboxes to select the record then modify on a different page or just allow the user to modify on the same page.

The theory behind the worksheet is a person enters the customer name and date the contract is created. When we get confirmation, the person who received the confirmation enters the date it was received, the person who received it and who it was credited to.

View Replies !
Count,sort,diplay Number Of Records In MySQL Table
I am designing a search engine using PHP/MySQL and I am logging all search terms into a MySQL table. I was wondering how I count the number of occurences of a term in the table, and then sort and display the terms in descending order. For example, if the column in my table with search terms looked something like this:

clothes
casinos
clothes
homes
homes
clothes

How can I count and order the records so that I can display according to how many times they appear, like so:

1. clothes(3 entries)
2. home(2 entries)
3. casinos (1 entry)

View Replies !
Automatic Delete From MySQL Database Table Expired Records?
I have a question . . .

how can i delete from MySQL database table automatic expired records ?
?

One think is to make a service that deleting the expired records . . .

Any other method ?



View Replies !
Get Windows Client Login
I have to create an intranet website by php, sql server and IIS.
One requirement is to get the user name from the windows client login.
I'd like to know if it is possible, and if yes how?

I think it should be possible by asp, but in php?

View Replies !
MSSQL - Unix Client / Windows Server
I need to access a MSSQL 7.0 database on a Windows NT Server from a Linux PHP Web-server.
I have looked at FreeTDS, unixODBC and iODBC. unixODBC seems the easiest but alas one need to buy licenses. iODBC is a bit slow, apart from the ODBC part containing many connection layers, it also has a request broker/client running on top of the ODBC.

FreeTDS seems like a decent solution. It even has the option of using TDS in conjunction with iODBC. This eliminates the use of the extra request broker/client. Furthermore I've read somewhere that one can use the Sybase functions of PHP to connect to a MSSQL server since both use the TDS (Tabular Data Stream) Protocol. What method would be the easiest and/or could be implemented using the ADOdb database abstraction layer class?

View Replies !
Client Filesystem Access
I want to deliver subscripted content to users on CD. They then place
the CD into their CD drive and navigate to my site. Once logged in, I
want to be able to draw content from the CD and incorporate it with
content from my server.

I understand that access to the user's filesystem is not normal or even
allowed by default. However I am wondering if there is a workaround to
this limitation.

In Javascript, I can offer the user a security certificate that, if
acknowledged, will allow me to access their filesystem. Is there
something like that in PHP?

View Replies !
Php Session Problems When Working With A Windows Client Program
I am currently involved in a project that involves a windows client
program written in delphi and a web application written in php. I
have made several php pages for the delphi program to do requests via
the http component from INDY. the problems I am having are:

1) the first request from delphi app to php web app is the
authenication. In which user sends username + password to the php app.
If authenication is valid, a session is started and the sid is
returned to the client. All subsequent requests from delphi app to
php web app will have this sid as one of the arguments in the POST
form request (this is one of the function in the INDY component for
delphi). Even the sid is passed to the subsequent pages, the session
global array is still undefined. However if I open up a web browser
and create my own string request to the login page then the next page,
the global array would be defined (using var_dump + echo to see the
array) what is the problem?

2) does the above problem has anything to do with the http referer
field?

3) this problem that I am having has been asked before on google
group, but somehow the person who asked it didnt' put down the
solution for it. (this only involves the web only) when I login on a
page and return with a session id, then I log out.. the user is
redirected to the login page again. However if the user login again
(with a different login account), he would be presented with the same
session ID as before. a different sesson id is presented only if the
user restart the browser. why is that happening?

View Replies !
Use Php And Apache To Host My Website On A Windows Client For Others To View?
I use php and apache to host my website on a windows client for others to view? If so, can someone tell me how to publish this for others to view through their internet browser?  We are all on the same network. I dont have to publish it publicly just host it for other users on the same domain as me will work for now.

View Replies !
Random Records From Access Database ?
I am retrieving records from an access database in php.But i want to select random 7 records....how can it be done ?

View Replies !
Restricting Access To A Records Contents
I have a table called Reports . These are reports of different users . Now if 2 users attend a meeting, they each make separate reports which get stored. When a third user attends another meeting on the same subject, he creates a third record.

I have been fiddling around with ways of updating records such that a single report can be updated by all 3 users. But it results in even a 4th user being able to view the report (if not update) and i just dont know how i can limit this.  The issue here is that a situation can arise when the 4th user may need to read the report but until the time he needs to, i dont wish to allow access to that report. Code:

View Replies !
Inserting Records Into A Microsoft Access Database...
I'm still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database.

I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL?

So far I've seen only mysql examples and havent been able to find anything on access...

View Replies !
MSSQL Access Via PDO And Windows ODBC
I'm running a "Windows Server 2003" with "MS SQL 2000" IIS and PHP5.1 as
test environment for my project. I would like to access my MSSQL-Server
via Windows ODBC and PDO. I created a System DSN an i enabled the PDO
extension in my php.ini. But the following code snippet keeps failing:

<?php
try
{
$DB = new PDO("odbc:LocalServer");
}
catch (PDOException $e)
{
echo $e->getMessage() . "<br>";
exit;
}
?>

Here is the error message:

"could not find driver"

View Replies !
Send Mail From Windows Without Access To Php.ini?
I've found example on how to send email using PHP on Windows 2000. However they
all say to set the outgoing SMTP server address in the php.ini file in the
Windows system directory.

That's a problem for me because I intend to upload this to my hosting company's
server, where I do not have access to the system directory. Each user on this
system has their own virtual mail server.

Is there a way to specify the mail server in the script itself?

View Replies !
Moldap_modify() [function.ldap-modify]: Modify: Strong(er) Authentication Required
hello when I try to modify entries in ldap using function ldap_modify
every time I got an error : Moldap_modify() [function.ldap-modify]:
Modify: Strong(er) authentication required .....

View Replies !
Windows Network File System Access
I'm trying to get an intranet application to create folders on another machine, on the same network.

I can get to it via '192.168.7.201FolderName', and have also mapped the network location '192.168.7.201' the the drive 'S'. Code:

View Replies !
ODBC Connectivity Through ISeries Access For Windows
I would like to connect with JDE database using iSeries Access for Windows[system DSN] using php. Code:

View Replies !
Registry Operation In PHP(Need To Read Some Windows Registry Key On Client Machine)
Are there any Registry function available in PHP for reading the
registry key on the client machine(WindowsXP,Win2K).(I don't need any
write operation to the registry).

I need to do certain validation for some application on the client
machine by reading the registry entry created by some other external
application(.exe).

View Replies !
Access Active Directory (of WINDOWS SERVER 2003) Via LDAP
I want to read user information from the microsoft windows 2003 server.

In the windows server 2003, i've create a domain, called "wissenskolleg".
I've assigned a password to it.

Now, i want get access to the Active Directory with PHP.

My code:

$ds=ldap_connect("wissenkolleg.com");
$r=ldap_bind($ds,"administrator","psword");

Always I've get the following error message: warning: ldap_bind(): For
Unable ton bind tons of servers I've found out, that $ds always return: Resource id #2 If i changed "wissenkolleg.com" in "whyitis", it is all the same, i've can only read: Resource id #2 and the same error with ldap_bind.

View Replies !
Can MySQL Modify
I've seen a web program which uses .mdu files. What exactly are these and how do they work as I can't seem to find much information on the net.

View Replies !
Displaying # Of Records In A Table
Can anyone throw me a link to some prefab code, or a tutorial on how I can get a page to display the number of records that meet a certain criteria.

example:
I have a page that stores information on audio FX. I'd like to include a feature that would let the users know how many items are in a particular section.

Player (10)
Items (5)
Weapons (0)
etc.

All help appreciated,

View Replies !
Counting Records In A Table
Ok, I am trying to count the number of records in one of my tables. Seems simple. BUT! its not working. It returns a 2 no matter how many records are in there.

Heres the code.

<?php
$sql = "SELECT count(*) from cam";
$result = mysql_query($sql);
?>

I would think this would work.
I have also tried mysql_num_rows, and max(), and sum()...
a little help would be appreciated, and why is it returning a 2?

View Replies !
Delete Records From A Table
I have a table its called queue. It has a field called id. I want to delete all records in the table apart from the ones with id equals to 74 or 75 or 87. How do i do that?

View Replies !
Displaying Records In Table
I have a table that I want to display some records from my database. I have a specific spec I'd like the table to conform to, 3 cells wide.

I can get the data into a cell. But my problem is, I'd like the table to have the 3 cells fill and then have the additional data create a new rows and continue on infinately.

View Replies !
How Do I Get The Total Records From A Table?
It also shows the total submissions. Right now, when you choose to view by a particular topic (for example, select a region - California) the total submissions only shows for those results (which right now is 1). I'd like to show the total results not just for California (which right now is 4). Code:

View Replies !
Retrieve The Last 10 Records In Table
well this is my 1st post & im wondering if someone can give me the syntax to display the last 10 entries in a table for example if there are 100 records 1 to 100 i want to select 90 - 100.

View Replies !
Delete Records From Table 1
I have a script that doesn't delete records from one database when it should, and now I have to do this myself because database is big and causes problems on the server. What I have is:

TABLE 1, field auction
TABLE 2, field id

so I would like to delete all records from TABLE 1 where the value of the field auction doesn't match the value of the field id in TABLE 2. Can someone help me on this, please? I need to get this database cleaned.

View Replies !
Table Row Records For Editing
I have a repeat region of a table called userid. What i¹m trying to accomplish is being able to edit the record and then update it by clicking a submit button on the same line. I¹m doing it this way so the user can quickly update a number of records one at a time. I know I could do this by passing the userid info to a detail page but really want
to do it the way described.

View Replies !
Showing Records In A Table
I am busy with the site of the company I work for. We have a section where al our partners are mentioned. At this moment this is a static part of the website that I want to make dynamically. This is the url of the static page and how it should look like: This is the url of the dynamic page I created but it doesn't work the way that I want: This is the php code I used: Code:

<?php

$i=0;
echo "<tr>";
while (list($id, $vlag, $land, $bedrijf, $website, $email) = mysql_fetch_row($result)){

echo "<td><table>-Content with the data of the records-</table></td>";

if($i % 2 == 0) {
echo "</tr><tr>";.

View Replies !
AJAX To Display New Records In A Table
Instead of refreshing the entire page to show the new fields in a
table, I was wondering if it would be possible to use AJAX to display
the new records in a table.

For example:

Messages are entered into the DB. I use PHP to create a table that
displays the messages.

Instead of refreshing the entire page to show the table with new
messages, how can I use AJAX to show the new messages in the table
without refreshing the entire page?

View Replies !
Counting The Number Of Records In Table
I want to count the number of records which apply to a repeating id field. (the user id remains the same, but their are several records which relate to the user. I want to know how many records in the table exist for a specified user id) Does anyone know a function for doing this?

View Replies !
Linking Multiple Records From Another Table
I'm not sure I'm even thinking about this the right way, but here goes:

I have a table of users. Each one of these users may be associated
with none, one, or many records in another table I call a todo table.
table user = 'id', 'name', 'bla bla bla','todo_list'
table todo = 'id','title','other info'

Suppose user 'id=1253' has on his todo list items 756,241, and 672. I
create a string 756,241,672 and store that string in the user's
todo_list field. Then when I want to display the todo items I get the
string with a query, bust it up into an array, iterate the array and
query the todo table.

I have a gut feeling I'm making it way more complicated than need be.
But I can't think of any other way to do it

View Replies !
Table Join Count Records.
got my counting records script just the way I want it, now I've read all the posts on Joins, and read the manual and mysql.com.... but can't seem to get the right number to come out.

I have two tables: table1 & table 2

table one has a field called ID and field two has a field called relID (this is the link between them) I want to count all of the records in table two where the relID is equal to the table 1 ID field. I thought this would do it, but the number it returns is wrong:
PHP Code:

View Replies !
Copy Select Records To New Table
In the table Step I have multiple records for each given id. I want to save the current list of records for an id to a new Step_Old table so I can look back at what I had at a given point in time, since the records for an id in the Step table will change over time.

Now the question... does anyone have a slick way to do this, or do I need to Select all the records I want to save and then save them one by one with a while loop into the Step_Old table?

View Replies !
Displaying Records In A Split Table?
trying to split up results of a query into a split table. example: PHP Code:

View Replies !
Count The Number Of Records In A Table
I just want to count the number of records in a table that meet a certain set of conditions: Getting an error: Warning: mysql_result(): supplied argument is not a valid MySQL result resource code:

View Replies !
Checking $_POST Against Records In Table
I have a table containg name, description, url which contains many records When I submit a new form, I want it to check the url fields in the table and check it against what I have posted. Therefore something like

$check_table = function here to get all urls

if($_POST['url'] == $check_table) {
return false;
} else {
return true}

However, how do I get all the urls and get it to check each one?

View Replies !
Insert Multiple Records In Table
I want to use a form to insert multiple records into a table. I have an book club where a person would rank a book (3 to 1) next to a particular book read for a particular month. 3 being the most favorite book read that month and 1 being least favorite. Below is the table the records would be inserted into.

Key----Month--------Reader---------Rank-------Book
1-------January-------Jim--------------3----------Bible
2-------January---------Jim-------------2----------Koran
3-------January---------Jim-------------1-----------Torah

How can I have a form where the reader sees only (and fills in) the rank and book text fields, and the Key, Month, and Reader fields are filled in behind the scenes with the default info when the form is submitted .

View Replies !
Updating Multiple Records Of A Table
I would like to update multiple records of a table in the database. Code:

View Replies !
Delete Selected Records From Table.
Can anyone see why this connection doesn't work? It's suppose to delete selected records from my table.

<?php

if (isset($_POST['delete'])) // && isset($_POST['delcus']))
{

foreach ($_POST['delcus'] as $val)
{
echo "$val";
$conn= mysql_connect( "localhost", "user", "password" );
$sql = mysql_select_db( "snow" );
$del = mysql_query("DELETE * FROM request WHERE qid =" .$val);
//$rows = mysql_num_rows($del);
$rs = mysql_query($conn, $sql, $del);
if($rs)
.........................

View Replies !
Having Trouble Inserting Records To A Table.
currently i am using the code:

$query ="INSERT INTO table_name (Field_name) VALUES ($name)";
$result = mysql_query($query);

and it doesnt seem to be inserting.

am i doing it wrong?

View Replies !
Checking If Any Records Exist In A Table
I've had a few problems with the mysql_fetch_array() string, and have worked out that it's because there are no records in the table.

Does anyone know of a way of checking if there are any records, so that I can create an if statement?

View Replies !
How To Paginate Table To 1/2 Records Per Column
I am setting up a scrapbook page and we will be adding images all the time. I have a dynamic table to show the image, link and description but I want to break the columns to automatically show 1/2 the images in the first column, and the other 1/2 (or less if its an odd number of images) in the right column. Code:

View Replies !
Adding Multiple Records To A Table In One Form.
I have one form in a php page. In that form there are several rows, each with several input boxes. These rows represent individual products and their price.

You may add as many products as you want by clicking a add product button and it will add another row using javascript.

When you are finished adding your products you then click submit. For each product I would like it to insert an individual record in the products table.

For example if you add 10 products, when you click submit it will add 10 records in the product table.

View Replies !
Select All The Records In A Table That Were Input Last Month
I am trying to select all the records in a table that were input last month, example:if month today is October select all record with month of September The query I am using is
PHP Code:

SELECT payments.*, members.*
FROM payments, members
WHERE payments.coupon_id  = &#39198;C554360'
AND payments.member_id = members.member_id
AND payments.begin_date < NOW() - INTERVAL(1 MONTH)

This display an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONTH)' at line 1 I am not sure if my query is written correctly.

View Replies !
SQL Question (selecting Records From A Table With A Codthat Do Not Appear On Another)
I need to select the records from a table that DO NOT have a record in another table. For Example:

Table1
Code | Name
0 | AA
1 | A0
2 | A00

Table2
Code1 | Code2
1 | 100
2 | 200

So the SQL would return only the record "0 | AA" from the table "Table1". Any ideas?

View Replies !
MySQL And PHP - Modify The Html Code In The Content
I'm using mySQL and PHP on a webhost, and WordPress. ...

Wordpress is what I'm using to make it easy for my pops to post articles.
My index.php uses some code to pull from the mySQL db (created by wordpress)
and puts the post content into a div, then p class. However, I'm noticing
that when the content contains html coding, it seems to fall out of the
class and lose it's padding. Is there some command I need to use to modify
the html code in the content when it's posted to my page?

Below is what I think is the relevant code: You can check the results at
www.meetwithkbh.com (yes, it's got a goal). If there's no html like <ul>'s
and <li>'s included in the post, it formats fine with the padding, but - if
there is, it'll drop out of the padding that i'm trying to keep.

<?php
$db = mysql_connect("localhost", "mywordpressdb", "*******"); /*no, these
aren't the real user/pass ;) */
mysql_select_db("dbwordpress",$db);
$result = mysql_query("SELECT id, post_title, post_content, post_date_gmt
FROM wp_posts ORDER BY post_date_gmt DESC Limit 0, 5",$db);
while ($myrow = mysql_fetch_row($result)) {
echo "<div class="post">
<p class="posttitle">";
printf("%10.60s", $myrow[1]);
echo "</p>";
echo "
<p class="postcontent">";
printf("%10.400s",$myrow[2]);
echo "...<a href="More.php">Read More</a></p>
</div><br />
";
}
mysql_close($db);
?>

Here is the css, contained in the index.php too, which is in the proper
place in the index.php:
..posttitle { font-size: 120%;
font-weight: bold;
color: white;
background: #806C59;
padding: 3px 3px 3px 1em;
margin-top:0em;
}

..postcontent { padding-left:2em;
padding-right: 2em;
text-align: justify;
}

..post {
border: 1px solid #cccccc;
line-height:1em;
}

View Replies !
Query Problem: Counting Records From Another Table Without Using A Subquery
I'm working on a rather complex SQL query, which retrieves a list of clients that match certain criteria. One of the criteria I need to test is the number of business days that have elapsed since the client's enrollment.

To facilitate this, I've created and populated a table called business_days - containing one record for every business day (non-weekends and non-holidays) for the next ten years. Using this, I can just count the number of business_days between two dates, like this: Code:

View Replies !
Moving Through Records In Table In A Single Record Page
I'm trying to create a updates pages that I can move either to the previous
record or the next record within a recordset without having to return to the
repeating list of records after each up date.

Assuming I have done the recordset correctly, which I have and the update
records command as well here is the code I'm trying to use: Code:

View Replies !
Create Dynamic Table With 3 Columns And Unknown Number Of Records?
I'm trying to create a table with only 3 columns, but the problem is I don't know how many records will populate the table so need it to automatically create <tr> and </tr> tags every 3 records. How best can I do this?

At present the code below just lists every single record in one continuous row - but as I said, I want to only display 3 records per row. Code:

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved